buyer

Relationships

erDiagram
    buyer {
        int charid
        int itemid
        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
    }
    buyer ||--o{ character_data : "One-to-One"
    buyer ||--o{ items : "One-to-One"
    buyer ||--o{ items : "One-to-One"

Relationship Type	Local Key	Relates to Table	Foreign Key
One-to-One	charid	character_data	id
One-to-One	itemid	items	id
One-to-One	itemname	items	name

Schema

Column	Data Type	Description
charid	int	Character Identifier
buyslot	int	Slot
itemid	int	Item Identifier
itemname	varchar	Item Name
quantity	int	Quantity
price	int	Price