Jira

Explore the interactive ERD

Table & Field Reference

request

Column	Type	Keys
`issue_id`	Int	PKFK
`request_type_id`	Int	FK
`link`	String
`service_desk_id`	Int

schedule_rotation

Column	Type	Keys
`id`	String	PK
`schedule_id`	String	FK
`end_date`	Instant
`length`	Int
`name`	String
`start_date`	Instant
`time_restriction_restriction_end_day`	String
`time_restriction_restriction_end_hour`	Int
`time_restriction_restriction_end_min`	Int
`time_restriction_restriction_start_day`	String
`time_restriction_restriction_start_hour`	Int
`time_restriction_restriction_start_min`	Int
`time_restriction_type`	String
`type`	String

status

Column	Type	Keys
`id`	Int	PK
`status_category_id`	Int	FK
`description`	String
`name`	String

issue_watcher

Column	Type	Keys
`issue_id`	Int	PKFK
`user_id`	String	PKFK

platform_team

Column	Type	Keys
`team_id`	String	PK
`team_name`	String

project_role_actor

Column	Type	Keys
`id`	Int	PK
`group_id`	String	FK
`project_id`	Int	FK
`project_role_id`	Int	FK
`user_id`	String	FK
`group_name`	String

issue_form

Column	Type	Keys
`id`	String	PK
`issue_id`	Int	PKFK
`form_template_id`	String
`internal`	Boolean
`lock`	Boolean
`name`	String
`state_answers`	String
`state_status`	String
`state_visibility`	String
`submitted`	Boolean
`updated`	Instant
`design_`

worklog

Column	Type	Keys
`id`	Int	PK
`issue_id`	Int	PKFK
`author_id`	String	FK
`update_author_id`	String	FK
`comment`	String
`started`	Instant
`time_spent_seconds`	Long
`updated`	Instant

epic

Column	Type	Keys
`id`	Int	PK
`done`	Boolean
`key`	String
`name`	String
`summary`	String

issue_field_history

Column	Type	Keys
`time`	Instant	PK
`field_id`	String	PKFK
`issue_id`	Int	PKFK
`author_id`	String	FK
`is_active`	Boolean
`value`	String

attachment_metadata

Column	Type	Keys
`attachment_id`	Long	PK
`index`	Int	PK
`author_id`	String
`content_url`	String
`created`	String
`file_size`	Long
`filename`	String
`label`	String
`media_type`	String
`mime_type`	String
`path`	String
`size`	String
`thumbnail_url`	String

schedule_participant

Column	Type	Keys
`id`	String	PK
`schedule_id`	String	FK
`type`	String

component

Column	Type	Keys
`id`	Int	PK
`project_id`	Int	FK
`description`	String
`name`	String

project_role

Column	Type	Keys
`id`	Int	PK
`description`	String
`name`	String

request_type

Column	Type	Keys
`id`	Int	PK
`service_desk_id`	Int	PK
`issue_type_id`	Int	FK
`project_id`	Int	FK
`description`	String
`help_text`	String
`name`	String

schedule

Column	Type	Keys
`id`	String	PK
`description`	String
`enabled`	Boolean
`name`	String
`team_id`	String
`timezone`	String

resolution

Column	Type	Keys
`id`	Int	PK
`description`	String
`name`	String

field

Column	Type	Keys
`id`	String	PK
`description`	String
`dimension_table`	String
`is_array`	Boolean
`is_custom`	Boolean
`name`	String

issue_link

Column	Type	Keys
`relationship`	String	PK
`issue_id`	Int	PKFK
`related_issue_id`	Int	PKFK

approver

Column	Type	Keys
`approval_id`	Long	PK
`approver_id`	String	PK
`decision`	String

sprint

Column	Type	Keys
`id`	Int	PK
`board_id`	Int	FK
`activated_date`	Instant
`complete_date`	Instant
`end_date`	Instant
`goal`	String
`name`	String
`start_date`	Instant
`state`	String

project_board

Column	Type	Keys
`board_id`	Int	PKFK
`project_id`	Int	PKFK

asset_object_issue

Column	Type	Keys
`workspace_id`	String	PK
`issue_id`	Int	PKFK
`object_id`	Int	PKFK

issue_property

Column	Type	Keys
`key`	String	PK
`issue_id`	Int	PKFK
`self`	String
`value`	String

status_category

Column	Type	Keys
`id`	Int	PK
`name`	String

user

