웹서버
테이블 (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