eqemu-docs/docs/schema/spawns/spawn_conditions.md

spawn_conditions

Relationships

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

Relationship Type	Local Key	Relates to Table	Foreign Key
One-to-One	id	spawn_condition_values	id
One-to-One	zone	zone	short_name

Schema

Column	Data Type	Description
zone	varchar	Zone Short Name
id	mediumint	Spawn Condition Identifier
value	mediumint	Value
onchange	tinyint	On Change Type
name	varchar	Name