You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
{{ message }}
Repository navigation
[Issue]: Price versioning: schema with effective dates #24
Description
Each price must have an effective date, so that past donations keep the price that applied at the time. Prices are never overwritten: a new price is added as a new row. For DB schemas we use https://dbdiagram.io/
Scope
prices table with unit price and effective date
Link between prices and food items
Constraints to prevent two prices with the same effective date for one item
Migration
Acceptance Criteria
Several prices can exist for the same food item
Each price has an effective date
The migration applies cleanly on an empty database
A constraint is preventing two prices
Checklist
I have checked for duplicate issues.
I have assigned the issue to the correct project board.
Activity
lauriechammah commentedon Oct 26, 2026
Review comments:
- [ ]) so progress can be tracked.