fishing¶
Info
This page was last generated 2023.07.15
Relationship Diagram(s)¶
Relationships¶
| 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 | Itemid | items | id |
| One-to-One | zoneid | zone | zoneidnumber |
| One-to-One | npc_id | npc_types | id |
Schema¶
| Column | Data Type | Description |
|---|---|---|
| id | int | Unique Fishing Identifier |
| zoneid | int | Zone Identifier |
| Itemid | int | Item Identifier |
| skill_level | smallint | Skill Level |
| chance | smallint | Chance: 0 = Never, 100 = Always |
| npc_id | int | NPC Type Identifier |
| npc_chance | int | NPC Chance: 0 = Never, 100 = Always |
| 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 |