Which MySQL table 'holds' the Product Links?

Which MySQL table 'holds' the Product Links?

I'm adding thousands of products by importing from my Filemaker database with a program called fmSQL Synch. It's all set up and working fine in my tests and I've even completed a massive attribute database that took almost a week to script and will contain hundreds of thousands of records. I'd like to link some products using the Product Link function in Zen-Cart, but I cannot locate the appropriate MySQL table that stores that info relationship. Does anyone know what table name holds this or 'how' it's stored?

thanks,
Jeff

products_url field in the products_description table ... one record per product per language

Oops.... wrong 'links'

I meant to say: Linked Product (not URL links)

I'd like to import critera to create Linked Products and I cannot find that table in MySQL to import my data to.

thanks,
Jeff

the master id is set as master_categories_id in the products table. This denotes who's boss.

All category-to-product relations ("links" as you call them) are in the many-to-many products_to_categories table.

Yes!! That's it and when I tested it by adding a new product link in the admin, it repopulated the MySQL with the ID repeated twice and a different category number on each of them.

My only other question about this is this: If the master category is already set up in the Products table, does the same data need to be in Products to Categories also...along with the new Product Links? Or can the master links be eliminated in Products to Categories without any 'ill' effects

thanks Jeff

the products_to_categories records are required ... otherwise the master is considered invalid and you'll have mayhem when calculating prices esp for sales