Hey,
I've got a question concerning my database design. I would like to
rewrite my website for small ads.
There are two possible ways of creating my database:
1) Put all in one big table
simplified example:
id (1)
name (2)
address (3)
zip (4)
city (5)
request_type (6)
description (7)
size (8)
location (9)
style (10)
instrument (11)
user_id (12)
For some small ads i need fields 1,2,3,4,5,6,7,10,11
for another ones i need fields 1,2,3,4,5,6,7,8,9,12
Each row would be saved in one table with some fields empty.
2) Different model/tabel for each category
instruments
id
name
address
zip
city
request_type
description
style
instrument
common
id
name
address
zip
city
request_type
description
size
location
user_id
I think I need about 6 or 7 categories...
The big question:
Should I create a extra model and database table for each small ad
category (version 2), or should I pack all categories in one table
(version 1)?
Regards,
Cronet
--
Our newest site for the community: CakePHP Video Tutorials
http://tv.cakephp.org
Check out the new CakePHP Questions site http://ask.cakephp.org and help others
with their CakePHP related questions.
To unsubscribe from this group, send email to
[email protected] For more options, visit this group at
http://groups.google.com/group/cake-php
