Linear

Explore the interactive ERD

Table & Field Reference

project_milestone

Column	Type	Keys
`id`	Unknown	PK
`project_id`	Unknown	FK
`archived_at`	Unknown
`created_at`	Unknown
`description`	Unknown
`name`	Unknown
`sort_order`	Unknown
`target_date`	Unknown
`updated_at`	Instant

customer_request

Column	Type	Keys
`id`	Unknown	PK
`attachment_id`	Unknown	FK
`comment_id`	Unknown	FK
`creator_id`	Unknown	FK
`customer_id`	Unknown	FK
`issue_id`	Unknown	FK
`original_issue_id`	Unknown	FK
`project_attachment_id`	Unknown	FK
`project_id`	Unknown	FK
`archived_at`	Unknown
`body`	Unknown
`body_data`	Unknown
`color`	Unknown
`created_at`	Unknown
`priority`	Unknown
`updated_at`	Instant
`url`	Unknown

document

Column	Type	Keys
`id`	Unknown	PK
`creator_id`	Unknown	FK
`project_id`	Unknown	FK
`updated_by`	Unknown	FK
`archived_at`	Unknown
`color`	Unknown
`content`	Unknown
`created_at`	Unknown
`icon`	Unknown
`slug_id`	Unknown
`title`	Unknown
`updated_at`	Instant

initiative_history

Column	Type	Keys
`id`	Unknown	PK
`initiative_id`	Unknown	PKFK
`archived_at`	Unknown
`created_at`	Unknown
`entries`	Json
`updated_at`	Unknown

project_status

Column	Type	Keys
`id`	Unknown	PK
`archived_at`	Unknown
`color`	Unknown
`created_at`	Unknown
`description`	Unknown
`indefinite`	Unknown
`name`	Unknown
`position`	Unknown
`type`	Unknown
`updated_at`	Instant

project_member

Column	Type	Keys
`member_id`	Unknown	PKFK
`project_id`	Unknown	PKFK

project_team

Column	Type	Keys
`project_id`	Unknown	PKFK
`team_id`	Unknown	PKFK

project_external_link

Column	Type	Keys
`id`	Unknown	PK
`project_id`	Unknown	PKFK
`creator_id`	Unknown	FK
`initiative_id`	Unknown	FK
`archived_at`	Unknown
`created_at`	Unknown
`label`	Unknown
`sort_order`	Unknown
`updated_at`	Instant
`url`	Unknown

project

Column	Type	Keys
`id`	Unknown	PK
`converted_from_issue_id`	Unknown	FK
`creator_id`	Unknown	FK
`lead_id`	Unknown	FK
`status_id`	Unknown	FK
`archived_at`	Unknown
`auto_archived_at`	Unknown
`canceled_at`	Unknown
`color`	Unknown
`completed_at`	Unknown
`completed_scope_history`	Json
`content`	Unknown
`created_at`	Unknown
`description`	Unknown
`icon`	Unknown
`in_progress_scope_history`	Json
`name`	Unknown
`progress`	Unknown
`project_update_reminders_paused_until_at`	Unknown
`scope`	Unknown
`scope_history`	Json
`slack_issue_comment`	Unknown
`slack_issue_status`	Unknown
`slack_new_issue`	Unknown
`slug_id`	Unknown
`sort_order`	Unknown
`start_date`	Unknown
`started_at`	Unknown
`target_date`	Unknown
`trashed`	Unknown
`updated_at`	Instant
`url`	Unknown

team_membership

Column	Type	Keys
`id`	Unknown	PK
`team_id`	Unknown	FK
`user_id`	Unknown	FK
`archived_at`	Unknown
`calendar_hash`	Unknown
`created_at`	Unknown
`disable_reason`	Unknown
`invite_hash`	Unknown
`owner`	Unknown
`sort_order`	Unknown
`status_emoji`	Unknown
`status_until_at`	Unknown
`updated_at`	Instant
`user_archived_at`	Unknown

roadmap

Column	Type	Keys
`id`	Unknown	PK
`creator_id`	Unknown	FK
`organization_id`	Unknown	FK
`owner_id`	Unknown	FK
`archived_at`	Unknown
`color`	Unknown
`created_at`	Unknown
`description`	Unknown
`name`	Unknown
`slug_id`	Unknown
`sort_order`	Unknown
`updated_at`	Instant

cycle_uncompleted_issue

Column	Type	Keys
`cycle_id`	Unknown	PKFK
`issue_id`	Unknown	PKFK

cycle

Column	Type	Keys
`id`	Unknown	PK
`team_id`	Unknown	FK
`archived_at`	Unknown
`auto_archived_at`	Unknown
`completed_at`	Unknown
`completed_issue_count_history`	Json
`completed_scope_history`	Json
`created_at`	Unknown
`description`	Unknown
`ends_at`	Unknown
`in_progress_scope_history`	Json
`issue_count_history`	Json
`name`	Unknown
`number`	Unknown
`progress`	Unknown
`scope_history`	Json
`starts_at`	Unknown
`updated_at`	Instant

