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