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 | |
| SECURITY | BIGINT | |
| VOTES | BIGINT | |
| WATCHES | BIGINT | |
| ORIGINALESTIMATE | BIGINT | |
| ESTIMATE | BIGINT | |
| TIMESPENT | BIGINT |