Autotrader similar website
Posted: Fri Feb 27, 2009 6:45 pm
I want to create a website kind of like the auotrader.com website.
Here is the database design I came up with. Let me know what you think.
Trader DB
Makes Table:
make_id
make_name
make_type
make_date_created
make_date_modified
make_date_deleted
make_deleted
Models Table:
model_id
model_name
model_detail
model_date_created
model_date_modified
model_date_deleted
model_deleted
Vehicles Table:
vehi_id
vehi_year
vehi_mileage
vehi_colour
vehi_price
vehi_desc
vehi_date_created
vehi_date_modified
vehi_date_deleted
vehi_deleted
Ads Table:
ad_id
ad_desc
ad_phone
ad_email
ad_date_created
ad_date_modified
ad_date_deleted
ad_deleted
Regions Table:
reg_id
reg_name
make_x_model_x_vehi_x_ad Table:
mxmxvxa_id
mxmxvxa_make_id
mxmxvxa_model_id
mxmxvxa_vehi_id
mxmxvxa_ad_id
mxmxvxa_reg_id
mxmxvxa_deleted
Users Table (only admin for now):
user_id
user_name
user_pw
user_email
user_level
user_date_created
User_date_deleted
user_deleted
Here is the database design I came up with. Let me know what you think.
Trader DB
Makes Table:
make_id
make_name
make_type
make_date_created
make_date_modified
make_date_deleted
make_deleted
Models Table:
model_id
model_name
model_detail
model_date_created
model_date_modified
model_date_deleted
model_deleted
Vehicles Table:
vehi_id
vehi_year
vehi_mileage
vehi_colour
vehi_price
vehi_desc
vehi_date_created
vehi_date_modified
vehi_date_deleted
vehi_deleted
Ads Table:
ad_id
ad_desc
ad_phone
ad_email
ad_date_created
ad_date_modified
ad_date_deleted
ad_deleted
Regions Table:
reg_id
reg_name
make_x_model_x_vehi_x_ad Table:
mxmxvxa_id
mxmxvxa_make_id
mxmxvxa_model_id
mxmxvxa_vehi_id
mxmxvxa_ad_id
mxmxvxa_reg_id
mxmxvxa_deleted
Users Table (only admin for now):
user_id
user_name
user_pw
user_email
user_level
user_date_created
User_date_deleted
user_deleted