Untitled

 avatar
unknown
plain_text
a month ago
352 B
3
Indexable
CREATE TABLE `products_variants` (
    id INT AUTO_INCREMENT PRIMARY KEY,
    product_id INT NOT NULL,
    size VARCHAR(255) NOT NULL,
    color VARCHAR(255) NOT NULL,
    quantity INT NOT NULL,
    price INT NOT NULL,
    sku VARCHAR(255) NOT NULL,
    FOREIGN KEY (product_id) REFERENCES products(id) ON DELETE CASCADE ON UPDATE CASCADE
);
Editor is loading...
Leave a Comment