Skip to content

merchantlist

Info

This page was last generated 2023.04.23

Relationship Diagram(s)

Diagram Edit

Relationships

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

Schema

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
max_status tinyint
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