merc_weaponinfo

Relationships

erDiagram
    merc_weaponinfo {
        varchar merc_npc_type_id
    }
    merc_npc_types {
        varchar merc_npc_type_id
    }
    merc_weaponinfo ||--o{ merc_npc_types : "One-to-One"

Relationship Type	Local Key	Relates to Table	Foreign Key
One-to-One	merc_npc_type_id	merc_npc_types	merc_npc_type_id

Schema

Column	Data Type	Description
id	int	Unique Mercenary Weapon Info Identifier
merc_npc_type_id	int	Mercenary NPC Type Identifier
minlevel	tinyint	Minimum Level
maxlevel	tinyint	Maximum Level
d_melee_texture1	int	Primary Weapon Texture
d_melee_texture2	int	Secondary Weapon Texture
prim_melee_type	tinyint	Primary Melee Type
sec_melee_type	tinyint	Secondary Melee Type