OM-DB

CREATE DATABASE Order_management; USE Order_management; CREATE TABLE Customer ( customer_id INT PRIMARY KEY, name VARCHAR(50), phone VARCHAR(20), ); CREATE TABLE Order ( order_id INT PRIMARY KEY, order_date DATE, customer_id INT, FOREIGN KEY (customer_id) REFERENCES Customer(customer_id) ); CREATE TABLE Product ( product_id INT PRIMARY KEY, product_name VARCHAR(50), price DECIMAL(10,2) ); CREATE TABLE Order_Product ( order_id INT, product_id INT, quantity INT, PRIMARY KEY (order_id, product_id), FOREIGN KEY (order_id) REFERENCES Order(order_id), FOREIGN KEY (product_id) REFERENCES Product(product_id) ); 登录功能核心代码：