Skip to content



    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


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