Agile_Board_Epic_Issue

The table below describes the Agile_Board_Epic_Issue table in the Agile database schema.

This table contains the following foldable columns:

  • Issues_key
  • Issues_fields_assignee_displayName
  • Issues_fields_assignee_key
  • Issues_fields_assignee_name
  • Issues_fields_created
  • Issues_fields_creator_emailAddress
  • Issues_fields_creator_key
  • Issues_fields_creator_name
  • Issues_fields_description
  • Issues_fields_duedate
  • Issues_fields_environment
  • Issues_fields_issuetype_name
  • Issues_fields_lastViewed
  • Issues_fields_parent_id
  • Issues_fields_parent_key
  • Issues_fields_priority_id
  • Issues_fields_priority_name
  • Issues_fields_project_id
  • Issues_fields_project_key
  • Issues_fields_project_name
  • Issues_fields_reporter_emailAddress
  • Issues_fields_reporter_key
  • Issues_fields_reporter_name
  • Issues_fields_sprint_id
  • Issues_fields_sprint_name
  • Issues_fields_status_id
  • Issues_fields_status_name
  • Issues_fields_status_statusCategory_key
  • Issues_fields_status_statusCategory_name
  • Issues_fields_summary
  • Issues_fields_timeoriginalestimate
  • Issues_fields_timetracking_originalEstimate
  • Issues_fields_timetracking_remainingEstimate
  • Issues_fields_timetracking_timeSpent
  • Issues_fields_updated
  • Issues_fields_votes_votes
  • Issues_id

This table does not contain Return Primary Key columns.

Column Name SQL Type Updatable Nullable

Board_Id

Primary Key
 SQL_VARCHAR(1024) True True

Epic_Id

Primary Key
 SQL_VARCHAR(1024) True True

Issues_key

Primary Key
 SQL_VARCHAR(1024) False True

Issues_expand

 SQL_VARCHAR(1024) False True

Issues_fields_aggregateprogress_percent

 SQL_BIGINT(unsigned) False True

Issues_fields_aggregateprogress_progress

 SQL_BIGINT(unsigned) False True

Issues_fields_aggregateprogress_total

 SQL_BIGINT(unsigned) False True

Issues_fields_aggregatetimeestimate

 SQL_VARCHAR(1024) False True

Issues_fields_aggregatetimeoriginalestimate

 SQL_VARCHAR(1024) False True

Issues_fields_aggregatetimespent

 SQL_VARCHAR(1024) False True

Issues_fields_assignee_active

 SQL_BIT False True

Issues_fields_assignee_avatarUrls_16x16

 SQL_VARCHAR(1024) False True

Issues_fields_assignee_avatarUrls_24x24

 SQL_VARCHAR(1024) False True

Issues_fields_assignee_avatarUrls_32x32

 SQL_VARCHAR(1024) False True

Issues_fields_assignee_avatarUrls_48x48

 SQL_VARCHAR(1024) False True

Issues_fields_assignee_displayName

 SQL_VARCHAR(1024) False True

Issues_fields_assignee_emailAddress

 SQL_VARCHAR(1024) False True

Issues_fields_assignee_key

 SQL_VARCHAR(1024) False True

Issues_fields_assignee_name

 SQL_VARCHAR(1024) False True

Issues_fields_assignee_self

 SQL_VARCHAR(1024) False True

Issues_fields_assignee_timeZone

 SQL_VARCHAR(1024) False True

Issues_fields_created

 SQL_TIMESTAMP False True

Issues_fields_creator_active

 SQL_BIT False True

Issues_fields_creator_avatarUrls_16x16

 SQL_VARCHAR(1024) False True

Issues_fields_creator_avatarUrls_24x24

 SQL_VARCHAR(1024) False True

Issues_fields_creator_avatarUrls_32x32

 SQL_VARCHAR(1024) False True

Issues_fields_creator_avatarUrls_48x48

 SQL_VARCHAR(1024) False True

Issues_fields_creator_displayName

 SQL_VARCHAR(1024) False True

Issues_fields_creator_emailAddress

 SQL_VARCHAR(1024) False True

Issues_fields_creator_key

 SQL_VARCHAR(1024) False True

Issues_fields_creator_name

 SQL_VARCHAR(1024) False True

Issues_fields_creator_self

 SQL_VARCHAR(1024) False True

Issues_fields_creator_timeZone

 SQL_VARCHAR(1024) False True

Issues_fields_description

 SQL_LONGVARCHAR(16777215) False True

Issues_fields_duedate

 SQL_DATE False True

