웹서버

테이블 (3)

MOVIE (Untitled2)

  • ID (Key) — NOTNULL — 기본 키 — NOT NULL
  • TITLE (Field) — NOTNULL
  • DIRECTOR (Field2) — NOTNULL
  • IMG_URL (Field3) — NOTNULL
  • PRODUCTYear (Field4) — NOTNULL
  • SUMMARY (Field5) — NOTNULL
  • CREATE_TIME (Field6) — NOTNULL
  • MODIFIED_DATE (Field7) — NOTNULL
  • USER_ID (Key2) — NOTNULL — 외래 키 → USER.ID — NOT NULL
  • averagegrade (Field8) — BIGINT

REVIEW (Untitled3)

  • ID (Key) — NOTNULL — 기본 키 — NOT NULL
  • TITLE (Field) — NOTNULL
  • CONTENT (Field2) — NOTNULL
  • GRADE (Field3) — NOTNULL
  • CREATE_DATE (Field4) — NOTNULL
  • MODIFIED_DATE (Field5) — NOTNULL
  • USER_ID (Key2) — NOTNULL — 외래 키 → USER.ID — NOT NULL
  • MOVIE_ID (Key3) — NOTNULL — 외래 키 → MOVIE.ID — NOT NULL

USER (Untitled)

  • ID (Key) — NOTNULL — 기본 키 — NOT NULL
  • USERNAME (Field) — NOTNULL
  • PASSWORD (Field2) — NOTNULL
  • NICKNAME (Field3) — NOTNULL
  • EMAIL (Field4) — NOTNULL
  • CREATE_DATE (Field5) — NOTNULL
  • MODIFIED_DATE (Field6) — NOTNULL