Production Schema Step 6: Time and History

Audit every date and time column in your schema: is it an instant or a date, and is it stored correctly? Convert anything wrong. Then decide, per table, whether you need history, and model it where the answer is yes. If you use soft deletion anywhere, add a partial unique index so the constraints still work, and write down every query that must now exclude deleted rows. That list is the cost you accepted.