Issues_fields_environment

 SQL_VARCHAR(1024) False True

Issues_fields_epic_color_key

 SQL_VARCHAR(1024) False True

Issues_fields_epic_done

 SQL_BIT False True

Issues_fields_epic_id

 SQL_BIGINT(unsigned) False True

Issues_fields_epic_key

 SQL_VARCHAR(1024) False True

Issues_fields_epic_name

 SQL_VARCHAR(1024) False True

Issues_fields_epic_self

 SQL_VARCHAR(1024) False True

Issues_fields_epic_summary

 SQL_VARCHAR(1024) False True

Issues_fields_flagged

 SQL_BIT False True

Issues_fields_issuetype_avatarId

 SQL_BIGINT(unsigned) False True

Issues_fields_issuetype_description

 SQL_LONGVARCHAR(16777215) False True

Issues_fields_issuetype_iconUrl

 SQL_VARCHAR(1024) False True

Issues_fields_issuetype_id

 SQL_VARCHAR(1024) False True

Issues_fields_issuetype_name

 SQL_VARCHAR(1024) False True

Issues_fields_issuetype_self

 SQL_VARCHAR(1024) False True

Issues_fields_issuetype_subtask

 SQL_BIT False True

Issues_fields_lastViewed

 SQL_VARCHAR(1024) False True

Issues_fields_parent_fields_issuetype_avatarId

 SQL_BIGINT(unsigned) False True

Issues_fields_parent_fields_issuetype_description

 SQL_LONGVARCHAR(16777215) False True

Issues_fields_parent_fields_issuetype_iconUrl

 SQL_VARCHAR(1024) False True

Issues_fields_parent_fields_issuetype_id

 SQL_VARCHAR(1024) False True

Issues_fields_parent_fields_issuetype_name

 SQL_VARCHAR(1024) False True

Issues_fields_parent_fields_issuetype_self

 SQL_VARCHAR(1024) False True

Issues_fields_parent_fields_issuetype_subtask

 SQL_BIT False True

Issues_fields_parent_fields_priority_iconUrl

 SQL_VARCHAR(1024) False True

Issues_fields_parent_fields_priority_id

 SQL_VARCHAR(1024) False True

Issues_fields_parent_fields_priority_name

 SQL_VARCHAR(1024) False True

Issues_fields_parent_fields_priority_self

 SQL_VARCHAR(1024) False True

Issues_fields_parent_fields_status_description

 SQL_LONGVARCHAR(16777215) False True

Issues_fields_parent_fields_status_iconUrl

 SQL_VARCHAR(1024) False True

Issues_fields_parent_fields_status_id

 SQL_VARCHAR(1024) False True

Issues_fields_parent_fields_status_name

 SQL_VARCHAR(1024) False True

Issues_fields_parent_fields_status_self

 SQL_VARCHAR(1024) False True

Issues_fields_parent_fields_status_statusCategory_colorName

 SQL_VARCHAR(1024) False True

Issues_fields_parent_fields_status_statusCategory_id

 SQL_BIGINT(unsigned) False True

Issues_fields_parent_fields_status_statusCategory_key

 SQL_VARCHAR(1024) False True

Issues_fields_parent_fields_status_statusCategory_name

 SQL_VARCHAR(1024) False True

Issues_fields_parent_fields_status_statusCategory_self

 SQL_VARCHAR(1024) False True

Issues_fields_parent_fields_summary

 SQL_VARCHAR(1024) False True

Issues_fields_parent_id

 SQL_VARCHAR(1024) False True

Issues_fields_parent_key

 SQL_VARCHAR(1024) False True

Issues_fields_parent_self

 SQL_VARCHAR(1024) False True

Issues_fields_priority_iconUrl

 SQL_VARCHAR(1024) False True

Issues_fields_priority_id

 SQL_VARCHAR(1024) False True

Issues_fields_priority_name

 SQL_VARCHAR(1024) False True

Issues_fields_priority_self

 SQL_VARCHAR(1024) False True

Issues_fields_progress_percent

 SQL_BIGINT(unsigned) False True

Issues_fields_progress_progress

 SQL_BIGINT(unsigned) False True

Issues_fields_progress_total

 SQL_BIGINT(unsigned) False True

Issues_fields_project_avatarUrls_16x16

 SQL_VARCHAR(1024) False True

Issues_fields_project_avatarUrls_24x24

 SQL_VARCHAR(1024) False True

Issues_fields_project_avatarUrls_32x32

 SQL_VARCHAR(1024) False True

