갠프

테이블 (5)

MEMBER (Untitled3)

  • ID (Key) — varchar2(10) — 기본 키 — NOT NULL
  • password (Field) — varchar2(20)
  • phone_number (Field2) — varchar2(14)
  • age (Field3) — number

MOVIE (Untitled2)

  • movie_code (Key) — varchar2(10) — 기본 키 — NOT NULL
  • movie_name (Field) — varchar2(50)
  • movie_time (Field2) — varchar2(20)
  • movie_director (Field3) — varchar2(20)
  • movie_price (Field5) — number
  • movie_poster (Field4) — varchar2(50)
  • movie_grade (Field6) — varchar2(10)

MOVIE_BOOKING (Untitled6)

  • ticket_num (Key2) — varchar2(30) — 기본 키 — NOT NULL
  • timetble_code (Key4) — varchar2(20) — 외래 키 → TIMETABLE.timetable_code — NOT NULL
  • ID (Key) — varchar2(10) — 외래 키 → MEMBER.ID — NOT NULL
  • seat_code (Field) — varchar2(5)
  • ageComm_pct (Field3) — number
  • final_price (Field2) — number

THEATER (Untitled4)

  • theater_code (Key) — varchar2(10) — 기본 키 — NOT NULL
  • screen_name (Field) — varchar2(10)
  • theater_name (Field3) — varchar2(30)

TIMETABLE (Untitled5)

  • timetable_code (Key4) — varchar2(30) — 기본 키 — NOT NULL
  • theater_code (Key) — varchar2(10) — 외래 키 → THEATER.theater_code — NOT NULL
  • movie_code (Key3) — varchar2(10) — 외래 키 → MOVIE.movie_code — NOT NULL
  • start_time (Field) — varchar2(10)
  • end_time (Field2) — varchar2(10)
  • screening_date (Field3) — date