cinema
Tables (7)
Member (회원)
- Id (Key) — Long — Primary key — NOT NULL
- name (이름) — String
- phone_number (전화번호) — String
- email (이메일) — String
Movie (영화)
- ID (Key) — Long — Primary key — NOT NULL
- title (영화제목) — String
- rating (영상물등급) — Enum
- release_date (개봉일) — Timestamp
- thumbnail (썸네일주소) — String
- genre (장르) — Enum
- runtime_minutes (러닝타임) — Integer
Reservation (예매)
- id (Key) — Long — Primary key — NOT NULL
- reserved_at (예매시간) — Timestamp
- member_id (회원) — Long — Foreign key → Member.Id — NOT NULL
- Screening_id (상영) — Long — Foreign key → Screening.Id — NOT NULL
Screening (상영)
- Id (Key) — Long — Primary key — NOT NULL
- start_time (상영 시작 시간) — Timestamp
- end_time (상영 종료 시간) — Timestamp
- movie_id (영화) — Long — Foreign key → Movie.ID — NOT NULL
- theater_Id (상영관) — Long — Foreign key → Theater.Id — NOT NULL
Seat (좌석)
- Id (Long) — Primary key — NOT NULL
- seat_row (행) — String
- seat_col (열) — String
- status (상태) — Enum
- theater_Id (상영관) — Long — Foreign key → Theater.Id — NOT NULL
Theater (상영관)
- Id (Key) — Long — Primary key — NOT NULL
- name (상영관이름)
reservation_seat (예매 좌석)
- Id (Key) — Primary key — NOT NULL
- reservation_id (예매) — Long — Foreign key → Reservation.id — NOT NULL
- seat_Id (좌석) — Long — Foreign key → Seat.Id — NOT NULL