Issues_fields_project_avatarUrls_48x48

 SQL_VARCHAR(1024) False True

Issues_fields_project_id

 SQL_VARCHAR(1024) False True

Issues_fields_project_key

 SQL_VARCHAR(1024) False False

Issues_fields_project_name

 SQL_VARCHAR(1024) False False

Issues_fields_project_projectCategory_description

 SQL_LONGVARCHAR(16777215) False True

Issues_fields_project_projectCategory_id

 SQL_VARCHAR(1024) False True

Issues_fields_project_projectCategory_name

 SQL_VARCHAR(1024) False True

Issues_fields_project_projectCategory_self

 SQL_VARCHAR(1024) False True

Issues_fields_project_self

 SQL_VARCHAR(1024) False True

Issues_fields_reporter_active

 SQL_BIT False True

Issues_fields_reporter_avatarUrls_16x16

 SQL_VARCHAR(1024) False True

Issues_fields_reporter_avatarUrls_24x24

 SQL_VARCHAR(1024) False True

Issues_fields_reporter_avatarUrls_32x32

 SQL_VARCHAR(1024) False True

Issues_fields_reporter_avatarUrls_48x48

 SQL_VARCHAR(1024) False True

Issues_fields_reporter_displayName

 SQL_VARCHAR(1024) False True

Issues_fields_reporter_emailAddress

 SQL_VARCHAR(1024) False True

Issues_fields_reporter_key

 SQL_VARCHAR(1024) False True

Issues_fields_reporter_name

 SQL_VARCHAR(1024) False True

Issues_fields_reporter_self

 SQL_VARCHAR(1024) False True

Issues_fields_reporter_timeZone

 SQL_VARCHAR(1024) False True

Issues_fields_resolution

 SQL_VARCHAR(1024) False True

Issues_fields_resolutiondate

 SQL_VARCHAR(1024) False True

Issues_fields_sprint_id

 SQL_BIGINT(unsigned) False True

Issues_fields_sprint_name

 SQL_VARCHAR(1024) False True

Issues_fields_sprint_self

 SQL_VARCHAR(1024) False True

Issues_fields_sprint_state

 SQL_VARCHAR(1024) False True

Issues_fields_status_description

 SQL_LONGVARCHAR(16777215) False True

Issues_fields_status_iconUrl

 SQL_VARCHAR(1024) False True

Issues_fields_status_id

 SQL_VARCHAR(1024) False True

Issues_fields_status_name

 SQL_VARCHAR(1024) False True

Issues_fields_status_self

 SQL_VARCHAR(1024) False True

Issues_fields_status_statusCategory_colorName

 SQL_VARCHAR(1024) False True

Issues_fields_status_statusCategory_id

 SQL_BIGINT(unsigned) False True

Issues_fields_status_statusCategory_key

 SQL_VARCHAR(1024) False True

Issues_fields_status_statusCategory_name

 SQL_VARCHAR(1024) False True

Issues_fields_status_statusCategory_self

 SQL_VARCHAR(1024) False True

Issues_fields_summary

 SQL_VARCHAR(1024) False True

Issues_fields_timeestimate

 SQL_VARCHAR(1024) False True

Issues_fields_timeoriginalestimate

 SQL_VARCHAR(1024) False True

Issues_fields_timespent

 SQL_VARCHAR(1024) False True

Issues_fields_timetracking_originalEstimate

 SQL_VARCHAR(1024) False True

Issues_fields_timetracking_originalEstimateSeconds

 SQL_BIGINT(unsigned) False True

Issues_fields_timetracking_remainingEstimate

 SQL_VARCHAR(1024) True True

Issues_fields_timetracking_remainingEstimateSeconds

 SQL_BIGINT(unsigned) False True

Issues_fields_timetracking_timeSpent

 SQL_VARCHAR(1024) False True

Issues_fields_timetracking_timeSpentSeconds

 SQL_BIGINT(unsigned) False True

Issues_fields_updated

 SQL_TIMESTAMP False True

Issues_fields_votes_hasVoted

 SQL_BIT False True

Issues_fields_votes_self

 SQL_VARCHAR(1024) False True

Issues_fields_votes_votes

 SQL_BIGINT(unsigned) False True

Issues_fields_watches_isWatching

 SQL_BIT False True

Issues_fields_watches_self

 SQL_VARCHAR(1024) False True

Issues_fields_watches_watchCount

 SQL_BIGINT(unsigned) False True

Issues_id

 SQL_VARCHAR(1024) False True

Issues_self

 SQL_VARCHAR(1024) False True