Skip to content

expeditions

Relationships

erDiagram
    expeditions {
        intunsigned id
        intunsigned dynamic_zone_id
    }
    dynamic_zones {
        int dz_switch_id
        intunsigned id
        intunsigned compass_zone_id
        int instance_id
        intunsigned safe_return_zone_id
    }
    expeditions ||--o{ dynamic_zones : "One-to-One"

Relationship Type Local Key Relates to Table Foreign Key
One-to-One dynamic_zone_id dynamic_zones id

Schema

Column Data Type Description
id int Unique Expedition Identifier
dynamic_zone_id int Dynamic Zone Identifier
add_replay_on_join tinyint Add Replay On Join: 0 = False, 1 = True
is_locked tinyint Is Locked: 0 = False, 1 = True