To me the table structure looks fine, it would be one line per classified ad.
If they can place more than one ad at a time, it wouldn't matter to the database. You would write your scripts to allow for multiple instances of ads and then submit them through a loop, inserting them one at a time. Works much like a shopping cart, you have one table for the order and a related table that holds all the products associated with that order. Sometimes orders have many products in them and you just loop through inserting each product into the productOrder table. I hope this helps .. looks like you are fine! Paul Giesenhagen QuillDesign 417-885-1375 http://www.quilldesign.com ----- Original Message ----- From: "Doug Brown" <[EMAIL PROTECTED]> To: "CF-Talk" <cf-talk@houseoffusion.com> Sent: Wednesday, August 16, 2006 10:06 PM Subject: Database design question > I am creating a classifieds e-commerce site and was wondering...I have > the following columns that need to be in the database, and was wondering > if you would split them up into seperate tables. I am thinking no, but not > sure. > > I was considering letting customers place more than one ad at a time > and was thinking if I should use a structure to hold the info or if I > should create a temp_table that gets cleared out say once a week or more. > What would be better performance wise? > > (ads) > ad_id > cust_id > cat_id > sub_cat_id > ad_text > qty_on_hand > ship_method > item_condition > unit_type > refund_policy > is_negotiable > ad_title > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:250107 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
