Skip to content

faction_list

Relationships

erDiagram
    faction_list {
        int id
    }
    faction_list_mod {
        intunsigned faction_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
    }
    faction_list ||--o{ faction_list_mod : "Has-Many"
    faction_list ||--o{ npc_types : "Has-Many"

Relationship Type Local Key Relates to Table Foreign Key
Has-Many id faction_list_mod faction_id
Has-Many id npc_types npc_faction_id

Schema

Column Data Type Description
id int Unique Faction Identifier
name varchar Name
base smallint Base