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)