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