A filled data model worksheet: fields, ownership, constraints, a migration and backup plan, and the cases to test.
About
An agent asked to add a database will make the data decisions for you if you have not made them. This data model worksheet is where you record those decisions, inputs and acceptance checks first, so the work is easier to repeat and share.
For each entity you fill in the primary key, owner key, required fields, unique constraints, relations and delete policy, indexes for the queries you actually run, a migration plan and a backup or rollback plan. It is built around modeling the task records and reviewing an additive migration.
It lists the cases to check: valid creation, invalid input, duplicate value, missing record, wrong owner and concurrent update. Evidence means the migration applied to a disposable copy and a saved record read after restart. A SQLite quick check confirms file integrity, not authorization or schema correctness.
You need only a text editor, and you keep the completed plan for your next project. Provider accounts, model weights, GPU compute and hosting are not included.
- Next.js
Requirements
- Use with
- A text editor