EQitems and spells

[Aldest]

I'm curious, how does the EQ items editor handle spells?

Here is my situation.

I used the spell editor to copy an old spell and make a new one.

This spell (and about 25 others at the end of the list that show up in the spell editor) do not appear in my SQL DB.

I went into the DB and manually added the next line (8447). I opened the item editor to put this spell on a weapon as a proc and it wasn't in the list. That list, however, already has a 8447 and continues on well past 10,000.

So I'm a little confused. Could someone perhaps explain the relationships to me and point me on the right path?