Issues

• Issue Id INT

• Key VARCHAR

• Summary VARCHAR

• Description VARCHAR

• Created DATE

• Updated DATE

• Due Date DATE

• Last Viewed DATE

• Resolution Date DATE

• Priority Id INT

• Priority Name VARCHAR

• Is Watching BOOLEAN

• Watch Count INT

• Environment VARCHAR

• Work Ratio DOUBLE

• Votes INT

• Status Changed Date DATE

• Is Subtask BOOLEAN

• Number Of Subtasks INT

Changelogs (Histories)

• History Id INT

• Issue Id INT

• Issue Key VARCHAR

• Created DATE

• Field Id VARCHAR

• Field VARCHAR

• Field Type VARCHAR

• From VARCHAR

• From String VARCHAR

• To VARCHAR

• To String VARCHAR

Worklogs

• Worklog Id INT

• Issue Id INT

• Comment VARCHAR

• Created DATE

• Updated DATE

• Started DATE

• Time Spent Seconds INT

• Time Spent VARCHAR

Comments

• Comment Id INT

• Issue Id INT

• issue key VARCHAR

• Body VARCHAR

• Created DATE

• Updated DATE

Attachments

• Attachment Id INT

• Issue Id INT

• Issue Key VARCHAR

• File Name VARCHAR

• Size INT

• Mime Type VARCHAR

• Created DATE

Labels

• Issue Id INT

• Issue Key VARCHAR

• Label VARCHAR

Fix Versions

• Version Id INT

• Issue Id INT

• Issue Key VARCHAR

• Archived BOOLEAN

• Name VARCHAR

• Description VARCHAR

• Release Date DATE

• Released BOOLEAN

Affects Versions

• Version Id INT

• Issue Id INT

• Issue Key VARCHAR

• Archived BOOLEAN

• Name VARCHAR

• Description VARCHAR

• Release Date DATE

• Released BOOLEAN

Issue Components

• Issue Id INT

• Issue Key VARCHAR

• Component Id INT

• Component Name VARCHAR

Issue Links

• Issue Id INT

• Issue Key VARCHAR

• Issue Link Id INT

• Issue Link Key VARCHAR

• Link Type Id INT

• Link Type Name VARCHAR

• Link Inward VARCHAR

• Link Outward VARCHAR

Projects

• Project Id INT

• Key VARCHAR

• Name VARCHAR

• Description VARCHAR

• Type Key VARCHAR

• Style VARCHAR

• Is Simplified BOOLEAN

• Is Archived BOOLEAN

• Archived Date DATE

• Is Deleted BOOLEAN

• Deleted Date DATE

• Is Private BOOLEAN

• Total Issue Count INT

• Last Issue Update Time DATE

Project Categories

• Project Category Id INT

• Name VARCHAR

• Description VARCHAR

Project Versions

• Version Id INT

• Archived BOOLEAN

• Name VARCHAR

• Description VARCHAR

• Release Date DATE

• Start Date DATE

• Released BOOLEAN

• Overdue BOOLEAN

Project Components

• Component Id INT

• Name VARCHAR

• Description VARCHAR

• Assignee Type VARCHAR

• Is Assignee Type Valid BOOLEAN

Users

• Account Id VARCHAR

• Account Type VARCHAR

• Name VARCHAR

• Email Address VARCHAR

• Is Active BOOLEAN

• Locale VARCHAR

• Time Zone VARCHAR

Group Members

• Group Id VARCHAR

• Group Name VARCHAR

Issue Statuses

• Id INT

• Name VARCHAR

• Description VARCHAR

• Icon URL VARCHAR

• Status Category Id INT

• Status Category Name VARCHAR

Status Categories

• Id INT

• Key VARCHAR

• Name VARCHAR

• Color Name VARCHAR

Issue Types

• Id INT

• Name VARCHAR

• Untranslated Name VARCHAR

• Description VARCHAR

• Is Subtask BOOLEAN

• Icon URL VARCHAR

• Avatar Id INT

• Scope Type VARCHAR

• Scope Project Id INT

• Hierarchy Level INT

Issue Link Types

• Link Type Id INT

• Name VARCHAR

• Inward VARCHAR

• Outward VARCHAR

Resolutions

• Id INT

• Name VARCHAR

• Description VARCHAR

• Is Default BOOLEAN

Priorities

• Priority Id INT

• Name VARCHAR

• Description VARCHAR

• Icon Url VARCHAR

• Status Color VARCHAR

• Is Default BOOLEAN