Recording one

What it is, who with, what it costs a term, when it renews, and how much notice you owe them.

⛔⛔ THE DATE THAT MATTERS IS NOT THE RENEWAL DATE. It is renews_on minus the notice you owe, and this pack stores it as decide_by so it can be sorted and warned on. A deadline shown EARLIER than the truth costs you nothing — you decide with days to spare. A deadline shown LATER means you were told you had time when you did not, and you are in for another term. The two errors are not symmetric, so the arithmetic is pinned by a test and decide_by is recomputed on every write that touches either input.

⛔⛔ CALENDAR DATES HERE ARE UTC DATES, AND THEY NEVER GO THROUGH date_format. A renewal date a supplier gave you is a calendar date with no timezone; date_format renders an INSTANT in the server's local time, so a UTC-midnight date formatted west of Greenwich comes back a day earlier — verified: date_format('2026-12-31') returns 2026-12-30 at UTC−7. Every date in this pack is taken as the part before the T of an ISO timestamp, which no timezone can move. ⚠ The consequence is that “today” is the UTC day, so it rolls over during the afternoon for users well west of Greenwich. Against a notice period measured in weeks that is immaterial; against a same-day deadline it would not be, and this pack does not have those.

⚠ Cost is a plain number, not a fixed-point decimal. It is summed for a headline figure but is never a balance and never compared for equality, so the precision a decimal buys would cost every recipe the fixed-point dance for nothing. Money is not automatically a decimal — stored amounts that accumulate or are compared are.

⚠ It reminds you of nothing. Nothing is scheduled, nothing is emailed. Run list-agreements to see what is due.