/
Table ISSUES
Table ISSUES
This table does not contain all issues from JIRA. It only exposes issues for which the user has permission to see.
Column | Type | Notes |
---|---|---|
ID | BIGINT NOT NULL | Database ID of an issue - this is not an issue key. |
SUMMARY | VARCHAR | |
PROJECT | BIGINT | Points to Table PROJECTS |
NUM | BIGINT | This is part of an issue key |
CREATOR | VARCHAR | |
ASSIGNEE | VARCHAR | |
REPORTER | VARCHAR | |
CREATED | TIMESTAMP | |
UPDATED | TIMESTAMP | |
DUE | TIMESTAMP | |
RESOLVED | TIMESTAMP | |
DESCRIPTION | VARCHAR | |
ENVIRONMENT | VARCHAR | |
ISSUETYPE | VARCHAR | Points to Table ISSUETYPES |
PRIORITY | VARCHAR | Points to Table PRIORITIES |
RESOLUTION | VARCHAR | |
STATUS | VARCHAR | Points to Table STATUSES |
SECURITY | BIGINT | |
VOTES | BIGINT | |
WATCHES | BIGINT | |
ORIGINALESTIMATE | BIGINT | |
ESTIMATE | BIGINT | |
TIMESPENT | BIGINT |
, multiple selections available,
Related content
Schema EXAMPLES
Schema EXAMPLES
Read with this
Data model
Data model
Read with this
Table ISSUELINKS
Table ISSUELINKS
Read with this
Using builtin SQL navigator
Using builtin SQL navigator
Read with this
Table PROJECTS
Table PROJECTS
Read with this