MovieReservationSystem
Tables (9)
admin (관리자)
- 관리자id (admin_id) — Primary key — NOT NULL
- Field (admin_name)
customer (고객)
- 고객id (customer_id) — Primary key — NOT NULL
- 티켓id (ticket_id) — Foreign key → ticket.티켓id — NOT NULL
- 휴대전화 (phone_number)
employee (담당자)
- 담당자id (employee_id) — Primary key — NOT NULL
- 담당자이름 (employee_name)
movie (영화)
- 영화id (movie_id) — Primary key — NOT NULL
- 영화제목 (movie_title)
- 영화시작일 (start_date)
- 영화종료일 (end_date)
- 영화 상영시간 (movie_period)
screen (상영관)
- 상영관id (screen_id) — Primary key — NOT NULL
- 영호관id (theater_id2) — Foreign key → theater.영호관id — NOT NULL
- 담당자id (employee_id2) — Foreign key → employee.담당자id — NOT NULL
- 상영관번호 (screen_number)
- 지점id (theater_id)
- 담당자id (employee_id)
screenPeriod (상영시간표)
- 상영시간id (period_id) — Primary key — NOT NULL
- 상영관id (screen_id2) — Foreign key → screen.상영관id — NOT NULL
- 영호관id (theater_id2) — Foreign key → screen.영호관id — NOT NULL
- 티켓id (ticket_id) — Foreign key → ticket.티켓id — NOT NULL
- 담당자id (employee_id2) — Foreign key → screen.담당자id — NOT NULL
- 영화id (movie_id2) — Foreign key → movie.영화id — NOT NULL
- 상영시작시간 (start_time)
- 상영종료시간 (end_time)
- 상영관id (screen_id)
- 영화id (movie_id)
seat (좌석)
- Key — Primary key — NOT NULL
- 상영관id (screen_id2) — Foreign key → screen.상영관id — NOT NULL
- 영호관id (theater_id2) — Foreign key → screen.영호관id — NOT NULL
- 담당자id (employee_id2) — Foreign key → screen.담당자id — NOT NULL
- 좌석번호 (seat_number)
- 좌석종류 (seat_type)
- 좌석가격 (seat_price)
- 상영관id (screen_id)
theater (영화관)
- 영호관id (theater_id) — Primary key — NOT NULL
- 영화관이름 (theater_name)
ticket (표)
- 티켓id (ticket_id) — Primary key — NOT NULL
- 좌석id (seat_id)
- 고객id (customer_id)
- 상영시간id (period_id)