DataBase
Tables (6)
Employee
- id (employee_id) — NUMBER — Primary key — NOT NULL
- name — VARCHAR2(50) — NOT NULL
- contact — VARCHAR2(20)
Movie
- id (movie_id) — NUMBER — Primary key — NOT NULL
- title — VARCHAR2(100) — NOT NULL
- start_date — DATE — NOT NULL
- end_date — DATE — NOT NULL
Screen
- id (screen_id) — NUMBER — Primary key — NOT NULL
- name — VARCHAR2(50) — NOT NULL
- employee_id — NUMBER — Foreign key → Employee.id — NOT NULL
ScreenPeriod
- id (screen_period_id) — NUMBER — Primary key — NOT NULL
- start_time — DATE — NOT NULL
- end_time — DATE — NOT NULL
- movie_id — NUMBER — Foreign key → Movie.id — NOT NULL
- screen_id — NUMBER — Foreign key → Screen.id — NOT NULL
Seat
- id (seat_id) — NUMBER — Primary key — NOT NULL
- location — VARCHAR2(10) — NOT NULL
- type — VARCHAR2(20)
- price — NUMBER — NOT NULL
- screen_id — NUMBER — Foreign key → Screen.id — NOT NULL
Ticket
- id (ticket_id) — NUMBER — Primary key — NOT NULL
- id — NUMBER
- phone — VARCHAR2(20) — NOT NULL
- reservation_time — DATE
- seat_id — NUMBER — Foreign key → Seat.id — NOT NULL
- screen_period_id — NUMBER — Foreign key → ScreenPeriod.id — NOT NULL