I'd probably use INT and also get some FOREIGN KEYs in there...
On Feb 2, 2011, at 11:46 AM, Madhu Alagu wrote: > Hi > > I am looking best model for the following tables: > > ----- > --- Table : groups_t > ----- > > CREATE TABLE groups_t > ( > id BIGINT NOT NULL, > code VARCHAR NOT NULL, > version BIGINT NOT NULL > ); > > ----- > --- Table : groups_i18n_t > ----- > > CREATE TABLE groups_i18n_t > ( > group_id BIGINT NOT NULL, > lang_id BIGINT NOT NULL, > description TEXT NOT NULL, > version BIGINT NOT NULL > ); > > ----- > --- Table : groups_lookup_t > ----- > > CREATE TABLE groups_lookup_t > ( > group_id BIGINT NOT NULL, > lang_id BIGINT NOT NULL, > code VARCHAR NOT NULL, > description TEXT NOT NULL, > lookup_text TEXT NOT NULL > ); > > Thanks > > Madhu Alagu > > -- > You received this message because you are subscribed to the Google Groups > "sqlalchemy" group. > To post to this group, send email to [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/sqlalchemy?hl=en. > -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
