dynamic_zones

Relationships

erDiagram
    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

Schema

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/doors.md)
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