trader_audit¶
Info
This page was last generated 2023.04.23
Relationship Diagram(s)¶
Relationships¶
| Relationship Type | Local Key | Relates to Table | Foreign Key |
|---|---|---|---|
| One-to-One | buyer | character_data | name |
| One-to-One | itemname | items | name |
| One-to-One | seller | character_data | name |
Schema¶
| Column | Data Type | Description |
|---|---|---|
| time | datetime | Time |
| seller | varchar | Seller |
| buyer | varchar | Buyer |
| itemname | varchar | Item Name |
| quantity | int | Quantity |
| totalcost | int | Total Cost |
| trantype | tinyint | Transaction Type |