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