Skip to content

loottable_entries

Relationships

erDiagram
    loottable_entries {
        intunsigned loottable_id
        intunsigned lootdrop_id
    }
    loottable {
        varchar content_flags
        varchar content_flags_disabled
        intunsigned id
    }
    lootdrop_entries {
        int item_id
        intunsigned lootdrop_id
    }
    loottable_entries ||--o{ loottable : "One-to-One"
    loottable_entries ||--o{ lootdrop_entries : "Has-Many"
Relationship Type Local Key Relates to Table Foreign Key
One-to-One loottable_id loottable id
Has-Many lootdrop_id lootdrop_entries lootdrop_id

Schema

Column Data Type Description
loottable_id int Loottable Identifier
lootdrop_id int Lootdrop Identifier
multiplier tinyint Multiplier
droplimit tinyint Maximum Drops
mindrop tinyint Minimum Drops
probability float Probability: 0 = Never, 100 = Always