Skip to content

qs_player_npc_kill_record

Relationships

erDiagram
    qs_player_npc_kill_record {
        int npc_id
        int zone_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
    }
    zone {
        int zoneidnumber
        varchar short_name
        tinyintunsigned version
        varchar content_flags
        varchar content_flags_disabled
    }
    qs_player_npc_kill_record ||--o{ npc_types : "One-to-One"
    qs_player_npc_kill_record ||--o{ zone : "One-to-One"
Relationship Type Local Key Relates to Table Foreign Key
One-to-One npc_id npc_types id
One-to-One zone_id zone zoneidnumber

Schema

Column Data Type Description
fight_id int Unique Fight Identifier
npc_id int NPC Type Identifier
type int Type (2 - Raid, 1 - Group, 0 - Solo)
zone_id int Zone Identifier
time timestamp Time Timestamp