헷2

테이블 (6)

MOVIE

  • MOVIE_TITLE — VARCHAR(30) — 기본 키 — NOT NULL
  • MOVIE_RANK — INT
  • 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 — INT
  • 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) — 기본 키 — NOT NULL
  • PAYMENT_DATE — DATE
  • PAYMENT_TYPE — VARCHAR(20)
  • PAYMENT_AMOUNT — INT
  • USER_EMAIL — VARCHAR(50) — 외래 키 → USER.USER_EMAIL — NOT NULL
  • MOVIE_TITLE — VARCHAR(30) — 외래 키 → MOVIE.MOVIE_TITLE — NOT NULL
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP

RESERVATION

  • RESERVATION_ID — VARCHAR(20) — 기본 키 — NOT NULL
  • RESERVATION_DATE — DATE
  • RESERVATION_THEATER — VARCHAR(20)
  • USER_EMAIL — VARCHAR(50) — 외래 키 → USER.USER_EMAIL — NOT NULL
  • MOVIE_TITLE — VARCHAR(30) — 외래 키 → MOVIE.MOVIE_TITLE — NOT NULL
  • PAYMENT_CODE — VARCHAR(20) — 외래 키 → PAYMENT.PAYMENT_CODE — NOT NULL
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP

RESERVATION_SEAT

  • SEAT_NO — VARCHAR(20) — 기본 키 — NOT NULL
  • RESERVATION_ID — VARCHAR(20) — 외래 키 → RESERVATION.RESERVATION_ID — NOT NULL
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP
  • MOVIE_TITLE — VARCHAR(30) — 외래 키 → MOVIE.MOVIE_TITLE — NOT NULL

USER

  • USER_EMAIL — VARCHAR(50) — 기본 키 — 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 — INT — 기본 키 — NOT NULL
  • USER_EMAIL — VARCHAR(50) — 외래 키 → USER.USER_EMAIL — NOT NULL
  • MOVIE_TITLE — VARCHAR(30) — 외래 키 → MOVIE.MOVIE_TITLE — NOT NULL
  • CREATED_AT — TIMESTAMP
  • UPDATED_AT — TIMESTAMP