qs_merchant_transaction_record

Relationships

erDiagram
    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

Schema

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