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