가져오기

테이블 (10)

movies

  • movie_id — BIGINT — 기본 키 — NOT NULL
  • title — VARCHAR(255) — NOT NULL
  • duration — INT — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • deleted_at — datetime(6)

payment_cancels

  • payment_cancel_id — bigint — 기본 키 — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • deleted_at — datetime(6)
  • payment_uid — CHAR(13)
  • reason — enum
  • status — enum
  • payment_id — bigint — 외래 키 → payments.payment_id — NOT NULL

payments

  • payment_id — bigint — 기본 키 — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • deleted_at — datetime(6)
  • payment_uid — CHAR(13)
  • status — enum
  • reservation_id — BIGINT — 외래 키 → 예매.reservation_id — NOT NULL

theaters

  • theater_id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • col_size — INTEGER
  • row_size — INTEGER
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • deleted_at — datetime(6)

users

  • user_id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(255) — NOT NULL
  • password — varchar(255) — NOT NULL
  • name — VARCHAR(255) — NOT NULL
  • role — VARCHAR(255) — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • deleted_at — datetime(6)

상영표 (screenings)

  • screening_id — BIGINT — 기본 키 — NOT NULL
  • start_time — datetime(6) — NOT NULL
  • end_time — datetime(6) — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • deleted_at — datetime(6)
  • movie_id — BIGINT — 외래 키 → movies.movie_id — NOT NULL
  • theater_id — BIGINT — 외래 키 → theaters.theater_id — NOT NULL

상영표_좌석 (screening_seats)

  • screening_seat_id — bigint — 기본 키 — NOT NULL
  • price — integer
  • status — enum('AVAILABLE', 'RESERVED')
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • deleted_at — datetime(6)
  • screening_id — BIGINT — 외래 키 → 상영표.screening_id — NOT NULL
  • seat_id (seat_id2) — BIGINT — 외래 키 → 좌석.seat_id — NOT NULL

예매 (reservations)

  • reservation_id — BIGINT — 기본 키 — NOT NULL
  • status — enum('PENDING','CONFIRMED','CANCELED','COMPLETED') — NOT NULL
  • total_amount — INTEGER
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • deleted_at — datetime(6)
  • screening_id — BIGINT — 외래 키 → 상영표.screening_id — NOT NULL
  • user_id — BIGINT — 외래 키 → users.user_id — NOT NULL

예매좌석 (reservation_seats)

  • reservation_seat_id — BIGINT — 기본 키 — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • deleted_at — datetime(6)
  • screening_seat_id — bigint — 외래 키 → 상영표_좌석.screening_seat_id — NOT NULL
  • reservation_id — BIGINT — 외래 키 → 예매.reservation_id — NOT NULL

좌석 (seats)

  • seat_id — BIGINT — 기본 키 — NOT NULL
  • row_num — INT — NOT NULL
  • col_num — INT — NOT NULL
  • created_at — datetime(6)
  • updated_at — datetime(6)
  • deleted_at — datetime(6)
  • theater_id — BIGINT — 외래 키 → theaters.theater_id — NOT NULL