qs_merchant_transaction_record_entries

Relationships

erDiagram
    qs_merchant_transaction_record_entries {
        int item_id
        int aug_1
        int aug_2
        int aug_3
        int aug_4
        int aug_5
    }
    items {
        int id
        int book
        varchar name
        int recasttype
        int icon
        mediumint bardeffect
        int clickeffect
        int focuseffect
        int proceffect
        int scrolleffect
        int worneffect
    }
    qs_merchant_transaction_record_entries ||--o{ items : "One-to-One"
    qs_merchant_transaction_record_entries ||--o{ items : "One-to-One"
    qs_merchant_transaction_record_entries ||--o{ items : "One-to-One"
    qs_merchant_transaction_record_entries ||--o{ items : "One-to-One"
    qs_merchant_transaction_record_entries ||--o{ items : "One-to-One"
    qs_merchant_transaction_record_entries ||--o{ items : "One-to-One"

Relationship Type	Local Key	Relates to Table	Foreign Key
One-to-One	aug_1	items	id
One-to-One	aug_2	items	id
One-to-One	aug_3	items	id
One-to-One	aug_4	items	id
One-to-One	aug_5	items	id
One-to-One	item_id	items	id

Schema

Column	Data Type	Description
event_id	int	Unique Event Identifier
char_slot	mediumint	Character Slot Identifier
item_id	int	Item Identifier
charges	mediumint	Charges
aug_1	int	Augment Slot 1
aug_2	int	Augment Slot 2
aug_3	int	Augment Slot 3
aug_4	int	Augment Slot 4
aug_5	int	Augment Slot 5