THEATER_ERD
Tables (15)
Employee
- employee_id — VARCHAR — Primary key — NOT NULL
- employee_name — VARCHAR
- employee_date — VARCHAR
- theater_id (Key) — VARCHAR — Foreign key → Theater.theater_id — NOT NULL
Manager (manager)
- manager_id — VARCHAR — Primary key — NOT NULL
- theater_id (Key) — VARCHAR — Foreign key → Theater.theater_id — NOT NULL
- manager_name — VARCHAR
- manager_phone — NUMBER
Orders
- tiket_id — VATCHAR — Foreign key → Tiket.tiket_id — NOT NULL
- orders — VARCHAR
ScreenRoom (Untitled)
- room_id — VARCHAR — Primary key — NOT NULL
- theater_id (Key) — VARCHAR — Foreign key → Theater.theater_id — NOT NULL
- employee_id — VARCHAR — Foreign key → Employee.employee_id — NOT NULL
- screen_start — DATE
- screen_end — DATE
Sit (sit)
- tiket_id — VATCHAR — Foreign key → Tiket.tiket_id — NOT NULL
- theater_id — VARCHAR — Foreign key → ScreenRoom.theater_id — NOT NULL
- room_id — VARCHAR
- sit_location — VARCHAR
- sit_type — VARCHAR
- available (availble) — BIT
- amount — NUMBER
Theater
- theater_id (Key) — VARCHAR — Primary key — NOT NULL
- address — VATCHAR
- phone — NUMBER
- owner — VARCHAR
- theater_name — VARCHAR
Tiket (tiket)
- tiket_id — VATCHAR — Primary key — NOT NULL
- theater_id — VARCHAR — Foreign key → Theater.theater_id — NOT NULL
- user_id — VARCHAR — Foreign key → user_info.user_id — NOT NULL
- tiket_time — date
- screen_start (screen_time) — date
- screen_end — date
- movie_name — VARCHAR
- available — BIT
- user_phone — NUMBER
- sit_location — VARCHAR
- sit_type — VARCHAR
movie
- movie_Id (movie_id) — VARCHAR — Primary key — NOT NULL
- theater_id (Key) — VARCHAR — Foreign key → Theater.theater_id — NOT NULL
- movie_name — VARCHAR
- current_screening — BIT
- release_date — DATE
- close_date — DATE
- director — VARCHAR
- screen_grade — NUMBER
movie_introduce
- movie_Id (movie_id) — VARCHAR — Foreign key → movie.movie_Id — NOT NULL
- movie_poster — VARCHAR
- movie_content — VARCHAR
movie_score
- movie_Id (movie_id) — VARCHAR — Foreign key → movie.movie_Id — NOT NULL
- score — NUMBER
movie_screen_schedule
- screen_start — DATE
- screen_end — DATE
- movie_Id (movie_id) — VARCHAR — Foreign key → movie.movie_Id — NOT NULL
- theater_id (Key) — VARCHAR — Foreign key → movie.theater_id — NOT NULL
user
- user_id — VARCHAR — Primary key — NOT NULL
- user_password — VARCHAR
- user_profile — VARVHAR
user_info
- user_id — VARCHAR — Foreign key → user.user_id — NOT NULL
- user_name — VARCHAR
- user_profile — VARCHAR
- point — NUMBER
user_like
- user_id — VARCHAR — Foreign key → user_info.user_id — NOT NULL
- movie_Id (movie_id) — VARCHAR — Foreign key → movie.movie_Id — NOT NULL
user_review
- user_id — VARCHAR — Foreign key → user_info.user_id — NOT NULL
- theater_id (Key) — VARCHAR — Foreign key → movie.theater_id — NOT NULL
- movie_id — VARCHAR — Foreign key → movie.movie_Id — NOT NULL
- review_date — DATE
- review_content — VARCHAR