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