[GDSC] 스프링토이프로젝트
테이블 (3)
COMMENTS (Untitled2)
- commentId (Key) — INT UNSIGNED — 기본 키 — NOT NULL
- postId (Key2) — INT UNSIGNED — 외래 키 → POSTS.postId — NOT NULL
- userId (Key22) — VARCHAR(100) — 외래 키 → POSTS.userId — NOT NULL
- username (Field2) — VARCHAR(100)
- createDate (Field3) — TIMESTAMP
- contents (Field4) — VARCHAR(10000)
- order (Field5) — INT UNSIGNED
POSTS (Untitled)
- postId (Key) — INT UNSIGNED — 기본 키 — NOT NULL
- userId (Key2) — VARCHAR(100) — 외래 키 → USER.userId — NOT NULL
- title (Field) — VARCHAR(400)
- createDate (Field3) — TIMESTAMP
- contents (Field4) — VARCHAR(1000)
USER (Untitled3)
- userId (Key) — INT UNSIGNED — 기본 키 — NOT NULL
- nane (Field) — VARCHAR(100)
- email (Field2) — VARCHAR(400)
- picture (Field3)
- role (Field4) — ENUM