This might help a bit, let me go over an AA:
Code:
select * from aa_ability where name = "Innate Strength"\G;
*************************** 1. row ***************************
id: 1
name: Innate Strength
category: -1
classes: 65535
races: 65535
drakkin_heritage: 127
deities: 131071
status: 0
type: 1
charges: 0
grant_only: 0
first_rank_id: 2
enabled: 1
Here we see the ID of the AA group for Innate Strength is 1. This is what we once called SEQ (for sequence.) This is also the number you use for /alt act if this was an activated AA.
Here we can see the first_rank_id tells us the first AA ID is 2. So lets grab that from aa_rank.
Code:
select * from aa_ranks where id = 2\G;
*************************** 1. row ***************************
id: 2
upper_hotkey_sid: -1
lower_hotkey_sid: -1
title_sid: 2
desc_sid: 2
cost: 1
level_req: 51
spell: -1
spell_type: 0
recast_time: 0
expansion: 3
prev_id: -1
next_id: 3
Here we can see stuff like hotkey SIDs, title SID, cost, level, etc. Here we see prev_id is -1 meaning there is none, and the next_id is 3, so we can do select * from aa_ranks where id = 3 to get that one. Now this doesn't tell us how many abilities the AA have since we can just calculate that.
Code:
select * from aa_rank_effects where rank_id = 2\G;
*************************** 1. row ***************************
rank_id: 2
slot: 1
effect_id: 4
base1: 2
base2: 0
Now Innate Strength doesn't have any prereqs, so let me just grab an example from a random AA
Code:
select * from aa_rank_prereqs where rank_id = 255\G;
*************************** 1. row ***************************
rank_id: 255
aa_id: 309
points: 3
This is the Flurry AA which depends on rank 3 of AA 309, which is the id from aa_ability, which means ...
Code:
select * from aa_ability where id = 309\G;
*************************** 1. row ***************************
id: 309
name: Combat Fury
category: -1
classes: 32769
races: 65535
drakkin_heritage: 127
deities: 131071
status: 0
type: 2
charges: 0
grant_only: 0
first_rank_id: 934
enabled: 1
It depends on rank 3 of Combat Fury :P