npc_faction_entries

Relationships

erDiagram
    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

Schema

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.