餐厅订座系统数据库

-- 创建顾客表
CREATE TABLE Customers (
    CustomerID INT PRIMARY KEY AUTO_INCREMENT,
    Name VARCHAR(100),
    Phone VARCHAR(20),
    Address VARCHAR(255)
);

-- 创建餐厅表
CREATE TABLE Restaurants (
    RestaurantID INT PRIMARY KEY AUTO_INCREMENT,
    Name VARCHAR(100),
    Address VARCHAR(255),
    OperatingHours VARCHAR(50)
);

-- 创建座位表
CREATE TABLE Seats (
    SeatID INT PRIMARY KEY AUTO_INCREMENT,
    RestaurantID INT,
    SeatNumber INT,
    Status ENUM('空闲', '占用'),
    FOREIGN KEY (RestaurantID) REFERENCES Restaurants(RestaurantID)
);

-- 创建预订表
CREATE TABLE Reservations (
    ReservationID INT PRIMARY KEY AUTO_INCREMENT,
    CustomerID INT,
    RestaurantID INT,
    SeatID INT,
    ReservationTime DATETIME,
    NumberOfPeople INT,
    FOREIGN KEY (CustomerID) REFERENCES Customers(CustomerID),
    FOREIGN KEY (RestaurantID) REFERENCES Restaurants(RestaurantID),
    FOREIGN KEY (SeatID) REFERENCES Seats(SeatID)
);