79814435

Date: 2025-11-08 20:37:29
Score: 1
Natty:
Report link

Briefly: combine the "Membership" and "Product" tables into a single table. Add an enum or equivalent to distinguish the types. For special discount, or fees, add an auxiliary table. That discount/fee table would have a column with the enum, and a date range. Some rows would be global, others linked to specific membership/products. Perhaps with a many-to-many linking table. For custom items, they go in the main table with other indicators as necessary. The hardest part is coming up with the name of the Membership+Product table :-)

Reasons:
  • Long answer (-0.5):
  • No code block (0.5):
  • Single line (0.5):
  • Low reputation (0.5):
Posted by: David Pierson