Skip to content



This page was last generated 2023.07.15

Relationship Diagram(s)

Diagram Edit


Relationship Type Local Key Relates to Table Foreign Key
One-to-One zone zone short_name
One-to-One account_id account id
One-to-One character_id character_data id
One-to-One character_name character_data name


Column Data Type Description
id int Unique Bug Report Identifier
zone varchar Zone Short Name
client_version_id int Client Version Identifier
client_version_name varchar Client Version Name
account_id int Account Identifier
character_id int Character Identifier
character_name varchar Character Name
reporter_spoof tinyint Reporter Spoof
category_id int Category Identifier
category_name varchar Category Name
reporter_name varchar Reporter Name
ui_path varchar UI Path
pos_x float Position X Coordinate
pos_y float Position Y Coordinate
pos_z float Position Z Coordinate
heading int Heading Coordinate
time_played int Time Played in Seconds
target_id int Target Identifier
target_name varchar Target Name
optional_info_mask int Optional Info Mask: 0 = False, 1 = True
_can_duplicate tinyint Can Duplicate: 0 = False, 1 = True
_crash_bug tinyint Crash Bug
_target_info tinyint Target Info
_character_flags tinyint Character Flags
_unknown_value tinyint Unknown
bug_report varchar Bug Report
system_info varchar System Information
report_datetime datetime Report Datetime
bug_status tinyint Bug Status
last_review datetime Last Review Datetime
last_reviewer varchar Last Reviewer
reviewer_notes varchar Reviewer Notes