Instagram

Tables (12)

Comment (Untitled3)

  • 댓글번호 (comment_id) — Primary key — NOT NULL
  • 사용자아이디 (member_id) — Foreign key → Member.사용자아이디 — NOT NULL
  • Key — Foreign key → Member.Key — NOT NULL
  • Key (Key2) — Foreign key → Member.Key — NOT NULL
  • 팔로잉아이디 (follwer_id) — Foreign key → Member.팔로잉아이디 — NOT NULL
  • 팔로우아이디 (follow_id) — Foreign key → Member.팔로우아이디 — NOT NULL
  • 팔로잉아이디 (follwer_id2) — Foreign key → Member.팔로잉아이디 — NOT NULL
  • 댓글내용 (comment_detail)
  • 댓글작성자 (comment_writer)
  • 댓글작성날짜 (created_at)
  • 댓글수정날짜 (modified_at)

Feed (Untitled9)

  • 피드아이디 (feed_id) — Primary key — NOT NULL
  • 사용자아이디 (member_id) — Foreign key → Member.사용자아이디 — NOT NULL
  • Key — Foreign key → Member.Key — NOT NULL
  • Key (Key2) — Foreign key → Member.Key — NOT NULL
  • 팔로잉아이디 (follwer_id) — Foreign key → Member.팔로잉아이디 — NOT NULL
  • 팔로우아이디 (follow_id) — Foreign key → Member.팔로우아이디 — NOT NULL
  • 팔로잉아이디 (follwer_id2) — Foreign key → Member.팔로잉아이디 — NOT NULL
  • 피드내용 (feed_content)
  • 팔로잉아이디 (following_id)
  • 팔로잉이미지 (following_image)
  • 사용자이미지 (member_image)

Follower (Untitled6)

  • 팔로우아이디 (follow_id) — Primary key — NOT NULL

Following (Untitled8)

  • 팔로잉아이디 (follwer_id) — Primary key — NOT NULL

Hashtag (Untitled4)

  • 해시태그번호 (hashtag_id) — Primary key — NOT NULL
  • 해시태그내용 (hashtag_detail)

Like (Untitled5)

  • 좋아요개수 (like_count) — Primary key — NOT NULL
  • 글번호 (post_id) — Foreign key → Post.글번호 — NOT NULL
  • 사용자아이디 (member_id) — Foreign key → Post.사용자아이디 — NOT NULL
  • Key — Foreign key → Post.Key — NOT NULL
  • Key (Key2) — Foreign key → Post.Key — NOT NULL
  • 팔로잉아이디 (follwer_id) — Foreign key → Post.팔로잉아이디 — NOT NULL
  • 팔로우아이디 (follow_id) — Foreign key → Post.팔로우아이디 — NOT NULL
  • 팔로잉아이디 (follwer_id2) — Foreign key → Post.팔로잉아이디 — NOT NULL
  • 좋아요여부 (populatiy)

Member (Untitled)

  • 사용자아이디 (member_id) — Primary key — NOT NULL
  • Key — Foreign key → Member_Follwer.Key — NOT NULL
  • Key (Key2) — Foreign key → Member_Following.Key — NOT NULL
  • 팔로잉아이디 (follwer_id) — Foreign key — NOT NULL
  • 팔로우아이디 (follow_id) — Foreign key → Member_Follwer.팔로우아이디 — NOT NULL
  • 팔로잉아이디 (follwer_id2) — Foreign key → Member_Following.팔로잉아이디 — NOT NULL
  • 사용자이름 (member_name)
  • 사용자비밀번호 (member_password)
  • 우편번호 (member_zipcode)
  • 메인주소 (member_main_address)
  • 상세주소 (member_detail_address)
  • 이메일 (member_email)
  • 생일 (member_birthday)
  • 팔로워수 (follwer_count)
  • 팔로잉수 (following_count)
  • 사용자이미지 (member_image)

Member_Following (Untitled11)

  • Key — Primary key — NOT NULL
  • 팔로잉아이디 (follwer_id) — Foreign key → Following.팔로잉아이디 — NOT NULL

Member_Follwer (Untitled10)

  • Key — Primary key — NOT NULL
  • 팔로우아이디 (follow_id) — Foreign key → Follower.팔로우아이디 — NOT NULL

Photo (Untitled7)

  • 사진번호 (photo_id) — Primary key — NOT NULL
  • 사용자아이디 (member_id) — Foreign key → Member.사용자아이디 — NOT NULL
  • Key — Foreign key → Member.Key — NOT NULL
  • Key (Key2) — Foreign key → Member.Key — NOT NULL
  • 팔로잉아이디 (follwer_id) — Foreign key → Member.팔로잉아이디 — NOT NULL
  • 팔로우아이디 (follow_id) — Foreign key → Member.팔로우아이디 — NOT NULL
  • 팔로잉아이디 (follwer_id2) — Foreign key → Member.팔로잉아이디 — NOT NULL
  • 사진갯수 (photo_count)

Post (Untitled2)

  • 글번호 (post_id) — Primary key — NOT NULL
  • 사용자아이디 (member_id) — Foreign key → Member.사용자아이디 — NOT NULL
  • Key — Foreign key → Member.Key — NOT NULL
  • Key (Key2) — Foreign key → Member.Key — NOT NULL
  • 팔로잉아이디 (follwer_id) — Foreign key → Member.팔로잉아이디 — NOT NULL
  • 팔로우아이디 (follow_id) — Foreign key → Member.팔로우아이디 — NOT NULL
  • 팔로잉아이디 (follwer_id2) — Foreign key → Member.팔로잉아이디 — NOT NULL
  • 글작성 (post_write)
  • 글수정 (post_modifiy)
  • 글삭제 (post_remove)
  • 글조회 (post_check)
  • 글쓴이 (post_writer)
  • 작성날짜 (created_at)
  • 수정날짜 (modified_at)

Post_Hashtag (Untitled12)

  • Key — Primary key — NOT NULL
  • 글번호 (post_id) — Foreign key → Post.글번호 — NOT NULL
  • 사용자아이디 (member_id) — Foreign key → Post.사용자아이디 — NOT NULL
  • Key (Key2) — Foreign key → Post.Key — NOT NULL
  • Key (Key22) — Foreign key → Post.Key — NOT NULL
  • 팔로잉아이디 (follwer_id) — Foreign key → Post.팔로잉아이디 — NOT NULL
  • 팔로우아이디 (follow_id) — Foreign key → Post.팔로우아이디 — NOT NULL
  • 팔로잉아이디 (follwer_id2) — Foreign key → Post.팔로잉아이디 — NOT NULL
  • 해시태그번호 (hashtag_id) — Foreign key → Hashtag.해시태그번호 — NOT NULL