한걸음씩 erd

테이블 (7)

category (Category)

  • Key (post_id) — 외래 키 → post.Key — NOT NULL
  • Field2 (free_category) — String — NOT NULL
  • Field (info_category) — String — NOT NULL

comment (Comment)

  • Key (comment_id) — 기본 키 — NOT NULL
  • Key (post_id) — 외래 키 → post.Key — NOT NULL
  • id (user_id) — 외래 키 → profile.id — NOT NULL
  • Field2 (body) — String — NOT NULL
  • Field (create_time) — String

post (Post)

  • Key (post_id) — 기본 키 — NOT NULL
  • id (user_id) — 외래 키 → profile.id — NOT NULL
  • Field (title)
  • Field2 (body) — String — NOT NULL
  • Field (create_time) — String — NOT NULL
  • Field (update_time)

post_likes (Post_likes)

  • Key (post_id) — 외래 키 → post.Key — NOT NULL
  • id (user_id) — 외래 키 → profile.id — NOT NULL

profile (Profile)

  • id (user_id) — 외래 키 → user.id — NOT NULL
  • Field (nickname)
  • Field2 (phone_number) — String — NOT NULL
  • Field (email) — String — NOT NULL
  • Field (name) — String

profile_image (Post_image)

  • Key (post_image_id) — 기본 키 — NOT NULL
  • Key (post_id) — 외래 키 → post.Key — NOT NULL
  • Field2 (url) — String — NOT NULL

user (User)

  • id (user_id) — 기본 키 — NOT NULL
  • Field (id)
  • Field (password)
  • Field (kakao_id)
  • Field2 (naver_id)
  • Field3 (role) — enum