가져오기
테이블 (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