schema design

[redjim]

Why is there a separate table for products_to_categories instead of the catagories field just being added to products??

 

I ask this question because I want to make a POS brick and mortar front and as I looked at the schema, it seemed odd that there is a different table for that one bit of information.

 

Thanks, James

[Guest]

perhaps by looking at the database structure would shed some lite on it for you. download the database info from the contributions, and you can see how they all tie in together.

[redjim]

perhaps by looking at the database structure would shed some lite on it for you.  download the database info from the contributions, and you can see how they all tie in together.

<{POST_SNAPBACK}>

Thanks for your reply. I understand how the two tables relate to each other. I have looked at the structure, and I guess this just shows how ignorant I am, but I don't see why the need for the extra table.

 

Thanks, James

[Mark Evans]

Thanks for your reply.  I understand how the two tables relate to each other.  I have looked at the structure, and I guess this just shows how ignorant I am, but I don't see why the need for the extra table.

<{POST_SNAPBACK}>

 

1 product relates to n categories where n is the number of categories the product is in :)