Jump to content

Database Layout Help


mdmartiny

Recommended Posts

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.

Link to comment
https://forums.phpfreaks.com/topic/271701-database-layout-help/
Share on other sites

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.

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.