[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