Look in the ps_product_carrier table.
There you have all the carriers assigned to the products.
id_carrier_reference = id_carrier
Edit History
Look in the ps_product_carrier table.
There you have all the carriers assigned to the products.
id_carrier_refrence = id_carrier