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