ddd
Tables (6)
Client
- C_ID — INT — Primary key — NOT NULL
- C_Name — VARCHAR(50) — NOT NULL
- C_Number — VARCHAR(11) — NOT NULL
- Email — VARCHAR(30) — NOT NULL
- C_Rating — VARCHAR(10) — NOT NULL
Movie
- M_ID — INT — Primary key — NOT NULL
- M_Name — VARCHAR(50) — NOT NULL
- Genre — VARCHAR(10) — NOT NULL
- M_Rating — INT — NOT NULL
- Director (Direct) — VARCHAR(50)
Reservation
- R_ID — INT — Primary key — NOT NULL
- C_ID — INT — Foreign key → Client.C_ID — NOT NULL
- S_ID — INT — Foreign key → Schedule.S_ID — NOT NULL
- StartTime — DATETIME — NOT NULL
- EndTime — DATETIME — NOT NULL
- M_ID — INT — Foreign key → Movie.M_ID — NOT NULL
- M_Name — VARCHAR(50) — NOT NULL
- Th_ID — INT — Foreign key → Theater.Th_ID — NOT NULL
- R_Personnel — INT
- R_Seat — CHAR(3) — NOT NULL
- R_Time — DATETIME — NOT NULL
- R_Pay — DECIMAL(10, 2) — NOT NULL
Sales
- S_ID — INT — Primary key — NOT NULL
- M_ID — INT — Foreign key → Movie.M_ID — NOT NULL
- Personnel — INT
- TotalPay — DECIMAL(10, 2)
Schedule
- S_ID — INT — Primary key — NOT NULL
- StartTime — DATETIME — NOT NULL
- EndTime — DATETIME — NOT NULL
- M_ID — INT — Foreign key → Movie.M_ID — NOT NULL
- M_Name — VARCHAR(50) — NOT NULL
- Th_ID — INT — NOT NULL
Theater
- Th_ID — INT — Primary key — NOT NULL
- Th_Name — VARCHAR(20) — NOT NULL
- Seat — CHAR(3) — NOT NULL
- Seat_Row — CHAR(1) — NOT NULL
- Seat_Column — CHAR(2) — NOT NULL
- ConfirmationOfReservation — BOOLEAN — NOT NULL