[sqlalchemy] What's the common practice to represent data like account status ('active', 'inactive', etc,..)

2011-11-13 Thread espresso maker
Here are few columns that I am not sure how to represent their data in the database. Columns like 'status' in account indicating the account status. Columns like 'type' indicating the account type 'business', individual', 'reseller'. Granted I can normalize them and create tables for each. but

Re: [sqlalchemy] What's the common practice to represent data like account status ('active', 'inactive', etc,..)

2011-11-13 Thread Michael Bayer
On Nov 13, 2011, at 11:51 PM, espresso maker wrote: Here are few columns that I am not sure how to represent their data in the database. Columns like 'status' in account indicating the account status. Columns like 'type' indicating the account type 'business', individual', 'reseller'.