horses

Relationships

erDiagram
    horses {
        varchar filename
    }
    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
    }
    horses ||--o{ npc_types : "One-to-One"

Relationship Type	Local Key	Relates to Table	Foreign Key
One-to-One	filename	npc_types	name

Schema

Column	Data Type	Description
id	int	Unique Horse Identifier
filename	varchar	NPC Type Name
race	smallint	Race
gender	tinyint	Gender
texture	tinyint	Texture
mountspeed	float	Mount Run Speed
notes	varchar	Notes