영화관
테이블 (9)
고객 (Customer)
- customer_id (Key) — INT — 기본 키 — NOT NULL
- name (Field) — VARCHAR(50) — NOT NULL
- phone_number (Field2) — VARCHAR(20) — NOT NULL
담당자 (Employee)
- employee_id (Key) — INT — 기본 키 — NOT NULL
- name (Field) — VARCHAR(50) — NOT NULL
- rolee (Field2) — VARCHAR(50) — NOT NULL
상영관 (Screen)
- screen_id — INT — 기본 키 — NOT NULL
- theater_id — INT — NOT NULL
- screen_name — VARCHAR(50) — NOT NULL
- employee_id — INT
- theater_id (Key) — INT — 외래 키 → 지점.theater_id — NOT NULL
- employee_id (Key2) — INT — 외래 키 → 담당자.employee_id — NOT NULL
상영시간 (ScreenPeriod)
- screen_period_id (Key) — INT — 기본 키 — NOT NULL
- screen_id (Field) — INT — NOT NULL
- movie_id (Field2) — INT — NOT NULL
- start_time (Field3) — DATETIME — NOT NULL
- end_time (Field4) — DATETIME — NOT NULL
- screen_id — INT — 외래 키 → 상영관.screen_id — NOT NULL
- movie_id (Key2) — INT — 외래 키 → 영화.movie_id — NOT NULL
영화 (Movie)
- movie_id (Key) — INT — 기본 키 — NOT NULL
- title (Field) — VARCHAR(100) — NOT NULL
- start_date (Field2) — DATE — NOT NULL
- end_date (Field3) — DATE — NOT NULL
예약 (Reservation)
- reservation_id (Key) — INT — 기본 키 — NOT NULL
- screen_period (Field) — INT — NOT NULL
- seat_id (Field2) — ENUM — NOT NULL
- Screen_period_id (Key2) — INT — 외래 키 → 상영시간.screen_period_id — NOT NULL
- seat_id (Key3) — INT — 외래 키 → 좌석.seat_id — NOT NULL
좌석 (Seat)
- seat_id (Key) — INT — 기본 키 — NOT NULL
- screen_id (Field) — INT — NOT NULL
- location (Field2) — VARCHAR(10) — NOT NULL
- seat_type (Field3) — VARCHAR(20 — NOT NULL
- price (Field4) — DECIMAL(10, 2) — NOT NULL
- screen_id — INT — 외래 키 → 상영관.screen_id — NOT NULL
지점 (Theater)
- theater_id (Key) — INT — 기본 키 — NOT NULL
- theater_name (Field) — VARCHAR(200) — NOT NULL
- address (Field2) — VARCHAR(200) — NOT NULL
티켓 (Ticket)
- ticket_id (Key) — VARCHAR(20) — 기본 키 — NOT NULL
- customer_id (Field) — INT — NOT NULL
- Screen_period_id (Field2) — INT — NOT NULL
- seat_id (Field3) — INT — NOT NULL
- purchase_time (Field4) — DATETIME — NOT NULL
- customer_id (Key2) — INT — 외래 키 → 고객.customer_id — NOT NULL
- Screen_period_id (Key3) — INT — 외래 키 → 상영시간.screen_period_id — NOT NULL
- seat_id (Key4) — INT — 외래 키 → 좌석.seat_id — NOT NULL