merc_armorinfo

Relationships

erDiagram
    merc_armorinfo {
        varchar armortint_id
        varchar merc_npc_type_id
    }
    npc_types_tint {
        intunsigned id
    }
    merc_npc_types {
        varchar merc_npc_type_id
    }
    merc_armorinfo ||--o{ npc_types_tint : "Has-Many"
    merc_armorinfo ||--o{ merc_npc_types : "One-to-One"

Relationship Type	Local Key	Relates to Table	Foreign Key
Has-Many	armortint_id	npc_types_tint	id
One-to-One	merc_npc_type_id	merc_npc_types	merc_npc_type_id

Schema

Column	Data Type	Description
id	int	Unique Mercenary Armor Info Identifier
merc_npc_type_id	int	Mercenary NPC Type Identifier
minlevel	tinyint	Minimum Level
maxlevel	tinyint	Maximum Level
texture	tinyint	Texture
helmtexture	tinyint	Helmet Texture
armortint_id	int	Armor Tint Identifier
armortint_red	tinyint	Armor Tint Red: 0 = None, 255 = Max
armortint_green	tinyint	Armor Tint Green: 0 = None, 255 = Max
armortint_blue	tinyint	Armor Tint Blue: 0 = None, 255 = Max