coffeecup Posted January 17, 2010 Share Posted January 17, 2010 I am looking at a 7 item, line item, character storage for up to 300 clients. should i break that up to 7 tables, one table for each line item. or would i be insane to place item_1 through item_7 in one table with a char (250). current MySQL V = 5.1.37 and will upgrade to most recent V when i go online. Thank you Link to comment https://forums.phpfreaks.com/topic/188738-preliminary-table-set-up/ Share on other sites More sharing options...
ignace Posted January 17, 2010 Share Posted January 17, 2010 item_1 through item_7 in one table is bad design. Give us some more details and I may help you normalize your database. Link to comment https://forums.phpfreaks.com/topic/188738-preliminary-table-set-up/#findComment-996526 Share on other sites More sharing options...
coffeecup Posted February 6, 2010 Author Share Posted February 6, 2010 item_1 through item_7 in one table is bad design. Give us some more details and I may help you normalize your database. Thank you, i went back read and re read many times the normalization and made seven tables. Link to comment https://forums.phpfreaks.com/topic/188738-preliminary-table-set-up/#findComment-1008046 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.