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 bucket_name data_buckets key
One-to-One content_flags content_flags flag_name
One-to-One content_flags_disabled content_flags flag_name
One-to-One item items id
Has-Many merchant_id npc_types merchant_id


Column Data Type Description
merchantid int Merchant Identifier
slot int Slot
item int Item Identifier
faction_required smallint Faction Required
level_required tinyint Level Required
min_status tinyint Minimum Status
max_status tinyint Maximum Status
alt_currency_cost smallint Alternate Currency Cost
classes_required int Classes Required
probability int Probability: 0 = Never, 100 = Always
bucket_name varchar Bucket Name
bucket_value varchar Bucket Value
bucket_comparison tinyint Bucket Comparison Type
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