Column	Type	Keys
`id`	String	PK
`email`	String
`is_active`	Boolean
`locale`	String
`name`	String
`time_zone`	String
`username`	String

approval

Column	Type	Keys
`id`	Int	PK
`can_answer_approval`	Boolean
`completed_date`	Instant
`created_date`	Instant
`final_decision`	String
`name`	String

team

Column	Type	Keys
`id`	String	PK
`is_shared`	Boolean
`is_visible`	Boolean
`name`	String
`title`	String

security_scheme

Column	Type	Keys
`id`	Int	PK
`default_level_id`	Int	FK
`description`	String
`name`	String

user_group

Column	Type	Keys
`group_id`	String	PK
`user_id`	String	PKFK
`group_name`	String

issue_user_vote

Column	Type	Keys
`issue_id`	Int	PKFK
`user_id`	String	PKFK

project

Column	Type	Keys
`id`	Int	PK
`archived_by_id`	String	FK
`lead_id`	String	FK
`permission_scheme_id`	Int	FK
`project_category_id`	Int	FK
`archived`	Boolean
`archived_date`	Instant
`description`	String
`key`	String
`name`	String
`project_type_key`	String
`simplified`	Boolean

issue_type

Column	Type	Keys
`id`	Int	PK
`description`	String
`hierarchy_level`	Int
`name`	String
`subtask`	Boolean

issue

Column	Type	Keys
`id`	Int	PK
`parent_id`	Int	FK
`priority`	Int	FK
`resolution`	Int	FK
`security_level`	Int	FK
`status`	Int	FK
`key`	Int
`system_fields_`

issue_remote_link

Column	Type	Keys
`id`	Int	PK
`issue_id`	Int	PKFK
`application_name`	String
`application_type`	String
`global_id`	String
`relationship`	String
`object_`

alert_action

Column	Type	Keys
`action`	String	PK
`alert_id`	String	PKFK

alert

Column	Type	Keys
`id`	String	PK
`acknowledged`	Boolean
`alias`	String
`count`	Int
`created_at`	Instant
`description`	String
`entity`	String
`integration_name`	String
`integration_type`	String
`last_occurred_at`	Instant
`message`	String
`owner`	String
`priority`	String
`seen`	Boolean
`snoozed`	Boolean
`snoozed_until`	Instant
`source`	String
`status`	String
`tiny_id`	String
`updated_at`	Instant

field_option

Column	Type	Keys
`id`	Int	PK
`parent_id`	Int	FK
`name`	String

alert_tag

Column	Type	Keys
`tag_name`	String	PK
`alert_id`	String	PKFK

escalation

Column	Type	Keys
`id`	String	PK
`team_id`	String	FK
`description`	String
`enabled`	Boolean
`name`	String
`repeat_`

asset_object_type_attribute

Column	Type	Keys
`id`	Int	PK
`workspace_id`	String	PK
`object_type_id`	Int	FK
`reference_object_type_id`	Int	FK
`reference_type_id`	String	FK
`additional_value`	String
`default_type_id`	Int
`default_type_name`	String
`description`	String
`editable`	Boolean
`hidden`	Boolean
`include_child_object_types`	Boolean
`indexed`	Boolean
`is_system`	Boolean
`label`	Boolean
`max_cardinality`	Int
`min_cardinality`	Int
`name`	String
`object_attribute_exists`	Boolean
`options`	String
`position`	Int
`ql_query`	String
`regex_validation`	String
`removable`	Boolean
`sortable`	Boolean
`suffix`	String
`summable`	Boolean
`type`	Int
`type_value`	String
`type_value_multi`	String
`unique_attribute`	Boolean

version

Column	Type	Keys
`id`	Int	PK
`project_id`	Int	FK
`archived`	Boolean
`description`	String
`driver`	String
`name`	String
`overdue`	Boolean
`release_date`	LocalDate
`released`	Boolean
`start_date`	LocalDate

board

Column	Type	Keys
`id`	Int	PK
`name`	String
`type`	String

sla

Column	Type	Keys
`_fivetran_id`	String	PK
`issue_id`	Long	PK
`sla_id`	Long	PK
`breached`	Boolean
`elapsed_time`	Long
`goal_duration`	Long
`is_ongoing_cycle`	Boolean
`paused`	Boolean
`remaining_time`	Long
`start_time`	Instant
`stop_time`	Instant
`within_calendar_hours`	Boolean

incident_responder

Column	Type	Keys
`responder_ari`	String	PK
`issue_id`	Int	PKFK

service

