MegaBox

Tables (8)

actor

  • id — INT
  • name — VARCHAR(50) — NOT NULL
  • birth — DATE
  • grade — BOOLEAN
  • nationality — VARCHAR(50)

customer

  • id — INT
  • name — VARCHAR(50) — NOT NULL
  • phone_number — VARCHAR(20) — NOT NULL
  • birth — DATE
  • point — INT

movie

  • id — INT
  • name — VARCHAR(100) — NOT NULL
  • content — TEXT
  • release_date — DATE
  • audience_rating — VARCHAR(10)
  • running_time — INT
  • actor_id — INT — Foreign key → actor.id

reservation

  • id — INT
  • customer_id — INT — Foreign key → customer.id
  • running_time_id — INT — Foreign key → running_time_table.id
  • seat_id — INT — Foreign key → seat.id
  • payment_amount — INT
  • payment_status — BOOLEAN

running_time_table

  • id — INT
  • movie_id — INT — Foreign key → movie.id
  • theater_id — INT — Foreign key → theater.id
  • screening_time_id — INT — Foreign key → time_slot.id

seat

  • id — INT
  • seat_name — VARCHAR(10) — NOT NULL
  • status — BOOLEAN
  • theater_id — INT — Foreign key → theater.id

theater

  • id — INT
  • theater_name — VARCHAR(50) — NOT NULL
  • branch_name — VARCHAR(50)
  • total_seat_number — INT

time_slot

  • id — INT
  • running_time — VARCHAR(10)