movie

테이블 (6)

극장 (theater)

  • Key (theater_id) — BIGINT — 기본 키 — NOT NULL
  • Field (theater_name) — STRING
  • Field (created_at) — TIMESTAMP — NOT NULL
  • Field (updated_at) — TIMESTAMP — NOT NULL
  • Field (created_author) — BIGINT
  • Field (updated_author) — BIGINT

사용자 (member)

  • Key (member_id) — BIGINT — 기본 키 — NOT NULL
  • Field (member_name) — STRING
  • Field (created_at) — TIMESTAMP — NOT NULL
  • Field (updated_at) — TIMESTAMP — NOT NULL
  • Field (created_author) — BIGINT
  • Field (updated_author) — BIGINT

시간표 (schedule)

  • Key (schedule_id) — BIGINT — 기본 키 — NOT NULL
  • Key (movie_id) — BIGINT — 외래 키 → 영화.Key — NOT NULL
  • Key (theater_id) — BIGINT — 외래 키 → 극장.Key — NOT NULL
  • Field (movie_start_at) — TIMESTAMP
  • Field (screen_open_at) — TIMESTAMP
  • Field2 (screen_close_at) — TIMESTAMP
  • Field (created_at) — TIMESTAMP — NOT NULL
  • Field (updated_at) — TIMESTAMP — NOT NULL
  • Field (created_author) — BIGINT
  • Field (updated_author) — BIGINT

영화 (movie)

  • Key (movie_id) — BIGINT — 기본 키 — NOT NULL
  • Field (movie_name) — STRING
  • Field (movie_grade) — STRING — ENUM
  • Field2 (movie_release_at) — TIMESTAMP
  • Field3 (movie_image_url) — STRING
  • Field4 (running_time_minutes) — BIGINT
  • Field5 (movie_genre) — STRING — ENUM
  • Field (created_at) — TIMESTAMP — NOT NULL
  • Field (updated_at) — TIMESTAMP — NOT NULL
  • Field (created_author) — BIGINT
  • Field (updated_author) — BIGINT

예매 (reservation)

  • Key (reservation_id) — BIGINT — 기본 키 — NOT NULL
  • Key (member_id) — BIGINT — 외래 키 → 사용자.Key — NOT NULL
  • Key (schedule_id) — BIGINT — 외래 키 → 시간표.Key — NOT NULL
  • Key (seat_id) — BIGINT — 외래 키 → 좌석정보.Key — NOT NULL
  • Field (created_at) — TIMESTAMP — NOT NULL
  • Field (updated_at) — TIMESTAMP — NOT NULL
  • Field (created_author) — BIGINT
  • Field (updated_author) — BIGINT

좌석정보 (seat)

  • Key (seat_id) — BIGINT — 기본 키 — NOT NULL
  • Key (theater_id) — BIGINT — 외래 키 → 극장.Key — NOT NULL
  • Field (seat_position) — STRING
  • Field (created_at) — TIMESTAMP — NOT NULL
  • Field (updated_at) — TIMESTAMP — NOT NULL
  • Field (created_author) — BIGINT
  • Field (updated_author) — BIGINT