|
scm22ri
Starting Member
USA
3 Posts |
 Posted - 11/22/2012 : 17:27:57
|
I have a question regarding how to design/set up my database. The year, make and model and constants. Meaning I (the webmaster) is going to be supplying that information. Everything else the user is going to input. My question is, in my second column should I also include the year, make and model?
User column
ID
Year
Make
Model
Car Column
ID
UserID
Year
Make
Model
Price
Mileage
Color
Transmission
State
City |
|
|
SqlGirl87
Starting Member
26 Posts |
Posted - 11/23/2012 : 17:42:40
|
quote:
Originally posted by scm22ri
I have a question regarding how to design/set up my database. The year, make and model and constants. Meaning I (the webmaster) is going to be supplying that information. Everything else the user is going to input. My question is, in my second column should I also include the year, make and model?
User column
ID
Year
Make
Model
Car Column
ID
UserID
Year
Make
Model
Price
Mileage
Color
Transmission
State
City
I would take them out of the first table, and use the carID are the FK in the user table, rather than the user in the car one. |
 |
|
Database design?
