Skip to content

qs_player_trade_record

Relationships

erDiagram
    qs_player_trade_record {
        int char1_id
        int char2_id
    }
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    }
    qs_player_trade_record ||--o{ character_data : "One-to-One"
    qs_player_trade_record ||--o{ character_data : "One-to-One"
Relationship Type Local Key Relates to Table Foreign Key
One-to-One char1_id character_data id
One-to-One char2_id character_data id

Schema

Column Data Type Description
trade_id int Unique Trade Identifier
time timestamp Time Timestamp
char1_id int Character 1 Identifier
char1_pp int Character 1 Platinum
char1_gp int Character 1 Gold
char1_sp int Character 1 Silver
char1_cp int Character 1 Copper
char1_items mediumint Character 1 Item Identifier
char2_id int Character 2 Identifier
char2_pp int Character 2 Platinum
char2_gp int Character 2 Gold
char2_sp int Character 2 Silver
char2_cp int Character 2 Copper
char2_items mediumint Character 2 Item Identifier