gpt

Tables (11)

CRITIC

  • CRITIC_SEQ — NUMBER — Primary key — NOT NULL
  • CRITIC_PERSON — VARCHAR(20)
  • CRITIC_STAR — NUMBER
  • CRITIC_REVIEW — VARCHAR(200)
  • MOVIE_TITLE — VARCHAR(30) — Foreign key → MOVIE.MOVIE_TITLE — NOT NULL
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP

MOVIE

  • MOVIE_TITLE — VARCHAR(30) — Primary key — NOT NULL
  • MOVIE_RANK — NUMBER
  • MOVIE_HREF — VARCHAR(30)
  • MOVIE_IMAGE — VARCHAR(50)
  • MOVIE_RATING — VARCHAR(20)
  • MOVIE_TITLE_ENG — VARCHAR(30)
  • MOVIE_RESERVATIONRATE — VARCHAR(20)
  • MOVIE_HIT_RATE — VARCHAR(20)
  • MOVIE_RELEASE_DATE — DATE
  • MOVIE_DDAY — NUMBER
  • MOVIE_DIRECTOR — VARCHAR(20)
  • MOVIE_RUNNING_TIME — VARCHAR(20)
  • MOVIE_ACTOR — VARCHAR(20)
  • MOVIE_GENRE — VARCHAR(20)
  • MOVIE_STORY — VARCHAR(200)
  • MOVIE_STILL_CUT — VARCHAR(200)
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP

PAYMENT

  • PAYMENT_CODE — VARCHAR(20) — Primary key — NOT NULL
  • PAYMENT_DATE — DATE
  • PAYMENT_TYPE — VARCHAR(20)
  • PAYMENT_AMOUNT — NUMBER
  • USER_EMAIL — VARCHAR(50) — Foreign key → USERS.USER_EMAIL — NOT NULL
  • MOVIE_TITLE — VARCHAR(30) — Foreign key → MOVIE.MOVIE_TITLE — NOT NULL
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP

RESERVATION

  • RESERVATION_ID — VARCHAR(20) — Primary key — NOT NULL
  • RESERVATION_DATE — DATE
  • RESERVATION_THEATER — VARCHAR(20)
  • RESERVATION_SEAT_NO — VARCHAR(30)
  • USER_EMAIL — VARCHAR(50) — Foreign key → USERS.USER_EMAIL — NOT NULL
  • MOVIE_TITLE — VARCHAR(30) — Foreign key → MOVIE.MOVIE_TITLE — NOT NULL
  • PAYMENT_CODE — VARCHAR(20) — Foreign key → PAYMENT.PAYMENT_CODE — NOT NULL
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP

RESERVATION_SEAT

  • SEAT_NO (Field) — Primary key
  • SHOWTIME_ID — NUMBER — Foreign key → SHOWTIME.SHOWTIME_ID — NOT NULL
  • RESERVATION_ID — VARCHAR(20) — Foreign key → RESERVATION.RESERVATION_ID — NOT NULL

REVIEW

  • REVIEW_SEQ — NUMBER — Primary key — NOT NULL
  • REVIEW_CD — DATE
  • REVIEW_CNT — VARCHAR(2000)
  • REVIEW_RATING — NUMBER
  • USER_EMAIL — VARCHAR(50) — Foreign key → USERS.USER_EMAIL — NOT NULL
  • MOVIE_TITLE — VARCHAR(30) — Foreign key → MOVIE.MOVIE_TITLE — NOT NULL
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP

SCREEN

  • SCREEN_ID — NUMBER — Primary key — NOT NULL
  • THEATER_ID — NUMBER — Foreign key → THEATER.THEATER_ID — NOT NULL
  • SCREEN_NAME — VARCHAR(50) — NOT NULL
  • SEATING_CAPACITY — NUMBER
  • CURRENT_SEATING — NUMBER
  • SEATING_PRICE — INT
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP

SHOWTIME

  • SHOWTIME_ID — NUMBER — Primary key — NOT NULL
  • MOVIE_TITLE — VARCHAR(30) — Foreign key → MOVIE.MOVIE_TITLE — NOT NULL
  • SCREEN_ID — NUMBER — Foreign key → SCREEN.SCREEN_ID — NOT NULL
  • SHOWTIME — TIMESTAMP — NOT NULL
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP

THEATER

  • THEATER_ID — NUMBER — Primary key — NOT NULL
  • THEATER_NAME — VARCHAR(50) — NOT NULL
  • THEATER_LOCATION — VARCHAR(100)
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP

USERS

  • USER_EMAIL — VARCHAR(50) — Primary key — NOT NULL
  • USER_PWD — VARCHAR(30)
  • USER_BIRTHDAY — DATE
  • USER_NAME — VARCHAR(30)
  • USER_PHONE — VARCHAR(20)
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP

WISH

  • WISH_SEQ — NUMBER — Primary key — NOT NULL
  • USER_EMAIL — VARCHAR(50) — Foreign key → USERS.USER_EMAIL — NOT NULL
  • MOVIE_TITLE — VARCHAR(30) — Foreign key → MOVIE.MOVIE_TITLE — NOT NULL
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP