NewsFeed(Instagram)
Tables (6)
Comment (댓글)
- id (기본키) — Long — Primary key — NOT NULL
- user_id (기본키(user_id)) — Long — Foreign key → User.user_id — NOT NULL
- newsfeed_id (뉴스피드ID) — Long — Foreign key → NewsFeed.user_id — NOT NULL
- text (설명) — Varchar(255)
Follow (팔로우)
- id (기본키) — Long — Primary key — NOT NULL
- to_user_id (팔로우) — Long — Foreign key → User.id — NOT NULL
- from_user_id (팔로잉) — Long — Foreign key → User.user_id — NOT NULL
- created_at (생성시각) — DateTime
LogoutToken (로그아웃토큰)
- id (기본키) — Long — Primary key — NOT NULL
- expiredAt (발급일) — DateTime
NewsFeed (뉴스피드)
- id (기본키) — Long — Primary key — NOT NULL
- user_id (유저ID) — Long — Foreign key → User.id — NOT NULL
- content (내용) — Varchar(255)
Profile (프로필)
- user_id (기본키(user_id)) — Long — Primary key — NOT NULL
- user_id (유저ID(1:1)) — Long — Foreign key → User.id — NOT NULL
- displayName (공개용닉네임) — Varchar(50)
- bio (자기소개) — LONGTEXT
- website (Url저장)
User (사용자)
- id (기본키) — Long — Primary key — NOT NULL
- user_id (기본키(user_id)) — Long — Foreign key → Profile.user_id — NOT NULL
- profile (프로필) — Long — Foreign key → Profile.user_id — NOT NULL
- userName (사용자이름) — Varchar(30)
- email (이메일) — Varchar(255)
- password (비밀번호) — Varchar(100)