How are woocommerce global attributes stored in the database?

I’m working on a website for a client that has over a hundred wood and fabric choices on their site. Adding the attributes and variations product by product was becoming a nightmare, so I opted for a simpler approach. I’m hand coding a pop up window where the visitor can pick their wood and fabric choices from a window that displays the global attributes available. For example, the visitor picks oak, then clicks a field to enter the swatch choice and a window pops up allowing them to pick from some global attributes that have been setup in the shopping cart admin.

I haven’t been able to decode how the attributes are tied together in the database. The ID’s for the attributes (stored in the posts table) don’t seem to correlate with the ID’s in the woocommerce attributes or taxonomy tables. I need to figure out how they’re tied together so I can pull the appropriate swatches based on which wood type the visitor chooses.

Please let me know if you need more clarification on this and thanks in advance for any help!