POVI

Tables (5)

Comment (커뮤니티 댓글)

  • comment_id (댓글번호) — Primary key — NOT NULL
  • post_id (작성글번호) — Integer — Foreign key → Post.post_id — NOT NULL
  • conetnt (댓글내용)
  • Field3 (created_at)

Follow (팔로우)

  • follow_id (팔로우번호) — Primary key — NOT NULL
  • to_follow (팔로잉)
  • from_follow (팔로워)

Post (커뮤니티 글)

  • post_id (작성글번호) — Integer — Primary key — NOT NULL
  • writer (작성자)
  • title (제목)
  • content (내용)
  • Field (created_at)

Untitled (Diary)

  • Key (diary_id) — Primary key — NOT NULL
  • Field (date)
  • Field2 (content)
  • Field3 (image)
  • Field (feeling)

User (회원)

  • user_id (유저번호) — Integer — Primary key — NOT NULL
  • nickname (닉네임)
  • password (비밀번호)
  • inroduce (소개글) — TEXT
  • profile_img (프로필이미지) — URL