Api_Issue

The table below describes the Api_Issue table in the Extra database schema.

This table contains the following foldable columns:

  • Issue_Key
  • Fields_Assignee_Key
  • Fields_Assignee_Name
  • Fields_Created
  • Fields_Due_Date
  • Fields_Environment
  • Fields_Issue_Type_Name
  • Fields_Priority_Id
  • Fields_Priority_Name
  • Fields_Project_Id
  • Fields_Project_Key
  • Fields_Reporter_Name
  • Fields_Resolution_Date
  • Fields_Resolution_Id
  • Fields_Resolution_Name
  • Fields_Status_Name
  • Fields_Summary
  • Fields_TimeOriginalEstimate
  • Fields_Updated
  • Issue_Id
  • Last_Viewed

The primary key columns in this table are returnable.

Column Name SQL Type Updatable Nullable

Issue_Key

Primary Key
SQL_VARCHAR(1024) False False

Fields_AggregateTimeEstimate

SQL_VARCHAR(1024) False True

Fields_AggregateTimeOriginalEstimate

SQL_VARCHAR(1024) False True

Fields_AggregateTimeSpent

SQL_VARCHAR(1024) False True

Fields_Assignee_Key

SQL_VARCHAR(1024) True True

Fields_Assignee_Name

SQL_VARCHAR(1024) True True

Fields_Created

SQL_TIMESTAMP False False

Fields_Description

SQL_LONGVARCHAR(16777215) False True

Fields_Due_Date

SQL_DATE False False

Fields_Environment

SQL_LONGVARCHAR(16777215) False True

Fields_Issue_Type_Id

SQL_VARCHAR(1024) True True

Fields_Issue_Type_Name

SQL_VARCHAR(1024) True True

Fields_Priority_Id

SQL_VARCHAR(1024) True True

Fields_Priority_Name

SQL_VARCHAR(1024) True True

Fields_Project_Id

SQL_VARCHAR(1024) True True

Fields_Project_Key

SQL_VARCHAR(1024) False False

Fields_Reporter_Name

SQL_VARCHAR(1024) True True

Fields_Resolution_Date

SQL_TIMESTAMP False False

Fields_Resolution_Description

SQL_LONGVARCHAR(16777215) False True

Fields_Resolution_Id

SQL_VARCHAR(1024) False True

Fields_Resolution_Name

SQL_VARCHAR(1024) False True

Fields_Status_Name

SQL_VARCHAR(1024) True True

Fields_Summary

SQL_VARCHAR(1024) True True

Fields_TimeEstimate

SQL_VARCHAR(1024) False True

Fields_TimeOriginalEstimate

SQL_VARCHAR(1024) False True

Fields_Timespent

SQL_VARCHAR(1024) False True

Fields_Timetracking_OriginalEstimate

SQL_VARCHAR(1024) False True

Fields_Timetracking_OriginalEstimateSeconds

SQL_VARCHAR(1024) False True

Fields_Timetracking_RemainingEstimate

SQL_VARCHAR(1024) False True

Fields_Timetracking_RemainingEstimateSeconds

SQL_VARCHAR(1024) False True

Fields_Timetracking_TimeSpentSeconds

SQL_VARCHAR(1024) False True

Fields_Timetracking_timeSpent

SQL_VARCHAR(1024) False True

Fields_Updated

SQL_TIMESTAMP False False

Has_Voted

SQL_BIT False True

Is_Watching

SQL_BIT False True

Issue_Id

SQL_VARCHAR(1024) False False

Last_Viewed

SQL_VARCHAR(1024) False True

Progress

SQL_INTEGER(unsigned) False True

Progress_Percent

SQL_INTEGER(unsigned) False True

Progress_Total

SQL_INTEGER(unsigned) False True

Votes

SQL_INTEGER(unsigned) False True

Watch_Count

SQL_INTEGER(unsigned) False True