Skip to content



This page was last generated 2023.07.15

Relationship Diagram(s)

Diagram Edit


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


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