bug_reports¶
Info
This page was last generated 2023.07.15
Relationship Diagram(s)¶
Relationships¶
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 |
Schema¶
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 |