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 |