의진

테이블 (4)

MEMBER_DB

  • MEMBER_ID — NUMBER(38) — 기본 키
  • USER_ID — VARCHAR2(20) — NOT NULL
  • USER_PW — VARCHAR2(20) — NOT NULL
  • USER_NAME — VARCHAR2(300) — NOT NULL
  • USER_EMAIL — VARCHAR2(300) — NOT NULL
  • USER_PHONE — VARCHAR2(20) — NOT NULL
  • USER_PIN — VARCHAR2(20) — NOT NULL

MOVIE_DB

  • MOVIE_CODE — NUMBER(38) — 기본 키
  • TITLE — VARCHAR2(300) — NOT NULL
  • GENRE — VARCHAR2 — NOT NULL
  • SCORE — NUMBER — NOT NULL
  • PRIVIEW — VARCHAR(4000) — NOT NULL

RESERVATION_DB

  • ORDER_ID — NUMBER(38) — 기본 키
  • MOVIE_CODE — NUMBER(38)
  • THEATER_CODE — NUMBER(38)
  • RB_DATE — DATE
  • RB_TIME — VARCHAR2(50)
  • SEAT — VARCHAR2(38)
  • THEATER_ID — NUMBER(38) — NOT NULL

THEATER_DB

  • THEATER_CODE — NUMBER(38)
  • THEATER_NAME — VARCHAR2(100) — NOT NULL
  • THEATER_ID — NUMBER(38) — NOT NULL