instagram

Tables (6)

comment (Untitled5)

  • 고유번호 (id) — bigint — Primary key — NOT NULL
  • 피드id (feed_id) — bigint — Foreign key → feed.고유id — NOT NULL
  • 작성자id (write_user_id) — bigint
  • 내용 (content) — varchar[]
  • 작성시간 (created_at) — Date
  • 수정시간 (modified_at) — Date

comment_reply (Untitled6)

  • 고유번호 (id) — bigint — Primary key — NOT NULL
  • 고유번호 (comment_id) — bigint — Foreign key → comment.고유번호 — NOT NULL
  • 내용 (content) — varchar[]
  • 작성시간 (created_at) — Date

direct_message (Untitled3)

  • 고유번호 (id) — bigint — Primary key — NOT NULL
  • 보낸사람 (from_user_id) — bigint
  • 받은사람 (to_user_id) — bigint
  • 내용 (content) — varchar
  • 보낸시간 (sent_at) — Date

feed (Untitled4)

  • 고유번호 (id) — bigint — Primary key — NOT NULL
  • 고유id (user_id) — bigint — Foreign key → user.고유id — NOT NULL
  • 이미지url (image) — varchar[]
  • 내용 (content) — varchar[]
  • 작성시간 (created_at) — Date
  • 수정시간 (modified_at) — Date

follow (Untitled2)

  • 팔로우받은사람 (user_to_id) — bigint
  • 팔로우한사람 (user_from_id) — bigint

user (Untitled)

  • 고유id (id) — bigint — Primary key — NOT NULL
  • 유저닉네임 (nickname) — varchar[20]
  • 프로필사진url (profile_image) — varchar[]