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

spawnentry

Relationships

erDiagram
    spawnentry {
        varchar content_flags
        varchar content_flags_disabled
        int npcID
        int spawngroupID
    }
    content_flags {
        varchar flag_name
    }
    spawngroup {
        int id
    }
    npc_types {
        intunsigned alt_currency_id
        int id
        int npc_faction_id
        text name
        intunsigned loottable_id
        intunsigned merchant_id
        intunsigned emoteid
        intunsigned adventure_template_id
        intunsigned armortint_id
        intunsigned npc_spells_id
        intunsigned npc_spells_effects_id
        intunsigned trap_template
    }
    spawnentry ||--o{ content_flags : "One-to-One"
    spawnentry ||--o{ content_flags : "One-to-One"
    spawnentry ||--o{ spawngroup : "One-to-One"
    spawnentry ||--o{ npc_types : "One-to-One"

Relationship Type	Local Key	Relates to Table	Foreign Key
One-to-One	content_flags	content_flags	flag_name
One-to-One	content_flags_disabled	content_flags	flag_name
One-to-One	spawngroupID	spawngroup	id
One-to-One	npcID	npc_types	id

Schema

Column	Data Type	Description
spawngroupID	int	Unique Spawn Group Identifier
npcID	int	NPC Type Identifier
chance	smallint	Chance: 0 = Never, 100 = Always
condition_value_filter	mediumint	Condition Value Filter
min_time	smallint
max_time	smallint
min_expansion	tinyint	Minimum Expansion
max_expansion	tinyint	Maximum Expansion
content_flags	varchar	Content Flags Required to be Enabled
content_flags_disabled	varchar	Content Flags Required to be Disabled