Column	Type	Keys
`id`	String	PK
`name`	String

field_project

Column	Type	Keys
`field_id`	String	PKFK
`project_id`	String	PKFK

worklog_property

Column	Type	Keys
`key`	String	PK
`worklog_id`	Int	PKFK
`self`	String
`value`	String

issue_board

Column	Type	Keys
`board_id`	Int	PKFK
`issue_id`	Int	PKFK

asset_object

Column	Type	Keys
`id`	Int	PK
`workspace_id`	String	PK
`object_type_id`	Int	FK
`created`	Instant
`key`	String
`label`	String
`link`	String
`name`	String
`timestamps`	Long
`updated`	Instant

incident

Column	Type	Keys
`issue_id`	Int	PKFK
`priority_id`	String	FK
`status_id`	String	FK
`reporter_account_id`	String
`reporter_account_type`	String
`reporter_display_name`	String
`summary`	String

request_comment

Column	Type	Keys
`id`	Int	PK
`request_id`	Int	PKFK
`author_id`	String	FK
`body`	String
`created`	Instant
`public`	Boolean

sprint_board

Column	Type	Keys
`board_id`	Int	PKFK
`sprint_id`	Int	PKFK

priority

Column	Type	Keys
`id`	Int	PK
`description`	String
`name`	String

asset_object_schema

Column	Type	Keys
`id`	Int	PK
`workspace_id`	String	PK
`can_manage`	Boolean
`created`	Instant
`description`	String
`key`	String
`name`	String
`status`	String
`updated`	Instant

asset_schema_status

Column	Type	Keys
`id`	Int	PK
`workspace_id`	String	PK
`schema_id`	Int	FK
`category`	Int
`description`	String
`name`	String

comment

Column	Type	Keys
`id`	Int	PK
`author_id`	String	FK
`issue_id`	Int	FK
`update_author_id`	String	FK
`body`	String
`created`	Instant
`is_public`	Boolean
`updated`	Instant
`visibility_identifier`	String
`visibility_type`	String
`visibility_value`	String

organization

Column	Type	Keys
`id`	Int	PK
`name`	String

security_scheme_level

Column	Type	Keys
`level_id`	Int	PKFK
`scheme_id`	Int	PKFK

issue_multiselect_history

Column	Type	Keys
`_fivetran_id`	String	PK
`time`	Instant	PK
`field_id`	String	PKFK
`issue_id`	Int	PKFK
`author_id`	String	FK
`is_active`	Boolean
`value`	String

permission_scheme

Column	Type	Keys
`id`	Int	PK
`description`	String
`name`	String

project_category

Column	Type	Keys
`id`	Int	PK
`description`	String
`name`	String

issue_field_rendered

Column	Type	Keys
`field_id`	String	PKFK
`issue_id`	Int	PKFK
`value`	String

asset_object_type_attribute_object

Column	Type	Keys
`value_index`	Int	PK
`workspace_id`	String	PK
`object_id`	Int	PKFK
`object_type_attribute_id`	Int	PKFK
`display_value`	String
`referenced_type`	Boolean
`search_value`	String
`value`	String

asset_object_type

Column	Type	Keys
`id`	Int	PK
`workspace_id`	String	PK
`schema_id`	Int	FK
`abstract_object_type`	Boolean
`created`	Instant
`description`	String
`inherited`	Boolean
`name`	String
`parent_id`	Int
`parent_object_type_inherited`	Boolean
`position`	Int
`type`	Int
`updated`	Instant

permission_holder

Column	Type	Keys
`_fivetran_id`	String	PK
`group_name`	String	FK
`permission_id`	String	FK
`permission_scheme_id`	Int	FK
`project_role_id`	Int	FK
`user_id`	String	FK
`type`	String

escalation_rule

Column	Type	Keys
`index`	Int	PK
`escalation_id`	String	PKFK
`condition`	String
`delay`	Int
`notify_type`	String
`recipient_id`	String
`recipient_type`	String

security_level

Column	Type	Keys
`id`	Int	PK
`description`	String
`name`	String

alert_responder

Column	Type	Keys
`id`	String	PK
`alert_id`	String	PKFK
`type`	String

permission

Column	Type	Keys
`id`	String	PK
`description`	String
`name`	String
`type`	String

asset_reference_type

Column	Type	Keys
`id`	String	PK
`workspace_id`	String	PK
`schema_id`	Int	FK
`color`	String
`description`	String
`name`	String
`removable`	Boolean
`url_16`	String