Skip to content



    lootdrop {
        varchar content_flags
        varchar content_flags_disabled
        intunsigned id
    content_flags {
        varchar flag_name
    lootdrop_entries {
        int item_id
        intunsigned lootdrop_id
    loottable_entries {
        intunsigned loottable_id
        intunsigned lootdrop_id
    lootdrop ||--o{ content_flags : "One-to-One"
    lootdrop ||--o{ content_flags : "One-to-One"
    lootdrop ||--o{ lootdrop_entries : "Has-Many"
    lootdrop ||--o{ loottable_entries : "Has-Many"

Relationship Type Local Key Relates to Table Foreign Key
One-to-One content_flags content_flags flag_name
One-to-One content_flags_disabled content_flags flag_name
Has-Many id lootdrop_entries lootdrop_id
Has-Many id loottable_entries loottable_id


Column Data Type Description
id int Unique Lootdrop Identifier
name varchar Name
min_expansion tinyint Minimum Expansion
max_expansion tinyint Maximum Expansion
content_flags varchar Content Flags Required to be Enabled
content_flags_disabled varchar Content Flags Required to be Disabled