attachment_metadata

Column	Type	Keys
`name`	Unknown	PK
`attachment_id`	Unknown	PKFK
`value`	Unknown

attachment

Column	Type	Keys
`id`	Unknown	PK
`creator_id`	Unknown	FK
`external_user_creator_id`	Unknown	FK
`issue_id`	Unknown	FK
`archived_at`	Unknown
`created_at`	Unknown
`group_by_source`	Unknown
`source`	Unknown
`source_type`	Unknown
`subtitle`	Unknown
`title`	Unknown
`updated_at`	Instant
`url`	Unknown

issue_history

Column	Type	Keys
`id`	Unknown	PK
`issue_id`	Unknown	PKFK
`actor_id`	Unknown	FK
`attachment_id`	Unknown	FK
`from_assignee_id`	Unknown	FK
`from_cycle_id`	Unknown	FK
`from_parent_id`	Unknown	FK
`from_project_id`	Unknown	FK
`from_state_id`	Unknown	FK
`from_team_id`	Unknown	FK
`to_assignee_id`	Unknown	FK
`to_converted_project_id`	Unknown	FK
`to_cycle_id`	Unknown	FK
`to_parent_id`	Unknown	FK
`to_project_id`	Unknown	FK
`to_state_id`	Unknown	FK
`to_team_id`	Unknown	FK
`added_label_ids`	Json
`archived`	Unknown
`archived_at`	Unknown
`auto_archived`	Unknown
`auto_closed`	Unknown
`changes`	Json
`created_at`	Unknown
`from_due_date`	Unknown
`from_estimate`	Unknown
`from_priority`	Unknown
`from_title`	Unknown
`removed_label_ids`	Json
`to_due_date`	Unknown
`to_estimate`	Unknown
`to_priority`	Unknown
`to_title`	Unknown
`trashed`	Unknown
`updated_at`	Unknown
`updated_description`	Unknown

workflow_state

Column	Type	Keys
`id`	Unknown	PK
`team_id`	Unknown	FK
`archived_at`	Unknown
`color`	Unknown
`created_at`	Unknown
`description`	Unknown
`name`	Unknown
`position`	Unknown
`type`	Unknown
`updated_at`	Instant

initiative

Column	Type	Keys
`id`	Unknown	PK
`creator_id`	Unknown	FK
`organization_id`	Unknown	FK
`owner_id`	Unknown	FK
`project_id`	Unknown	FK
`team_id`	Unknown	FK
`archived_at`	Unknown
`color`	Unknown
`completed_at`	Unknown
`content`	Unknown
`created_at`	Unknown
`description`	Unknown
`frequency_resolution`	Unknown
`health`	Unknown
`health_updated_at`	Unknown
`icon`	Unknown
`integration_setting_archived_at`	Unknown
`integration_setting_context_view_type`	Unknown
`integration_setting_created_at`	Unknown
`integration_setting_id`	Unknown
`integration_setting_project_id`	Unknown
`integration_setting_slack_initiative_update_created`	Unknown
`integration_setting_slack_issue_added_to_triage`	Unknown
`integration_setting_slack_issue_added_to_view`	Unknown
`integration_setting_slack_issue_created`	Unknown
`integration_setting_slack_issue_new_comment`	Unknown
`integration_setting_slack_issue_sla_breached`	Unknown
`integration_setting_slack_issue_sla_high_risk`	Unknown
`integration_setting_slack_issue_status_changed_all`	Unknown
`integration_setting_slack_issue_status_changed_done`	Unknown
`integration_setting_slack_project_update_created`	Unknown
`integration_setting_slack_project_update_created_to_team`	Unknown
`integration_setting_slack_project_update_created_to_workspace`	Unknown
`integration_setting_team_id`	Unknown
`integration_setting_updated_at`	Unknown
`last_update_id`	Unknown
`name`	Unknown
`slug_id`	Unknown
`sort_order`	Unknown
`started_at`	Unknown
`status`	Unknown
`target_date`	Unknown
`target_date_resolution`	Unknown
`trashed`	Unknown
`update_reminder_frequency`	Unknown
`update_reminder_frequency_in_weeks`	Unknown
`update_reminders_day`	Unknown
`update_reminders_hour`	Unknown
`updated_at`	Instant
`url`	Unknown

issue_subscriber

Column	Type	Keys
`issue_id`	Unknown	PKFK
`subscriber_id`	Unknown	PKFK

issue_label

Column	Type	Keys
`index`	Unknown	PK
`issue_id`	Unknown	PKFK
`label_id`	Unknown	FK

issue

