logo
ExamplesEditorPricingDocs
37.1kSign in

Project management & issue tracker database schema

A Jira-shaped tracker: projects with human-readable issue keys, subtasks through a self-reference, fractional board positions for drag-and-drop, labels, milestones, comments, attachments and a worklog.

Project Management ER diagram

Project management & issue tracker database schema n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 n1 users idBIGINT emailVARCHAR full_nameVARCHAR avatar_urlVARCHAR timezoneVARCHAR is_activeBOOLEAN created_atTIMESTAMP projects idBIGINT keyVARCHAR nameVARCHAR descriptionTEXT lead_idBIGINT statusVARCHAR issue_counterINTEGER created_atTIMESTAMP project_members project_idBIGINT user_idBIGINT roleVARCHAR added_atTIMESTAMP milestones idBIGINT project_idBIGINT nameVARCHAR descriptionTEXT starts_onDATE due_onDATE completed_atTIMESTAMP issues idBIGINT project_idBIGINT numberINTEGER parent_issue_idBIGINT milestone_idBIGINT titleVARCHAR descriptionTEXT issue_typeVARCHAR statusVARCHAR priorityVARCHAR reporter_idBIGINT assignee_idBIGINT estimate_pointsINTEGER board_positionNUMERIC due_onDATE created_atTIMESTAMP updated_atTIMESTAMP closed_atTIMESTAMP labels idBIGINT project_idBIGINT nameVARCHAR colorVARCHAR issue_labels issue_idBIGINT label_idBIGINT added_atTIMESTAMP issue_comments idBIGINT issue_idBIGINT author_idBIGINT bodyTEXT created_atTIMESTAMP edited_atTIMESTAMP deleted_atTIMESTAMP attachments idBIGINT issue_idBIGINT uploaded_by_idBIGINT storage_keyVARCHAR filenameVARCHAR mime_typeVARCHAR byte_sizeBIGINT created_atTIMESTAMP time_entries idBIGINT issue_idBIGINT user_idBIGINT minutesINTEGER spent_onDATE noteVARCHAR created_atTIMESTAMP

Related database schemas

PostgreSQL
SaaS

Multi-tenant SaaS database schema

Shared-database multi-tenancy done properly: organizations as tenants, global users joined through memberships, invitations, scoped API keys, plans, subscriptions, metered usage and an append-only audit log.

PostgreSQL
Social

Social network database schema

Followers, feeds and direct messages modelled for read volume: asymmetric follows, one posts table for replies and reposts, narrow like rows, per-participant read pointers and notifications.

MySQL
Education

School & learning management system database schema

Courses versus sections, terms, enrolments that carry the final grade, prerequisites as a self-join, assignments with weights, per-attempt submissions and idempotent attendance registers.

PostgreSQL
Internal tools

Applicant tracking & recruiting database schema

An ATS modelled end to end: jobs with openings and hiring teams, candidates separate from applications, per-job pipeline stages, interviews with panels, structured scorecards, offers with approval chains and a talent pool of near misses.