Skip to content



    npc_faction_entries {
        intunsigned npc_faction_id
        intunsigned faction_id
    faction_list {
        int id
    npc_faction {
        int id
        int primaryfaction
    npc_faction_entries ||--o{ faction_list : "One-to-One"
    npc_faction_entries ||--o{ npc_faction : "One-to-One"

Relationship Type Local Key Relates to Table Foreign Key
One-to-One faction_id faction_list id
One-to-One npc_faction_id npc_faction id


Column Data Type Description
npc_faction_id int NPC Faction Identifier
faction_id int Faction Identifier
value int Value
npc_value tinyint NPC Value: -1 = Attack, 0 = Neutral, 1 = Assist
temp tinyint Temeporary: 0 = Faction is permanent, player recieves a message, 1 = Faction is temporary, player does not recieve a message, 2 = Faction is temporary, player recieves a message, 3 = Faction is permanent, but player does not recieve a message.