Tables overview
The ERD defines the agreed relationships. ★ Minimum marks the tables needed for external sign-in, issue creation, and display. Field definitions cover this first milestone; physical database types remain to be defined.
| Table | Purpose | Initial population | Minimum |
|---|---|---|---|
| Workspace | Groups issues and owns roles. | Seeded | ★ |
| User | Account with required, unique, verified email. | First verified sign-in | ★ |
| Provider | External sign-in provider catalogue. | Seeded | ★ |
| UserIdentity | Links User and Provider with a composite primary key. | Verified sign-in | ★ |
| Role | Workspace-owned role. | Seeded | ★ |
| UserRole | Assigns a user to a workspace through Role. | Assignment after account creation | ★ |
| Status | Workspace-owned issue status and closure classification. | Seeded | ★ |
| Issue | Report and its current state. | Issue creation API | ★ |
| Comment | Discussion on an issue. | Deferred | |
| Interval | Workspace planning cycle. | Deferred | |
| Attachment | File attached to an issue. | Deferred |
UserIdentity has the composite primary key (user_id, provider_id). The other minimum tables use id as their primary key. New users and their identities are not seeded. The initial API flow records the outstanding workspace-role assignment decision.