Skip to content



This page was last generated 2023.07.15

Relationship Diagram(s)

Diagram Edit


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


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