Is there a page that explains adding fields to the database? Can it be done manually with MyPhpAdmin?

I think I can duplicate all of the stuff on the store side by following exactly what the Recording Artist field does in the Product - Music type.
The Recording Artist field currently works in the same manner I want the new field to work. So all I need is another one like it.

But I don't know where to begin to make the necessary changes to the database.
Any suggestions? Even a point in the right direction would be greatly appreciated. Thank you.