0010_trade_product_location.up.sql (269B)
1 CREATE TABLE IF NOT EXISTS trade_product_location ( 2 tb_tp CHAR(36), 3 tb_gl CHAR(36), 4 FOREIGN KEY (tb_tp) REFERENCES trade_product(id) ON DELETE CASCADE, 5 FOREIGN KEY (tb_gl) REFERENCES gcs_location(id) ON DELETE CASCADE, 6 PRIMARY KEY (tb_tp, tb_gl) 7 );