Autotrader similar website

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
vchris
Forum Contributor
Posts: 204
Joined: Tue Aug 30, 2005 7:53 pm
Location: Canada, Quebec

Autotrader similar website

Post by vchris »

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
User avatar
jaoudestudios
DevNet Resident
Posts: 1483
Joined: Wed Jun 18, 2008 8:32 am
Location: Surrey

Re: Autotrader similar website

Post by jaoudestudios »

You might want a roles table for ACL? Store the postcode of the vehicle too and have a Postcode table with long/lat so your users can do a distance search, i.e. CV4 7AL within 30miles etc.

I would not prepend your IDs (primary keys) with the table name, there is no need. It actually makes it more confusing. Just use ID. You might think, but how do i know which one is which, well think of objects.
i.e.
make.id
user.id
...etc...

I have been planning a similar site too, may we can link to each other at the beginning to get a better rank in google? Just a thought.
User avatar
papa
Forum Regular
Posts: 958
Joined: Wed Aug 27, 2008 3:36 am
Location: Sweden/Sthlm

Re: Autotrader similar website

Post by papa »

make_deleted is not necessary. If the delete_date field is filled it means that record is deleted. Unless you want to store some other information regarding the deletion.
Post Reply