주특기 주차

테이블 (3)

Comment

  • Key (comment_id) — bigint — 기본 키 — NOT NULL
  • Field (comment) — varchar — NOT NULL
  • Field2 (createdAt) — LocalDate — NOT NULL
  • Field3 (modifiedAt) — LocalDate — NOT NULL
  • Key (post_id) — 외래 키 → Post.Key — NOT NULL
  • Key (user_id) — 외래 키 → User.Key — NOT NULL

Post

  • Key (post_id) — bigint — 기본 키 — NOT NULL
  • Field (title) — varchar — NOT NULL
  • Field (contents) — varchar — NOT NULL
  • Field2 (category) — varchar — NOT NULL
  • Field (createdAt) — DateTime — NOT NULL
  • Field (modifiedAt) — timeStamp — NOT NULL
  • Key (user_id) — 외래 키 → User.Key — NOT NULL

User

  • Key (user_id) — bigint — 기본 키 — NOT NULL
  • Field (email) — varchar — NOT NULL
  • Field (password) — varchar — NOT NULL
  • Field (nickname) — varchar — NOT NULL