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