fishing

Relationships

erDiagram
    fishing {
        varchar content_flags
        varchar content_flags_disabled
        int Itemid
        int zoneid
        int npc_id
    }
    content_flags {
        varchar flag_name
    }
    items {
        int id
        int book
        varchar name
        int recasttype
        int icon
        mediumint bardeffect
        int clickeffect
        int focuseffect
        int proceffect
        int scrolleffect
        int worneffect
    }
    zone {
        int zoneidnumber
        varchar short_name
        tinyintunsigned version
        varchar content_flags
        varchar content_flags_disabled
    }
    npc_types {
        intunsigned alt_currency_id
        int id
        int npc_faction_id
        text name
        intunsigned loottable_id
        intunsigned merchant_id
        intunsigned emoteid
        intunsigned adventure_template_id
        intunsigned armortint_id
        intunsigned npc_spells_id
        intunsigned npc_spells_effects_id
        intunsigned trap_template
    }
    fishing ||--o{ content_flags : "One-to-One"
    fishing ||--o{ content_flags : "One-to-One"
    fishing ||--o{ items : "One-to-One"
    fishing ||--o{ zone : "One-to-One"
    fishing ||--o{ npc_types : "One-to-One"

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