좋아요 ERD

테이블 (5)

Comment (Untitled3)

  • comment_id (Key) — Long — 기본 키 — NOT NULL
  • likes (Field) — Integer
  • content (Field2)

Post (Untitled2)

  • post_id (Key) — Long — 기본 키 — NOT NULL
  • content (Field2) — String
  • title (Field3) — String
  • createdAt (Field4) — LocalDateTime
  • modifiedAt (Field5)
  • likes (Field) — Integer

User (Untitled)

  • user_id (Key) — String — 기본 키 — NOT NULL
  • username (Field3) — String
  • introduction (Field4) — String
  • email (Field5) — String
  • post_like_list (Field) — List
  • comment_like_list (Field2) — List

comment_like_table (Untitled5)

  • commentlike (Key3) — Long — 기본 키 — NOT NULL
  • comment_id (Key) — Long — 외래 키 → Comment.comment_id — NOT NULL
  • user_id (Key2) — String — 외래 키 → User.user_id — NOT NULL

post_like_table (Untitled4)

  • postlike (Key3) — Long — 기본 키 — NOT NULL
  • user_id (Key) — String — 외래 키 → User.user_id — NOT NULL
  • post_id (Key2) — Long — 외래 키 → Post.post_id — NOT NULL