newsfeed

Tables (4)

comment (댓글)

  • id (댓글 식별자) — NOTNULL — Primary key — NOT NULL
  • id (게시글 식별자) — NOTNULL — Foreign key → post.id — NOT NULL
  • id (프로필 식별자) — NOTNULL — Foreign key → post.id — NOT NULL
  • contents (내용) — NOTNULL
  • created_time (생성 시간) — NOTNULL
  • updated_time (수정시간) — NOTNULL

follwo (팔로우)

  • id (팔로우 식별자) — NOTNULL — Primary key — NOT NULL
  • id (프로필 식별자) — NOTNULL — Foreign key → profile.id — NOT NULL
  • to_user (팔로우) — NULL
  • from_user (팔로잉) — NULL

post (게시글)

  • id (게시글 식별자) — NOTNULL — Primary key — NOT NULL
  • id (프로필 식별자) — NOTNULL — Foreign key → profile.id — NOT NULL
  • contents (내용) — NULL
  • img (이미지) — NOTNULL
  • tag (해시태그) — NULL
  • created_time (생성시간) — NOTNULL
  • updated_time (수정시간) — NOTNULL
  • mention (멘션) — NOTNULL
  • like (좋아요) — NOTNULL

profile (프로필)

  • id (프로필 식별자) — NOTNULL — Primary key — NOT NULL
  • email (이메일) — NOTNULL
  • password (패스워드) — NOTNULL
  • user_id (아이디) — NOTNULL
  • name (이름) — NOTNULL
  • intro (소개) — NULL
  • profileImg (프로필이미지) — NOTNULL
  • birthday (생일) — NOTNULL
  • follow (팔로워) — NOTNULL
  • following (팔로잉) — NOTNULL
  • phone (전화번호) — NOTNULL
  • is_withdrawn (탈퇴여부) — NOTNULL