Skip to content



    character_instance_safereturns {
        intunsigned character_id
        int instance_zone_id
        int instance_id
        int safe_zone_id
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    zone {
        int zoneidnumber
        varchar short_name
        tinyintunsigned version
        varchar content_flags
        varchar content_flags_disabled
    instance_list {
        int id
        tinyintunsigned version
        intunsigned zone
    character_instance_safereturns ||--o{ character_data : "One-to-One"
    character_instance_safereturns ||--o{ zone : "One-to-One"
    character_instance_safereturns ||--o{ instance_list : "One-to-One"
    character_instance_safereturns ||--o{ zone : "One-to-One"

Relationship Type Local Key Relates to Table Foreign Key
One-to-One character_id character_data id
One-to-One instance_zone_id zone zoneidnumber
One-to-One instance_id instance_list id
One-to-One safe_zone_id zone zoneidnumber


Column Data Type Description
id int Safe Return Identifier
character_id int Character Identifier
instance_zone_id int Instance Zone Identifier
instance_id int Instance Identifier
safe_zone_id int Save Zone Identifier
safe_x float Safe X Coordinate
safe_y float Safe Y Coordinate
safe_z float Safe Z Coordinate
safe_heading float Safe Heading Coordinate