Projects Schema

Projects is the planning and operational work layer. Issues organize under projects when a workflow needs project scope.

Tables

projects

Projects are the core organizing object for issue work.

• Primary key: id
• Required fields: tenant_id, name
• Optional field: description
• Foreign key: tenant_id -> tenants.id
• Unique key: (tenant_id, name)

issues (project linkage)

Issues include an optional project reference.

• Link field: project_id
• Foreign key: project_id -> projects.id (ON DELETE SET NULL)
• Index: issues_project_id_idx

Seeded Shared Projects

Migrations seed two shared projects in the shared tenant:

• Technology Service
• Maintenance Service

Historical issue rows were backfilled so:

• repair issues map to Maintenance Service
• non-repair issues map to Technology Service

Relationship Notes

• Projects currently provide the main grouping dimension for issue work.