mdmartiny Posted December 7, 2012 Share Posted December 7, 2012 I am in the process of setting up my database that I am going to be using on a website that I am creating. I want to make sure that I am doing it the best way possible. Here are the layouts of my tables The ads table - ad_id primary - user_id unique - cat_id unique - sub_id unique - price - date_created The ad_detail table - detail_id primary - user_id unique - color - size - description The category table - cat_id primary - c_name - c_image The sub category table - sub_id primary - cat_id unique - sub_cat_name - sub_cat_image The users table - user_id primary - f_name - l_name - user_level - email - username - password - secret_question - question_answer - phone - contact - trade_location - date_joined Does this look like it would be a good structure for a database? If not, what changes should I make. Quote Link to comment https://forums.phpfreaks.com/topic/271701-database-layout-help/ Share on other sites More sharing options...
Barand Posted December 7, 2012 Share Posted December 7, 2012 The short answer is "I have no idea". Without knowledge of the processes it is going to support and the relationships between your entities (particularly those between ads, ads details and users) there is no way of judging. Quote Link to comment https://forums.phpfreaks.com/topic/271701-database-layout-help/#findComment-1398048 Share on other sites More sharing options...
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.