dynamic_zones

Info

This page was last generated 2023.07.15

Relationship Diagram(s)

Diagram Edit

Relationships

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