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

Browser not supported