Skip to content



    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


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