Skip to content



    qs_merchant_transaction_record {
        int char_id
        int merchant_id
        int zone_id
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    merchantlist {
        varchar content_flags
        varchar content_flags_disabled
        varchar bucket_name
        int item
        varchar merchant_id
        int merchantid
    zone {
        int zoneidnumber
        varchar short_name
        tinyintunsigned version
        varchar content_flags
        varchar content_flags_disabled
    qs_merchant_transaction_record ||--o{ character_data : "One-to-One"
    qs_merchant_transaction_record ||--o{ merchantlist : "Has-Many"
    qs_merchant_transaction_record ||--o{ zone : "One-to-One"

Relationship Type Local Key Relates to Table Foreign Key
One-to-One char_id character_data id
Has-Many merchant_id merchantlist merchantid
One-to-One zone_id zone zoneidnumber


Column Data Type Description
transaction_id int Unique Transaction Identifier
time timestamp Timestamp
zone_id int Zone Identifier
merchant_id int Merchant Identifier
merchant_pp int Merchant Platinum
merchant_gp int Merchant Gold
merchant_sp int Merchant Silver
merchant_cp int Merchant Copper
merchant_items mediumint Merchant Items
char_id int Unique 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