Database Design for Clothes and Shoes Sizes
===

I am working on a clothes and shoes store website, but I'm fairly new to the relational databases (MySQL). How should I design the columns and the tables for the sizes of the different products?

The products can be clothes, in which case the available sizes will be *S, M, XXL, etc.*, they can be shoes, in which case the product will have both European sizes *(43, 48 2/3, 49 1/2 and so on)* and American - *(8 1/2, 9, etc.)*, and also there are products with no size. Also, each product can be available at different sizes.

Here's how the ***Products* Table** looks at the moment:

id (primary key)  
category_id (related with *categories*)  
brand_id (related with *brands*)  
name (varchar)  
color_id (related with *colors*)  
price (float)  
description (text)


