Which default table and cell hold the keyword info

Hi there

By lack of a decent bulk updater i intend to do a few sql queries on albums.

However I am unable to find which table and cell store the keyword info.

Any help apreciated

Actually I found this , but what i want does not work

I want to is selct all items in a subalbum and add a keyword to it
The bulkmanage toel does not allow me to
I figured i could do it over sql directly.

However lets say that I have a folder called Aoife, which i do
I can find a cell called gpathcomponent with that value and its id
However in what way is its contents linked to this
(I find only one item the folderitem)not its contents

Am i vbeing clear enough?

However I cant