hard · ~12 min
Inventory reporting needs a dense daily stock series for every product observed in snapshots across every day in calendar.
snapshots
calendar
(day, product_id)
stock
day
product_id
Input contract: day is unique and non-null in calendar. (snapshot_day, product_id) is unique and non-null in snapshots; stock is a non-null integer, and every snapshot_day exists in calendar.
(snapshot_day, product_id)
snapshot_day