bugs

Relationships

erDiagram
    bugs {
        varchar zone
        varchar name
    }
    zone {
        int zoneidnumber
        varchar short_name
        tinyintunsigned version
        varchar content_flags
        varchar content_flags_disabled
    }
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    }
    bugs ||--o{ zone : "One-to-One"
    bugs ||--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	name	character_data	name

Schema

Column	Data Type	Description
id	int	Unique Bug Identifier
zone	varchar	Zone Short Name
name	varchar	Player Name
ui	varchar	UI
x	float	X Coordinate
y	float	Y Coordinate
z	float	Z Coordinate
type	varchar	Type
flag	tinyint	Flag
target	varchar	Target when reported
bug	varchar	Bug reported
date	date	Date when reported
status	tinyint	[Account Status of Reporter](../../../../server/player/status-levels