global_loot

Relationships

erDiagram
    global_loot {
        varchar content_flags
        varchar content_flags_disabled
        int loottable_id
        mediumtext zone
    }
    content_flags {
        varchar flag_name
    }
    loottable {
        varchar content_flags
        varchar content_flags_disabled
        intunsigned id
    }
    zone {
        int zoneidnumber
        varchar short_name
        tinyintunsigned version
        varchar content_flags
        varchar content_flags_disabled
    }
    global_loot ||--o{ content_flags : "One-to-One"
    global_loot ||--o{ content_flags : "One-to-One"
    global_loot ||--o{ loottable : "One-to-One"
    global_loot ||--o{ zone : "One-to-One"

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
One-to-One	loottable_id	loottable	id
One-to-One	zone	zone	short_name

Schema

Column	Data Type	Description
id	int	Unique Global Loot Identifier
description	varchar	Description
loottable_id	int	Loottable Identifier
enabled	tinyint	Enabled: 0 = False, 1 = True
min_level	int	Minimum Level
max_level	int	Maximum Level
rare	tinyint	Rare: 0 = False, 1 = True
raid	tinyint	Raid: 0 = False, 1 = True
race	mediumtext	Race, multiple races supported if
class	mediumtext	Class, multiple classes supported if
bodytype	mediumtext	Body Type, multiple body types supported if
zone	mediumtext	Zone Short Name,, multiple zones supported if
hot_zone	tinyint	Hot Zone: 0 = False, 1 = True
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