character_bind

Relationships

erDiagram
    character_bind {
        intunsigned id
        smallintunsigned zone_id
        mediumintunsigned instance_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_bind ||--o{ character_data : "One-to-One"
    character_bind ||--o{ zone : "One-to-One"
    character_bind ||--o{ instance_list : "One-to-One"

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

Schema

Column	Data Type	Description
id	int	Character Identifier
slot	int	Slot
zone_id	smallint	Zone Identifier
instance_id	mediumint	Instance Identifier
x	float	X Coordinate
y	float	Y Coordinate
z	float	Z Coordinate
heading	float	Heading Coordinate