movie_test

Tables (11)

CNMTHEATER

  • CNMTHEATER_ID — NUMBER — Primary key — NOT NULL
  • THEATER_TYPE — VARCHAR2(100)
  • PRICE — NUMBER

GALLERY

  • USER_ID — NUMBER — Primary key — NOT NULL
  • NAME — VARCHAR2(300)
  • PHONE_NUMBER — VARCHAR2(50) — NOT NULL
  • BIRTH_DATE — DATE
  • GENDER — VARCHAR2(100)
  • ROLE_ID — NUMBER — Foreign key → ROLE.ROLE_ID — NOT NULL

GENREINFO

  • GENRE_ID — NUMBER — Primary key — NOT NULL
  • GENRE — VARCHAR2(300)

MOVIEINFO

  • MOVIE_ID — NUMBER — Primary key — NOT NULL
  • TITLE — VARCHAR2(300) — 영화제목
  • DESCRIPTION — VARCHAR2(1000)
  • DIRECTOR — VARCHAR2(300)
  • OPENING_DATE — DATE
  • GENRE_ID — NUMBER — Foreign key → GENREINFO.GENRE_ID — NOT NULL
  • COUNTRY — VARCHAR2(300) — NOT NULL
  • DURATION — NUMBER — NOT NULL
  • AGE_RATING — NUMBER — NOT NULL
  • POSTER — VARCHAR2(1000)

PAY

  • PAY_ID — NUMBER — Primary key — NOT NULL
  • PAYMENT_CODE — VARCHAR2(100)
  • USER_ID — NUMBER — Foreign key → GALLERY.USER_ID — NOT NULL
  • PAYMENT_DATE — DATE
  • AMOUNT — NUMBER

ROLE

  • ROLE_ID — NUMBER — Primary key — NOT NULL
  • ROLE_NAME — VARCHAR2(100)

SCHEDULE

  • SCHEDULE_ID — NUMBER — Primary key — NOT NULL
  • MOVIE_ID — NUMBER — Foreign key → MOVIEINFO.MOVIE_ID — NOT NULL
  • CNMTHEATER_ID — NUMBER — Foreign key → CNMTHEATER.CNMTHEATER_ID — NOT NULL
  • START_TIME — DATE
  • END_TIME — DATE — NOT NULL
  • TOTAL_SEAT — NUMBER — NOT NULL

SEATINFO

  • SEATINFO_ID — NUMBER — Primary key — NOT NULL
  • SEAT_NUMBER — VARCHAR2(100)
  • CNMTHEATER_ID — NUMBER — Foreign key → CNMTHEATER.CNMTHEATER_ID — NOT NULL

TICKETINFO

  • TICKET_ID — NUMBER — Primary key — NOT NULL
  • TICKET_CODE — VARCHAR2(300)
  • SCHEDULE_ID — NUMBER — Foreign key → SCHEDULE.SCHEDULE_ID — NOT NULL
  • USER_ID — NUMBER — Foreign key → GALLERY.USER_ID — NOT NULL
  • ADULT — NUMBER
  • YOUTH — NUMBER
  • RESERVATION_TIME — DATE

TICKETPAY

  • PAY_ID — NUMBER — Foreign key → PAY.PAY_ID — NOT NULL
  • TICKET_ID — NUMBER — Foreign key → TICKETINFO.TICKET_ID — NOT NULL

TICKETSEAT

  • SEATINFO_ID — NUMBER — Foreign key → SEATINFO.SEATINFO_ID — NOT NULL
  • TICKET_ID — NUMBER — Foreign key → TICKETINFO.TICKET_ID — NOT NULL