vchris Posted February 27, 2009 Share Posted February 27, 2009 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 DBMakes Table:make_idmake_namemake_date_createdmake_date_modifiedmake_date_deletedmake_deletedModels Table:model_idmodel_namemodel_detailmodel_date_createdmodel_date_modifiedmodel_date_deletedmodel_deletedVehicles Table:vehi_idvehi_yearvehi_mileagevehi_colourvehi_pricevehi_descvehi_date_createdvehi_date_modifiedvehi_date_deletedvehi_deletedAds Table:ad_idad_descad_phonead_emailad_date_createdad_date_modifiedad_date_deletedad_deletedRegions Table:reg_idreg_namemake_x_model_x_vehi_x_ad Table:mxmxvxa_idmxmxvxa_make_idmxmxvxa_model_idmxmxvxa_vehi_idmxmxvxa_ad_idmxmxvxa_reg_idmxmxvxa_deletedUsers Table (only admin for now):user_iduser_nameuser_pwuser_emailuser_leveluser_date_createdUser_date_deleteduser_deleted Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.