db_final
Tables (7)
Member (회원)
- member_id (회원아이디) — VARCHAR2 — Primary key — NOT NULL
- password (비밀번호) — VARCHAR2
- member_name (회원이름) — VARCHAR2
- member_phone (회원연락처) — VARCHAR2
- member_grade (회원등급) — VARCHAR2
Movie (영화)
- movie_id (영화아이디) — NUMBER — Primary key — NOT NULL
- title (영화제목) — VARCHAR2
- genre (영화장르) — VARCHAR2
- duration (상영시간) — NUMBER
Res_Seat (예매좌석)
- res_seat_id (예매좌석아이디) — NUMBER — Primary key — NOT NULL
- status (예매좌석상태) — VARCHAR2
- seat_id (좌석아이디2) — NUMBER — Foreign key → Seat.seat_id — NOT NULL
- schedule_id (상영일정아이디) — NUMBER — Foreign key → Schedule.schedule_id — NOT NULL
- res_id (예매아이디) — NUMBER — Foreign key → Reservation.res_id — NOT NULL
Reservation (예매)
- res_id (예매아이디) — NUMBER — Primary key — NOT NULL
- res_date (예매날짜) — DATE
- price (가격) — NUMBER
- member_id (회원아이디) — VARCHAR2 — Foreign key → Member.member_id — NOT NULL
- schedule_id (상영일정아이디) — NUMBER — Foreign key → Schedule.schedule_id — NOT NULL
Schedule (상영일정)
- schedule_id (상영일정아이디) — NUMBER — Primary key — NOT NULL
- start_time (상영시작시간) — TIESTAMP
- theater_id (상영관아이디) — NUMBER — Foreign key → Theater.theater_id — NOT NULL
- movie_id (영화아이디) — NUMBER — Foreign key → Movie.movie_id — NOT NULL
Seat (좌석)
- seat_id (좌석아이디) — NUMBER — Primary key — NOT NULL
- seat_row (좌석 열) — NUMBER
- seat_column (좌석 행) — NUMBER
- theater_id (상영관아이디) — NUMBER — Foreign key → Theater.theater_id — NOT NULL
Theater (상영관)
- theater_id (상영관아이디) — NUMBER — Primary key — NOT NULL
- theater_name (상영관이름) — VARCHAR2
- theater_seat (상영관좌석) — NUMBER