Skip to content



    trader_audit {
        varchar buyer
        varchar seller
        varchar itemname
    character_data {
        intunsigned id
        varchar name
        varchar nane
        intunsigned zone_instance
        intunsigned zone_id
    items {
        int id
        int book
        varchar name
        int recasttype
        int icon
        mediumint bardeffect
        int clickeffect
        int focuseffect
        int proceffect
        int scrolleffect
        int worneffect
    trader_audit ||--o{ character_data : "One-to-One"
    trader_audit ||--o{ items : "One-to-One"
    trader_audit ||--o{ character_data : "One-to-One"

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


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