Skip to content

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.