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 |