电影票销售管理系统数据库设计 sql

电影票销售管理系统数据库设计通常会包含多个表来存储不同类型的数据，如影院信息、影片信息、放映时间、座位分配和订单信息等。下面是一个简单的数据库设计示例，使用 SQL 来创建这些表：

1. **影院信息（Theaters）**

CREATE TABLE Theaters (
    theater_id INT PRIMARY KEY,
    theater_name VARCHAR(100),
    location VARCHAR(100),
    capacity INT
);

2. **影片信息（Movies）**

CREATE TABLE Movies (
    movie_id INT PRIMARY KEY,
    title VARCHAR(100),
    release_date DATE,
    director VARCHAR(100)
);

3. **放映信息（Screenings）**

CREATE TABLE Screenings (
    screening_id INT PRIMARY KEY,
    theater_id INT,
    movie_id INT,
    start_time DATETIME,
    FOREIGN KEY (theater_id) REFERENCES Theaters(theater_id),
    FOREIGN KEY (movie_id) REFERENCES Movies(movie_id)
);

4. **座位信息（Seats）**

CREATE TABLE Seats (
    seat_id INT PRIMARY KEY,
    theater_id INT,
    row_number INT,
    column_number INT,
    FOREIGN KEY (theater_id) REFERENCES Theaters(theater_id),
    is_taken BOOLEAN DEFAULT FALSE
);

5. **订单信息（Orders）**

CREATE TABLE Orders (
    order_id INT PRIMARY KEY,
    screening_id INT,
    customer_id INT,
    total_seats INT,
    order_date DATETIME,
    FOREIGN KEY (screening_id) REFERENCES Screenings(screening_id),
    FOREIGN KEY (customer_id) REFERENCES Customers(customer_id)
);

6. **客户信息（Customers）**

CREATE TABLE Customers (
    customer_id INT PRIMARY KEY,
    name VARCHAR(100),
    email VARCHAR(100) UNIQUE
);