Product documentationbeginner10 minutes

Design the data model

Design a focused Jotsu application data model with essential records, fields, relationships, constraints, and meaningful workflow statuses.

Model the things users manage, not the screens that display them.

For each record type, identify:

  • A stable identifier
  • The fields users enter or view
  • Status and ownership fields
  • Created and updated timestamps
  • Relationships to other records

Use one-to-many relationships when one record owns several others, such as a supplier with many products. Use a join record for many-to-many relationships, such as users assigned to many projects.

Ask Codex to state its proposed records and relationships before changing code. After the change, create one record and confirm that related records load correctly.