the spell id's will correspond to lucy/allla url's. "spellid=xxxx" in url or on lucy probably a label / value listed. will make it easier to select just what you want to see to work with it.
as far as petpower, i'd use existing pets to deduce what you need to know - select for a few known ones and see how it changes per pet level etc. or, even existing pet focus items.
github wiki for database, if there is any info on pet naming stuff or more:
http://wiki.eqemulator.org/p?pets
when i try to load the db schema in wiki, it's 'too large to load' (firefox problem?), so google typically gets me there faster.
anyway, looks like "4" is what you want and it correpsonds to another table.