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