Skip to content



    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


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