Perhaps a second table something like this: Price_ID (PK) PriceType (premier, int'l, etc.) Price Promotion_Item_ID, or Product_ID (FK)