mysql1对多宽表创建_MySql - 产品变体表（宽表） - 唯一的NULL

我有一个产品表和一个product_variants表(一对多) .

product_variants表具有以下结构：

CREATE TABLE product_variants (

id int(11) NOT NULL AUTO_INCREMENT,

id_product int(11) NOT NULL,

id_colourSet int(11) DEFAULT NULL,

id_size int(11) DEFAULT NULL,

PRIMARY KEY (id),

UNIQUE KEY UNIQUE (id_product,id_colourSet,id_size),

KEY idx_prod (id_product),

KEY idx_colourSet (id_colourSet),

KEY idx_size (id_size),

CONSTRAINT fk_df_product_variants_id_colurSet FOREIGN KEY (id_colourSet) REFERENCES df_colour_sets (id_colourSet) ON DELETE NO ACTION ON UPDATE NO ACTION,

CONSTRAINT fk_df_product_variants_id_product FOREIGN KEY (id_product) REFERENCES df_products (id) ON DELETE NO ACTION ON UPDATE NO ACTION,

CONSTRAINT fk_df_product_variants_id_size FOREIGN KEY (id_size) REFERENCES df_sizes (id) ON DELETE NO ACTION ON UPDATE NO ACTION

) ENGINE=InnoDB