I’m building an online shopping system. Very easy design. Products table with ID, Name and Price (other fields such as Image, CategoryID etc)
I’ve also got CategoryTree and an Inventory tables.
Part of my requirements is to load specials and sales.
– Flat $X off everything or selected goods– Variable % off everything or selected goods– Promo Code with % or $ off everything or selected goods
Ultimately when it’s the best design for this.
My thoughts would be a ‘Campaign’ table and maybe a ‘CampaignLink’ table.
In my campaign table I have a label/name and a bunch of int fields. isFixedDollar and isFixedPercent with dollarValue and percentValue, start and end dates. isAllProducts and if zero link productID and campaignID in campaignLink table.
Thoughts and feedback welcome.