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 char_id character_data id
Has-Many merchant_id merchantlist merchantid
One-to-One zone_id zone zoneidnumber


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