medium · ~8 min
Merchandising is launching a new apparel line and needs the full SKU variant matrix pairing every catalog color with every available size.
colors
sizes
color_name
size_name
Input contract: color_id is the non-null primary key of colors and color_name is non-null and unique. size_id is the non-null primary key of sizes and size_name is non-null and unique. There is no foreign key relationship between colors and sizes.
color_id
size_id