NewsFeed

Tables (7)

Comment (Untitled6)

  • comment_id (댓글아이디) — Long — Primary key — NOT NULL
  • post_id (게시물아이디) — Long — Foreign key → Post.post_id — NOT NULL
  • email (유저이메일) — VarChar(50) — Foreign key → Users.email — NOT NULL
  • contents (댓글내용) — VarChar(200)
  • createdAt (생성날짜) — Datetime
  • updatedAt (수정날짜) — Datetime
  • comment_like_count (댓글좋아요갯수) — Long
  • deleted (삭제여부) — boolean

Friends (Untitled4)

  • friends_id (친구리스트아이디) — Long — Primary key — NOT NULL
  • email (유저와친구인유저의이메일) — Long — Foreign key → Users.email — NOT NULL

Post (Untitled2)

  • post_id (게시물아이디) — Long — Primary key — NOT NULL
  • email (유저이메일) — Long — Foreign key → Users.email — NOT NULL
  • title (게시물제목) — VarChar(100)
  • contents (게시물내용) — VarChar(500)
  • createdAt (게시물작성시각) — Datetime
  • updatedAt (게시물수정시각) — Datetime
  • comment_count (댓글갯수) — Long
  • post_like_count (게시물좋아요갯수) — Long
  • deleted (삭제여부) — boolean

Post_like (Untitled3)

  • Post_like_id (게시물좋아요아이디) — Long — Primary key — NOT NULL
  • post_id (게시물아이디) — Long — Foreign key → Post.post_id — NOT NULL
  • email (유저이메일) — Long — Foreign key → Users.email — NOT NULL

Users (Untitled)

  • email (유저이메일) — Long — Primary key — NOT NULL
  • name (유저이름) — Varchar(50)
  • password (유저비밀번호) — Varchar(200)
  • deleted (삭제여부) — boolean
  • freind_count (친구수) — Long
  • status_message (유저상태메시지) — VarChar(50)

comment_like (Untitled7)

  • comment_like_id (댓글좋아요아이디) — Long — Primary key — NOT NULL
  • comment_id (댓글아이디) — Long — Foreign key → Comment.comment_id — NOT NULL
  • email (유저이메일) — Long — Foreign key → Users.email — NOT NULL

friends_request (Untitled5)

  • friends_request_id (친구요청아이디) — Long — Primary key — NOT NULL
  • send_email (친구신청을보낸사람) — Long — Foreign key — NOT NULL
  • friend_state (친구요청상태) — boolean