Which table holds the link between product & category?

[SteveHiner]

Due to some change I made with my host the AbleCommerce database logins and permissions got all messed up. I was having a heck of a time getting them fixed so I decided to rebuild the database (we're still in development so it wasn't a horribly dangerous decision). I have been migrating the data from the old database (which I saved) to the new database. Most of the tables are pretty obvious except I can't figure out what links a product to a category. I have the categories loaded and the products loaded but all the products are orphans. I thought I'd find a ProductCategory table that would link ProductId with CategoryId but there doesn't seem to be a table that contains that info.

Can anyone help me? Which table links the two?

I've been exploring the database relationships and I just haven't seen a link between products and categories anywhere, not even an indirect link. I must be missing something.

[mazhar]

ac_CatalogNodes is doing the job of linking products to category.

[SteveHiner]

Of course you are right. I had copied the data into that table but it looks like only part of it was copied. I changed how I am migrating the data and now the products show up in the categories like they should.

Thanks for the help!