Skip to content



This page was last generated 2023.07.15

Relationship Diagram(s)

Diagram Edit


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