aa_ranks

Relationships

erDiagram
    aa_ranks {
        intunsigned id
    }
    aa_ability {
        int first_rank_id
    }
    aa_rank_effects {
        intunsigned rank_id
    }
    aa_rank_prereqs {
        int aa_id
        intunsigned rank_id
    }
    character_alternate_abilities {
        smallintunsigned aa_id
        intunsigned id
    }
    aa_ranks ||--o{ aa_ability : "One-to-One"
    aa_ranks ||--o{ aa_rank_effects : "One-to-One"
    aa_ranks ||--o{ aa_rank_prereqs : "One-to-One"
    aa_ranks ||--o{ aa_rank_prereqs : "One-to-One"
    aa_ranks ||--o{ character_alternate_abilities : "Has-Many"

Relationship Type	Local Key	Relates to Table	Foreign Key
One-to-One	id	aa_ability	first_rank_id
One-to-One	id	aa_rank_effects	rank_id
One-to-One	id	aa_rank_prereqs	aa_id
One-to-One	id	aa_rank_prereqs	rank_id
Has-Many	id	character_alternate_abilities	aa_id

Schema

Column	Data Type	Description
id	int	AA Identifier
upper_hotkey_sid	int	Upper Hotkey SID
lower_hotkey_sid	int	Lower Hotkey SID
title_sid	int	Title SID
desc_sid	int	Description SID
cost	int	Cost in AA Points
level_req	int	Level Required
spell	int	Spell Identifier
spell_type	int	Spell Type
recast_time	int	Recast Timer
expansion	int	Expansion Identifier
prev_id	int	Previous Rank Identifier
next_id	int	Next Rank Identifier