1
Tables (12)
BASKET
- BASKET_NO — NUMBER
- BASKET_PRODUCT_NO — NUMBER — NOT NULL
- BASKET_COUNT — NUMBER — NOT NULL
- BASKET_MEMBER_ID — NUMBER — NOT NULL
CARD
- CARD_NO — NUMBER
- CARD_COMPANY_NAME — VARCHAR2(255) — NOT NULL
- CARD_DISCOUNT — NUMBER — NOT NULL
CINEMA
- CINEMA_NO — NUMBER
- CINEMA_RLG — VARCHAR2(255) — NOT NULL
- CINEMA_BLG — VARCHAR2(255) — NOT NULL
- CINEMA_MOVIE_NO — NUMBER — NOT NULL
- CINEMA_SCREEN_DATE — DATE — NOT NULL
MEMBER
- MEMBER_ID — NUMBER — Primary key
- MEMBER_NAME — VARCHAR2(255) — NOT NULL
- MEMBER_PASSWORD — VARCHAR2(255) — NOT NULL
- MEMBER_GENDER — CHAR(1) — NOT NULL
- MEMBER_SOCIAL_SECURITY_NUM — VARCHAR2(13) — NOT NULL
- MEMBER_PHONE — VARCHAR2(13) — NOT NULL
- MEMBER_ADDRESS — VARCHAR2(255) — NOT NULL
- MEMBER_EMAIL — VARCHAR2(255) — NOT NULL
- MEMBER_COUPON — NUMBER
- MEMBER_ADMIN — CHAR(1)
- MEMBER_STAMP — NUMBER
MOVIE
- MOVIE_NO — NUMBER — Primary key
- MOVIE_TITLE — VARCHAR2(255) — NOT NULL
- MOVIE_START_DATE — DATE — NOT NULL
- MOVIE_END_DATE — DATE — NOT NULL
- MOVIE_DIRECTOR — VARCHAR2(255) — NOT NULL
- MOVIE_ACTOR — VARCHAR2(255) — NOT NULL
- MOVIE_GENRE — VARCHAR2(255) — NOT NULL
- MOVIE_AGE_LIMIT — VARCHAR2(50) — NOT NULL
- MOVIE_SHOWTIME — DATE — NOT NULL
- MOVIE_NATIONALITY — VARCHAR2(255) — NOT NULL
- MOVIE_SUMMARY — CLOB — NOT NULL
- MOVIE_IMAGE — VARCHAR2(255) — NOT NULL
- MOVIE_TRAILER — VARCHAR2(255)
PAYMENT
- PAYMENT_NO — NUMBER
- PAYMENT_CARD_NO — NUMBER — NOT NULL
- PAYMENT_TYPE — VARCHAR2(255) — NOT NULL
- PAYMENT_DATE — DATE
- PAYMENT_PRICE — NUMBER — NOT NULL
PAYMENT_PRODUCT
- PAYMENT_PRODUCT_NO — NUMBER
- PAYMENT_PRODUCT_PAYMENT_NO — NUMBER — NOT NULL
- PAYMENT_PRODUCT_BASKET_NO — NUMBER — NOT NULL
PRODUCT
- PRODUCT_NO — NUMBER
- PRODUCT_PRICE — NUMBER — NOT NULL
- PRODUCT_NAME — VARCHAR2(255) — NOT NULL
- PRODUCT_ORIGIN — VARCHAR2(255) — NOT NULL
- PRODUCT_IMAGE — VARCHAR2(255) — NOT NULL
REIVEW
- REIVEW_NO — NUMBER — Primary key
- REIVEW_MEMBER_ID — NUMBER — Foreign key → MEMBER.MEMBER_ID
- REIVEW_MOVIE_NO — NUMBER — Foreign key → MOVIE.MOVIE_NO
- REIVEW_CONTENT — VARCHAR2(255) — NOT NULL
- REIVEW_WRITE_DATE — DATE
- REIVEW_STAR_RATING — NUMBER — NOT NULL
- REIVEW_LIKE_COUNT — NUMBER
SEAT
- SEAT_NO — NUMBER
- SEAT_THEATER_NO — NUMBER — NOT NULL
- SEAT_ROW — NUMBER — NOT NULL
- SEAT_COL — NUMBER — NOT NULL
THEATER
- THEATER_NO — NUMBER
- THEATER_START_TIME — DATE — NOT NULL
- THEATER_END_TIME — DATE — NOT NULL
- THEATER_THEATER_NAME — VARCHAR2(255) — NOT NULL
- THEATER_CINEMA_NO — NUMBER — NOT NULL
TICKET
- TICKET_NO — NUMBER — Primary key
- TICKET_MEMBER_ID — NUMBER — NOT NULL
- TICKET_MOVIE_NO — NUMBER — NOT NULL
- TICKET_SEAT — VARCHAR2(255) — NOT NULL
- TICKET_THEATER_NO — NUMBER — NOT NULL
- TICKET_CINEMA_NO — NUMBER — NOT NULL
- TICKET_PAYMENT_NO — NUMBER — NOT NULL
- TICKET_TEEN — NUMBER
- TICKET_ADULT — NUMBER
- TICKET_SENIOR — NUMBER