Feature pressure Two approvers, audit history, and creator-blocking must work before invoices over $10,000 can go live. A quick column can satisfy the screen and fail the audit. Modeling discipline Grain -> Identity -> Relationship -> Constraint A good schema explains what exists, how it is identified, what it can refer to, and which impossible states the database should reject. Reflex Add approver_1_email and approver_2_email to invoices. A model that can answer workflow and audit questions without guessing. Columns store values; tables store facts. Choose the fact first. Find the grain Entity choice The PM focuses on the invoice screen.…
Read the full lesson
Sign up free: one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in