Column	Type	Keys
`id`	Unknown	PK
`assignee_id`	Unknown	FK
`creator_id`	Unknown	FK
`cycle_id`	Unknown	FK
`external_user_creator_id`	Unknown	FK
`parent_id`	Unknown	FK
`project_id`	Unknown	FK
`project_milestone_id`	Unknown	FK
`state_id`	Unknown	FK
`team_id`	Unknown	FK
`archived_at`	Unknown
`auto_archived_at`	Unknown
`auto_closed_at`	Unknown
`branch_name`	Unknown
`canceled_at`	Unknown
`completed_at`	Unknown
`created_at`	Unknown
`customer_ticket_count`	Unknown
`description`	Unknown
`due_date`	Unknown
`estimate`	Unknown
`identifier`	Unknown
`number`	Unknown
`priority`	Unknown
`priority_label`	Unknown
`sla_breaches_at`	Unknown
`sla_started_at`	Unknown
`snoozed_until_at`	Unknown
`sort_order`	Unknown
`started_at`	Unknown
`started_triage_at`	Unknown
`title`	Unknown
`trashed`	Unknown
`triaged_at`	Unknown
`updated_at`	Instant
`url`	Unknown

label_children

Column	Type	Keys
`label_children_id`	Unknown	PKFK
`label_id`	Unknown	PKFK

label

Column	Type	Keys
`id`	Unknown	PK
`creator_id`	Unknown	FK
`parent_id`	Unknown	FK
`team_id`	Unknown	FK
`archived_at`	Unknown
`color`	Unknown
`created_at`	Unknown
`description`	Unknown
`is_group`	Unknown
`name`	Unknown
`updated_at`	Instant

team_member

Column	Type	Keys
`member_id`	Unknown	PKFK
`team_id`	Unknown	PKFK

team

Column	Type	Keys
`id`	Unknown	PK
`active_cycle_id`	Unknown	FK
`auto_close_state_id`	Unknown	FK
`organization_id`	Unknown	FK
`parent_id`	Unknown	FK
`start_workflow_state_id`	Unknown	FK
`archived_at`	Unknown
`auto_archive_period`	Unknown
`auto_close_period`	Unknown
`color`	Unknown
`created_at`	Unknown
`cycle_calendar_url`	Unknown
`cycle_cooldown_time`	Unknown
`cycle_duration`	Unknown
`cycle_enabled`	Unknown
`cycle_issue_auto_assign_completed`	Unknown
`cycle_issue_auto_assign_started`	Unknown
`cycle_lock_to_active`	Unknown
`cycle_start_day`	Unknown
`default_issue_estimate`	Unknown
`description`	Unknown
`group_issue_history`	Unknown
`icon`	Unknown
`invite_hash`	Unknown
`issue_count`	Unknown
`issue_estimation_allow_zero`	Unknown
`issue_estimation_extended`	Unknown
`issue_estimation_type`	Unknown
`issue_ordering_no_priority_first`	Unknown
`issue_sort_order_default_to_bottom`	Unknown
`key`	Unknown
`name`	Unknown
`private`	Unknown
`require_priority_to_leave_triage`	Unknown
`slack_issue_comment`	Unknown
`slack_issue_status`	Unknown
`slack_new_issue`	Unknown
`timezone`	Unknown
`triage_enabled`	Unknown
`upcoming_cycle_count`	Unknown
`updated_at`	Instant

project_label_children

Column	Type	Keys
`child_id`	Unknown	PKFK
`project_label_id`	Unknown	PKFK

project_label_project

Column	Type	Keys
`project_id`	Unknown	PKFK
`project_label_id`	Unknown	PKFK

project_label

Column	Type	Keys
`id`	Unknown	PK
`creator_id`	Unknown	FK
`organization_id`	Unknown	FK
`parent_id`	Unknown	FK
`retired_by_id`	Unknown	FK
`archived_at`	Unknown
`color`	Unknown
`created_at`	Unknown
`description`	Unknown
`is_group`	Unknown
`last_applied_at`	Unknown
`name`	Unknown
`retired_at`	Unknown
`updated_at`	Instant

project_update_comment

Column	Type	Keys
`comment_id`	Unknown	PKFK
`project_update_id`	Unknown	PKFK

project_update_reaction

Column	Type	Keys
`id`	Unknown	PK
`project_update_id`	Unknown	PKFK
`comment_id`	Unknown	FK
`external_user_id`	Unknown	FK
`issue_id`	Unknown	FK
`archived_at`	Unknown
`created_at`	Unknown
`emoji`	Unknown
`initiative_update_id`	Unknown
`post_id`	Unknown
`updated_at`	Unknown
`user_id`	Unknown

project_update

