-- 电影表(Movies):
-- 电影 ID(MovieID)
-- 电影名称(MovieName)
-- 上映日期(ReleaseDate)
-- 时长(Duration)
-- 导演(Director)
-- 类型(Genre)
CREATE TABLE Movies (
MovieID INT PRIMARY KEY,
MovieName VARCHAR(255) NOT NULL,
ReleaseDate DATE,
Duration INT,
Director VARCHAR(255),
Genre VARCHAR(255)
);
-- 影院表(Cinemas):
-- 影院 ID(CinemaID)
-- 影院名称(CinemaName)
-- 地址(Address)
CREATE TABLE Cinemas (
CinemaID INT PRIMARY KEY,
CinemaName VARCHAR(255) NOT NULL,
Address VARCHAR(255)
);
-- 放映厅表(Auditoriums):
-- 放映厅 ID(AuditoriumID)
-- 放映厅名称(AuditoriumName)
-- 影院 ID(CinemaID)
CREATE TABLE Auditoriums (
AuditoriumID INT PRIMARY KEY,
AuditoriumName VARCHAR(255) NOT NULL,
CinemaID INT,
FOREIGN KEY (CinemaID) REFERENCES Cinemas(CinemaID)
);