Skip to content



    bug_reports {
        intunsigned account_id
        varchar zone
        intunsigned character_id
        varchar character_name
    zone {
        int zoneidnumber
        varchar short_name
        tinyintunsigned version
        varchar content_flags
        varchar content_flags_disabled
    account {
        int id
        varchar name
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    bug_reports ||--o{ zone : "One-to-One"
    bug_reports ||--o{ account : "One-to-One"
    bug_reports ||--o{ character_data : "One-to-One"
    bug_reports ||--o{ character_data : "One-to-One"

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