design 2 A locked_yn nobody ever set to true — computing the period lock from dates instead of a flag Dec 8, 2025 If nothing gets deleted, don't call it delete — soft deletes with a status column Jun 16, 2025