mini_sns

Tables (6)

comment_likes (댓글 좋아요 매핑 테이블)

  • id (댓글좋아요아이디) — Long — Primary key — NOT NULL
  • user_od (회원아이디) — Long — Foreign key → users.id — NOT NULL
  • comment_id (댓글아이디) — Long — Foreign key → comments.id — NOT NULL

comments (댓글)

  • id (댓글아이디) — Long — Primary key — NOT NULL
  • user_id (회원아이디) — Long — Foreign key → users.id — NOT NULL
  • post_id (게시글아이디) — Long — Foreign key → posts.id — NOT NULL
  • content (댓글내용) — String
  • created_at (작성일시) — LocalDateTime

follows (팔로우 매핑 테이블)

  • id (팔로우아이디) — Long — Primary key — NOT NULL
  • follower_id (팔로워아이디) — Long — Foreign key → users.id — NOT NULL
  • following_id (팔로잉아이디) — Long — Foreign key → users.id — NOT NULL

post_likes (게시글 좋아요 매핑 테이블)

  • id (게시글좋아요아이디) — Long — Primary key — NOT NULL
  • user_id (회원아이디) — Long — Foreign key → users.id — NOT NULL
  • post_id (게시글아이디) — Long — Foreign key → posts.id — NOT NULL

posts (게시글)

  • id (게시글아이디) — Long — Primary key — NOT NULL
  • user_id (회원아이디) — Long — Foreign key → users.id — NOT NULL
  • content (게시글본문) — String
  • created_at (작성일시) — LocalDateTime

users (회원)

  • id (회원아이디) — Long — Primary key — NOT NULL
  • email (이메일) — String
  • password (비밀번호) — String
  • nickname (닉네임) — String
  • created_at (가입일시) — LocalDateTime