qs_merchant_transaction_record¶
Info
This page was last generated 2023.07.15
Relationship Diagram(s)¶
Relationships¶
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 |