Instargram

Tables (8)

Follow (follow)

  • followId (follow_id) — Long — Primary key — NOT NULL
  • memberId (member_id) — Long — Foreign key → Member.memberId — NOT NULL
  • followMemberId (follow_ member_id) — Long — Foreign key → Member.memberId — NOT NULL

Member (member)

  • memberId (member_id) — Long — Primary key — NOT NULL
  • id
  • nickname — Character — NOT NULL
  • password — Character
  • profileImageUrl (profile_image_url) — Character

Post (post)

  • postId (post_id) — Long — Primary key — NOT NULL
  • title — Character
  • content — Character
  • memberId (member_id) — Long — Foreign key → Member.memberId — NOT NULL

PostComment (post_comment)

  • commentId (comment_id) — Long — Primary key — NOT NULL
  • memberId (member_id) — Long — Foreign key → Member.memberId — NOT NULL
  • postId (post_id) — Long — Foreign key → Post.postId — NOT NULL
  • parentCommentId (parent_comment_id) — Long — Foreign key → PostComment.commentId
  • content — Character

PostCommentLike (post_comment_like)

  • commentLikeId (comment_like_id) — Long — Primary key — NOT NULL
  • memberId (member_id) — Long — Foreign key → Member.memberId — NOT NULL
  • commentId (comment_id) — Long — Foreign key → PostComment.commentId — NOT NULL

PostHashTag (post_hash_tag)

  • hashTagId (hash_tag_id) — Long — Primary key — NOT NULL
  • postId (post_id) — Long — Foreign key → Post.postId — NOT NULL
  • hashTag (hash_tag) — Character

PostImage (post_image)

  • postImageId (post_image_id) — Long — Primary key — NOT NULL
  • postId (post_id) — Long — Foreign key → Post.postId — NOT NULL
  • postImageUrl (post_image_url) — Character

PostLike (post_like)

  • likeId (like_id) — Primary key — NOT NULL
  • memberId (member_id) — Long — Foreign key → Member.memberId — NOT NULL
  • postId (post_id) — Long — Foreign key → Post.postId — NOT NULL