Theater
Tables (10)
CUSTOMER
- customer_id — INT
- name — VARCHAR(100)
- phone_number — VARCHAR(20) — NOT NULL
EMPLOYEE
- employee_id — INT
- name — VARCHAR(100) — NOT NULL
- phone — VARCHAR(20)
- position — VARCHAR(50)
MOVIE
- movie_id — INT
- title — VARCHAR(200) — NOT NULL
- running_min — INT — NOT NULL
- show_start_date — DATE — NOT NULL
- show_end_date — DATE — NOT NULL
- rating — VARCHAR(10)
SCREEN
- screen_id — INT
- theater_id — INT — NOT NULL
- name — VARCHAR(50) — NOT NULL
- capacity — INT — NOT NULL
- employee_id — INT
SCREENING
- screening_id — INT
- screen_id — INT — NOT NULL
- movie_id — INT — NOT NULL
- start_time — DATETIME — NOT NULL
- end_time — DATETIME — NOT NULL
SEAT
- seat_id — INT
- screen_id — INT — NOT NULL
- row_label — VARCHAR(5) — NOT NULL
- seat_number — INT — NOT NULL
- seat_code — VARCHAR(10) — NOT NULL
- seat_type_id — INT — NOT NULL
SEAT_PRICE
- screen_id — INT — Primary key — NOT NULL
- seat_type_id — INT — Primary key — NOT NULL
- base_price — DECIMAL(10,0) — NOT NULL
SEAT_TYPE
- seat_type_id — INT
- name — VARCHAR(50) — NOT NULL
- description — VARCHAR(200)
THEATER
- theater_id — INT
- name — VARCHAR(100) — NOT NULL
- address — VARCHAR(200)
- phone — VARCHAR(20)
TICKET
- ticket_id — INT
- screening_id — INT — NOT NULL
- seat_id — INT — NOT NULL
- customer_id — INT — NOT NULL
- purchase_time — DATETIME — NOT NULL
- price_paid — DECIMAL(10,0) — NOT NULL
- masked_phone — VARCHAR(30)