eqemu-docs/docs/schema/instances/instance_list.md

instance_list

Relationships

erDiagram
    instance_list {
        int id
        tinyintunsigned version
        intunsigned zone
    }
    adventure_details {
        intunsigned id
        smallintunsigned adventure_id
        int instance_id
    }
    character_bind {
        intunsigned id
        smallintunsigned zone_id
        mediumintunsigned instance_id
    }
    character_corpses {
        intunsigned id
        intunsigned charid
        varchar charname
        smallintunsigned instance_id
        smallint zone_id
    }
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    }
    character_instance_safereturns {
        intunsigned character_id
        int instance_zone_id
        int instance_id
        int safe_zone_id
    }
    instance_list ||--o{ adventure_details : "Has-Many"
    instance_list ||--o{ character_bind : "Has-Many"
    instance_list ||--o{ character_corpses : "Has-Many"
    instance_list ||--o{ character_data : "Has-Many"
    instance_list ||--o{ character_instance_safereturns : "Has-Many"
    instance_list ||--o{ character_instance_safereturns : "Has-Many"

erDiagram
    instance_list {
        int id
        tinyintunsigned version
        intunsigned zone
    }
    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_zones {
        int dz_switch_id
        intunsigned id
        intunsigned compass_zone_id
        int instance_id
        intunsigned safe_return_zone_id
    }
    respawn_times {
        smallint instance_id
        int id
    }
    spawn_condition_values {
        intunsigned instance_id
        intunsigned id
        varchar zone
    }
    zone_points {
        varchar content_flags
        varchar content_flags_disabled
        intunsigned target_instance
        varchar zone
        intunsigned target_zone_id
        int version
    }
    instance_list ||--o{ doors : "Has-Many"
    instance_list ||--o{ dynamic_zones : "Has-Many"
    instance_list ||--o{ respawn_times : "Has-Many"
    instance_list ||--o{ spawn_condition_values : "Has-Many"
    instance_list ||--o{ zone_points : "Has-Many"

erDiagram
    instance_list {
        int id
        tinyintunsigned version
        intunsigned zone
    }
    zone {
        int zoneidnumber
        varchar short_name
        tinyintunsigned version
        varchar content_flags
        varchar content_flags_disabled
    }
    instance_list ||--o{ zone : "One-to-One"
    instance_list ||--o{ zone : "One-to-One"

Relationship Type	Local Key	Relates to Table	Foreign Key
Has-Many	id	adventure_details	instance_id
Has-Many	id	character_bind	instance_id
Has-Many	id	character_corpses	instance_id
Has-Many	id	character_data	zone_instance
Has-Many	id	character_instance_safereturns	instance_id
Has-Many	id	character_instance_safereturns	instance_zone_id
Has-Many	id	doors	dest_instance
Has-Many	id	dynamic_zones	instance_id
Has-Many	id	respawn_times	instance_id
Has-Many	id	spawn_condition_values	instance_id
Has-Many	id	zone_points	target_instance
One-to-One	version	zone	version
One-to-One	zone	zone	zoneidnumber

Schema

Column	Data Type	Description
id	int	Unique Instance Identifier
zone	int	Zone Identifier
version	tinyint	Version
is_global	tinyint	Is Global: 0 = False, 1 = True
start_time	int	Start Time UNIX Timestamp
duration	int	Duration in Seconds
never_expires	tinyint	Never Expires: 0 = False, 1 = True
notes	varchar