ERD

Tables (9)

movie

  • movie_id — BIGINT — Primary key — NOT NULL — PK
  • running_time — TIME — NOT NULL
  • director — VARCHAR(20)
  • description — VARCHAR(200)
  • movie_image — VARCHAR(200)
  • movie_name — VARCHAR(100)

reservationinformation

  • reservation_id — BIGINT — Primary key — NOT NULL — PK
  • schedule_id — BIGINT — NOT NULL
  • theater_id — BIGINT — NOT NULL
  • screen_id — BIGINT — NOT NULL
  • movie_id — BIGINT — NOT NULL
  • seat_id — BIGINT — NOT NULL
  • reservation_date — DATETIME — NOT NULL

reviews

  • review_id — BIGINT — Primary key — NOT NULL — PK
  • rating — INT
  • content — TEXT
  • created_at — DATETIME
  • updated_at — DATETIME
  • is_deleted — BOOLEAN
  • deleted_at — DATETIME
  • user_id — BIGINT — NOT NULL

schedule

  • schedule_id — BIGINT — Primary key — NOT NULL
  • start_at — DATETIME — NOT NULL
  • end_at — DATETIME — NOT NULL
  • screen_id — BIGINT — NOT NULL

screen

  • screen_id — BIGINT — Primary key — NOT NULL — PK
  • name — VARCHAR(20) — NOT NULL
  • address — VARCHAR(200)
  • theater_id — BIGINT — NOT NULL

seat

  • seat_id — BIGINT — Primary key — NOT NULL
  • screen_id — BIGINT — NOT NULL
  • seat_name — VARCHAR(20)

theater

  • theater_id — BIGINT — Primary key — NOT NULL — PK
  • name — VARCHAR(200) — NOT NULL
  • location — VARCHAR(200)

tokens

  • token_id — BIGINT — Primary key — NOT NULL — PK
  • token — VARCHAR(255)
  • created_at — DATETIME
  • expired_at — DATETIME
  • is_deleted — BOOLEAN
  • user_id — BIGINT — NOT NULL

user

  • user_id — BIGINT — Primary key — NOT NULL — PK
  • email — VARCHAR(255)
  • password — VARCHAR(255) — NOT NULL
  • nickname — VARCHAR(255) — NOT NULL
  • created_at — DATETIME
  • updated_at — DATETIME
  • is_deleted — BOOLEAN — NOT NULL
  • deleted_at — DATETIME