The category table would not need a link to the subcategory table. There may be multiple subcategories in one main category, so you would just need a reference to the category table from the subcategory table. So in the subcategory table you would want to make a column that references which category it is a subcategory of.