eqemu-docs/docs/schema/admin/bug_reports.md

bug_reports

Relationships

erDiagram
    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

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