영화 게시판
테이블 (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