vchris 3 Posted February 27, 2009 Report 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 Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.