merchantlist¶
Info
This page was last generated 2023.04.23
Relationship Diagram(s)¶
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 |