Skip to content



    qs_player_handin_record {
        int char_id
        int npc_id
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned 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
    qs_player_handin_record ||--o{ character_data : "One-to-One"
    qs_player_handin_record ||--o{ npc_types : "One-to-One"

Relationship Type Local Key Relates to Table Foreign Key
One-to-One char_id character_data id
One-to-One npc_id npc_types id


Column Data Type Description
handin_id int Unique Handin Identifier
time timestamp Time Timestamp
quest_id int Quest Identifier
char_id int Character Identifier
char_pp int Character Platinum
char_gp int Character Gold
char_sp int Character Silver
char_cp int Character Copper
char_items mediumint Character Items Identifier
npc_id int NPC Type Identifier
npc_pp int NPC Platinum
npc_gp int NPC Gold
npc_sp int NPC Silver
npc_cp int NPC Copper
npc_items mediumint NPC Item Identifier