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