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