Column	Type	Keys
`id`	Unknown	PK
`project_id`	Unknown	FK
`user_id`	Unknown	FK
`archived_at`	Unknown
`body`	Unknown
`body_data`	Unknown
`created_at`	Unknown
`diff`	Json
`diff_markdown`	Unknown
`edited_at`	Unknown
`health`	Unknown
`info_snapshot`	Json
`is_diff_hidden`	Unknown
`is_stale`	Unknown
`reaction_data`	Json
`slug_id`	Unknown
`updated_at`	Instant
`url`	Unknown

initiative_to_project

Column	Type	Keys
`id`	Unknown	PK
`initiative_id`	Unknown	FK
`project_id`	Unknown	FK
`archived_at`	Unknown
`created_at`	Unknown
`sort_order`	Unknown
`updated_at`	Instant

users

Column	Type	Keys
`id`	Unknown	PK
`organization_id`	Unknown	FK
`active`	Unknown
`admin`	Unknown
`archived_at`	Unknown
`avatar_url`	Unknown
`calendar_hash`	Unknown
`created_at`	Unknown
`created_issue_count`	Unknown
`description`	Unknown
`disable_reason`	Unknown
`display_name`	Unknown
`email`	Unknown
`guest`	Unknown
`invite_hash`	Unknown
`last_seen`	Unknown
`name`	Unknown
`status_emoji`	Unknown
`status_label`	Unknown
`status_until_at`	Unknown
`timezone`	Unknown
`updated_at`	Instant
`url`	Unknown

roadmap_to_project

Column	Type	Keys
`id`	Unknown	PK
`project_id`	Unknown	FK
`roadmap_id`	Unknown	FK
`archived_at`	Unknown
`created_at`	Unknown
`sort_order`	Unknown
`updated_at`	Unknown

organization

Column	Type	Keys
`id`	Unknown	PK
`subscription_creator_id`	Unknown	FK
`allow_members_to_invite`	Unknown
`archived_at`	Unknown
`created_at`	Unknown
`deletion_requested_at`	Unknown
`git_branch_format`	Unknown
`git_linkback_messages_enabled`	Unknown
`git_public_linkback_messages_enabled`	Unknown
`logo_url`	Unknown
`name`	Unknown
`period_upload_volume`	Unknown
`previous_url_key`	Json
`project_update_reminders_day`	Unknown
`project_update_reminders_hour`	Unknown
`project_updates_reminder_frequency`	Unknown
`release_channel`	Unknown
`roadmap_enabled`	Unknown
`saml_enabled`	Unknown
`scim_enabled`	Unknown
`subscription_archived_at`	Unknown
`subscription_canceled_at`	Unknown
`subscription_created_at`	Unknown
`subscription_id`	Unknown
`subscription_next_billing_at`	Unknown
`subscription_pending_change_type`	Unknown
`subscription_seats`	Unknown
`subscription_seats_maximum`	Unknown
`subscription_seats_minimum`	Unknown
`subscription_type`	Unknown
`subscription_updated_at`	Unknown
`trial_ends_at`	Unknown
`updated_at`	Unknown
`url_key`	Unknown

integration

Column	Type	Keys
`id`	Unknown	PK
`creator_id`	Unknown	FK
`organization_id`	Unknown	FK
`team_id`	Unknown	FK
`archived_at`	Unknown
`created_at`	Unknown
`service`	Unknown
`updated_at`	Instant

external_user

Column	Type	Keys
`id`	Unknown	PK
`organization_id`	Unknown	FK
`archived_at`	Unknown
`avatar_url`	Unknown
`created_at`	Unknown
`display_name`	Unknown
`email`	Unknown
`last_seen`	Unknown
`name`	Unknown
`updated_at`	Instant

comment

Column	Type	Keys
`id`	Unknown	PK
`external_user_id`	Unknown	FK
`issue_id`	Unknown	FK
`parent_id`	Unknown	FK
`user_id`	Unknown	FK
`archived_at`	Unknown
`body`	Unknown
`body_data`	Unknown
`created_at`	Unknown
`edited_at`	Unknown
`reaction_data`	Json
`updated_at`	Instant
`url`	Unknown

customer

Column	Type	Keys
`id`	Unknown	PK
`integration_id`	Unknown	FK
`owner_id`	Unknown	FK
`status_id`	Unknown	FK
`approximate_need_count`	Unknown
`archived_at`	Unknown
`created_at`	Unknown
`domains`	Json
`external_ids`	Json
`logo_url`	Unknown
`main_source_id`	Unknown
`name`	Unknown
`revenue`	Unknown
`size`	Unknown
`slack_channel_id`	Unknown
`slug_id`	Unknown
`tier_archived_at`	Unknown
`tier_color`	Unknown
`tier_created_at`	Unknown
`tier_description`	Unknown
`tier_display_name`	Unknown
`tier_id`	Unknown
`tier_name`	Unknown
`tier_position`	Unknown
`tier_updated_at`	Unknown
`updated_at`	Instant
`url`	Unknown