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