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


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