网上购物系统的SOL语句

为了创建网上购物系统的数据库表，以下是使用SQL语言创建各个表的标准语句：

### 创建 `客户` 表 (Customer)

CREATE TABLE Customer (
    CustomerID INT PRIMARY KEY AUTO_INCREMENT,
    Name VARCHAR(50) NOT NULL,
    Gender CHAR(1),
    Address VARCHAR(100),
    ZipCode VARCHAR(10),
    Phone VARCHAR(15),
    Email VARCHAR(50),
    Username VARCHAR(50) UNIQUE NOT NULL,
    Password VARCHAR(50) NOT NULL
);

### 创建 `供应商` 表 (Supplier)

CREATE TABLE Supplier (
    SupplierID INT PRIMARY KEY AUTO_INCREMENT,
    Name VARCHAR(50) NOT NULL,
    Description TEXT,
    RegistrationDate DATE,
    Address VARCHAR(100),
    ZipCode VARCHAR(10),
    ContactPhone VARCHAR(15),
    Email VARCHAR(50),
    Username VARCHAR(50) UNIQUE NOT NULL,
    Password VARCHAR(50) NOT NULL
);

### 创建 `商品` 表 (Merchandise)

CREATE TABLE Merchandise (
    MerchandiseID INT PRIMARY KEY AUTO_INCREMENT,
    Name VARCHAR(50) NOT NULL,
    Model VARCHAR(50) NOT NULL,
    Price DECIMAL(10, 2) NOT NULL,
    Stock INT NOT NULL,
    Brand VARCHAR(50),
    Description TEXT,
    SupplierID INT,
    FOREIGN KEY (SupplierID) REFERENCES Supplier(SupplierID)
);

### 创建 `订单` 表 (Order)

CREATE TABLE Orders (
    OrderID INT PRIMARY KEY AUTO_INCREMENT,
    CustomerID INT,
    OrderDate DATE,
    TotalAmount DECIMAL(10, 2),
    FOREIGN KEY (CustomerID) REFERENCES Customer(CustomerID)
);

### 创建 `订单详情` 表 (OrderDetail)

CREATE TABLE OrderDetail (
    OrderDetailID INT PRIMARY KEY AUTO_INCREMENT,
    OrderID INT,
    MerchandiseID INT,
    Quantity INT NOT NULL,
    Subtotal DECIMAL(10, 2) NOT NULL,
    FOREIGN KEY (OrderID) REFERENCES Orders(OrderID),
    FOREIGN KEY (MerchandiseID) REFERENCES Merchandise(MerchandiseID)
);

### 索引
为了提高查询性能，可以在一些常用的列上创建索引：

CREATE INDEX idx_customer_name ON Customer(Name);
CREATE INDEX idx_supplier_name ON Supplier(Name);
CREATE INDEX idx_merchandise_name ON Merchandise(Name);
CREATE INDEX idx_order_date ON Orders(OrderDate);

这些SQL语句将帮助你构建一个基本的网上购物系统的数据库结构。你可以根据具体需求进一步优化和扩展这些表。