create table order details (series 4 part 2) #shortsfeed #database

Create Order_Detail Table in MySQL

CREATE TABLE Order_Detail (
id INT(11) AUTO_INCREMENT PRIMARY KEY,
Order_id INT(11) NOT NULL,
Product_id INT NOT NULL,
Qty INT NOT NULL DEFAULT 1,
Unit_Price DECIMAL(12,2) NOT NULL,
Total DECIMAL(14,2) GENERATED ALWAYS AS
(qty * Unit_Price) STORED,
CONSTRAINT fk_detail_order
FOREIGN KEY (order_id)
REFERENCES order(id)
ON DELETE CASCADE,
CONSTRAINT fk_detail_product
FOREIGN KEY (product_id)
REFERENCES product(product_id)
ON DELETE RESTRICT
);

#shorts #shortvideo #mysql #database

Видео create table order details (series 4 part 2) #shortsfeed #database канала Saifi Ahmada