Instargram data modeling

Tables (7)

Comment (댓글)

  • Key (댓글id) — UUID — Primary key — NOT NULL
  • Field (댓글 내용) — VARCHAR(100)
  • Field
  • post_id (게시글id) — UUID — Foreign key → Post.post_id — NOT NULL
  • user_id (사용자id) — UUID — Foreign key → User.user_id — NOT NULL

HashTag (해시태그)

  • hashtag_id (해시태그 id) — int — Primary key — NOT NULL
  • hashtag_name (해시태그이름) — VARCHAR(20)

Image (이미지)

  • image_id (이미지 id) — UUID — Primary key — NOT NULL
  • image_name (이미지 이름) — VARCHAR(100)
  • user_id (사용자id) — UUID — Foreign key → User.user_id — NOT NULL
  • post_id (게시글id) — UUID — Foreign key → Post.post_id — NOT NULL

Post (게시글)

  • post_id (게시글id) — UUID — Primary key — NOT NULL
  • Image (이미지)
  • like (좋아요) — int
  • content (내용) — VARCHAR(100)
  • comment (댓글) — VARCHAR(100)
  • follow (팔로우)
  • user_id (사용자id) — UUID — Foreign key → User.user_id — NOT NULL

PostHashTag (게시물해시태그)

  • post_id (게시글id) — UUID — Foreign key → Post.post_id — NOT NULL
  • hashtag_id (해시태그 id) — int — Foreign key → HashTag.hashtag_id — NOT NULL

User (사용자)

  • user_id (사용자id) — UUID — Primary key — NOT NULL
  • user_name (사용자이름) — VARCHAR(30)
  • user_email (사용자이메일) — VARCHAR(30)
  • user_phone (사용자휴대폰) — VARCHAR(30)

follows (팔로워)

  • follower_id (사용자id2) — UUID — Foreign key → User.user_id — NOT NULL
  • following_id (사용자id) — UUID — Foreign key → User.user_id — NOT NULL