Skip to content



    dynamic_zones {
        int dz_switch_id
        intunsigned id
        intunsigned compass_zone_id
        int instance_id
        intunsigned safe_return_zone_id
    zone {
        int zoneidnumber
        varchar short_name
        tinyintunsigned version
        varchar content_flags
        varchar content_flags_disabled
    doors {
        varchar content_flags
        varchar content_flags_disabled
        int dz_switch_id
        int keyitem
        varchar zone
        varchar dest_zone
        intunsigned dest_instance
        smallint version
    dynamic_zone_members {
        intunsigned character_id
        intunsigned dynamic_zone_id
    instance_list {
        int id
        tinyintunsigned version
        intunsigned zone
    dynamic_zones ||--o{ zone : "One-to-One"
    dynamic_zones ||--o{ doors : "Has-Many"
    dynamic_zones ||--o{ dynamic_zone_members : "Has-Many"
    dynamic_zones ||--o{ instance_list : "One-to-One"
    dynamic_zones ||--o{ zone : "One-to-One"

Relationship Type Local Key Relates to Table Foreign Key
One-to-One compass_zone_id zone zoneidnumber
Has-Many dz_switch_id doors dz_switch_id
Has-Many id dynamic_zone_members dynamic_zone_id
One-to-One instance_id instance_list id
One-to-One safe_return_zone_id zone zoneidnumber


Column Data Type Description
id int Unique Dynamic Zone Identifier
instance_id int Instance Identifier
type tinyint Type
uuid varchar UUID
name varchar Name
leader_id int Leader Character Identifier
min_players int Minimum Players
max_players int Maximum Players
dz_switch_id int Dynamic Zone Switch Identifier](../../schema/doors/
compass_zone_id int Compass Zone Identifier
compass_x float Compass X Coordinate
compass_y float Compass Y Coordinate
compass_z float Compass Z Coordinate
safe_return_zone_id int Safe Return Zone Identifier
safe_return_x float Safe Return X Coordinate
safe_return_y float Safe Return Y Coordinate
safe_return_z float Safe Return Z Coordinate
safe_return_heading float Safe Return Heading Coordinate
zone_in_x float Zone In X Coordinate
zone_in_y float Zone In Y Coordinate
zone_in_z float Zone In Z Coordinate
zone_in_heading float Zone In Heading Coordinate
has_zone_in tinyint Has Zone In: 0 = False, 1 = True