lootdrop

Relationships

erDiagram
    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

Schema

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