2team

Tables (4)

Follower (팔로우테이블)

  • id (몽고고유id) — INT — Primary key — NOT NULL
  • Follow_userid (팔로우한사람 id) — Object
  • Following_id (팔로잉한사람id) — Object
  • userid (사용자아이디) — INT

Post (게시글테이블)

  • id (몽고고유아이디) — INT — Primary key — NOT NULL
  • postID (게시글ID) — INT — Primary key — NOT NULL
  • userId (사용자아이디) — VARCHAR
  • ratelist (추천리스트) — Object
  • title (제목) — VARCHAR
  • content (내용) — VARCHAR
  • secret (공개/비공개) — Boolean

User (유저테이블)

  • id (몽고고유아이디) — INT — Primary key — NOT NULL
  • userId (사용자아이디) — VARCHAR — Primary key — NOT NULL
  • nickname (닉네임) — VARCHAR
  • email (이메일) — VARCHAR
  • comment (소개글) — VARCHAR
  • profile (프로필) — VARCHAR

review (리뷰테이블)

  • id (몽고고유아이디) — INT — Primary key — NOT NULL
  • postid (게시글id) — INT
  • review_id (작성자id) — INT
  • content (리뷰내용) — VARCHAR