영화 게시판

테이블 (4)

COMMENT_RATING (Untitled2)

  • ID — VARCHAR(20) — 외래 키 → USER.ID — NOT NULL
  • NAME (Key) — VARCHAR(50) — 외래 키 → MOVIE.NAME — NOT NULL
  • RELEASED_DAY (Key2) — VARCHAR(15) — 외래 키 → MOVIE.RELEASED_DAY — NOT NULL
  • COMMENT (comment) — LONGTEXT()
  • RATING (rating) — INT()

MOVIE (Untitled4)

  • NAME (Key) — VARCHAR(50) — 기본 키 — NOT NULL
  • RELEASED_DAY (Key2) — VARCHAR(15) — 기본 키 — NOT NULL
  • GENRE (Field2) — VARCHAR(20)
  • RUNTIME (Field4) — VARCHAR(15)
  • DIRECTOR (Field5) — VARCHAR(30)
  • CAST (Field6) — VARCHAR(50)
  • PLOT (Field7) — LONGTEXT()
  • TOTAL_ATTENDANCE (Field8) — BIGINT()

USER (Untitled)

  • ID — VARCHAR(20) — 기본 키 — NOT NULL
  • PW (pw) — VARCHAR(20)
  • NAME (name) — VARCHAR(10)
  • BIRTHDAY (birthday) — VARCHAR(10)
  • PHONE (phone) — VARCHAR(11)
  • EMAIL (email) — VARCHAR(30)

WISH_LIST (Untitled3)

  • ID — VARCHAR(20) — 외래 키 → USER.ID — NOT NULL
  • NAME (Key) — VARCHAR(50) — 외래 키 → MOVIE.NAME — NOT NULL
  • RELEASED_DAY (Key2) — VARCHAR(15) — 외래 키 → MOVIE.RELEASED_DAY — NOT NULL