헷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