NewsFeed

Tables (5)

Posts (게시글)

  • id (게시글키) — bigint — Primary key — NOT NULL
  • profile_id (프로필키) — bigint — Foreign key → profiles.id — NOT NULL
  • id (계정키) — bigint — Foreign key → profiles.account_id — NOT NULL
  • content (글내용) — varchar(1500)
  • view_count (기본 0) — int
  • comment_count (0) — int
  • like_count (좋아요수(기본 0)) — int
  • created_at (생성일자) — datetime
  • updated_at (수정일자) — datetime

accounts (Untitled3)

  • id (계정키) — bigint — Primary key — NOT NULL
  • email (이메일) — varchar(255)
  • password (비밀번호) — varchar(80)
  • name (이름) — varchar(80)
  • birthdate (생년월일) — date
  • created_at (생성일자) — datetime
  • updated_at (수정일자) — datetime

comments (Untitled4)

  • id (댓글키) — bigint — Primary key — NOT NULL
  • post_id (게시글키) — bigint — Foreign key → Posts.id — NOT NULL
  • profile_id (프로필키) — bigint — Foreign key → Posts.profile_id — NOT NULL
  • account_id (계정키2) — bigint — Foreign key → profiles.account_id — NOT NULL
  • content (댓글내용) — varchar(600)
  • created_at (생성일자) — datetime
  • updated_at (수정일자) — datetime

post likes (Untitled)

  • Key (좋아요키) — bigint — Primary key — NOT NULL
  • post_id (게시글키) — bigint — Foreign key → Posts.id — NOT NULL
  • id (프로필키) — bigint — Foreign key → profiles.id — NOT NULL
  • id (프로필키2) — bigint — Foreign key → Posts.profile_id — NOT NULL
  • id (계정키) — bigint — Foreign key → profiles.account_id — NOT NULL

profiles (Untitled2)

  • id (프로필키) — bigint — Primary key — NOT NULL
  • account_id (계정키) — bigint — Foreign key → accounts.id — NOT NULL
  • nickname (닉네임) — varchar(25)
  • profileImg (프로필 이미지)
  • bio (자기소개) — varchar(160)
  • friends_count (친구수) — int
  • post_count (게시글 수) — int
  • created_at (생성일자) — datetime
  • updated_at (수정일자) — datetime