insta clone
Tables (5)
Untitled (users)
- Key (email) — VARCHAR(50) — Primary key — NOT NULL — 변경불가
- Field (name) — VARCHAR(10) — 특수문자 사용불가
- Field2 (user_id) — VARCHAR(10) — 특수문자 사용가능
- Field3 (password) — VARCHAR(20) — 특수문자 사용가능
- Field (introduce) — VARCHAR(50)
- Field (pf_image) — default: default profile img
Untitled (posts)
- Key (post_id) — objectID — Primary key — NOT NULL — mongodb _id
- Key (email) — VARCHAR(50) — Foreign key → Untitled.Key — NOT NULL — 변경불가
- Field (photo)
- Field2 (location) — VARCHAR(20)
- Field3 (text) — VARCHAR(100)
- Field (post_date) — TIMESTAMP — 최신순 정렬
Untitled (comments)
- Key (comment_id) — objectID — Primary key — NOT NULL — mongodb _id
- Key (post_id) — objectID — Foreign key → Untitled.Key — NOT NULL — mongodb _id
- Key (email) — VARCHAR(50) — Foreign key → Untitled.Key — NOT NULL — 변경불가
- Field (comment) — VARCHAR(50)
- Field (cmt_date) — TIMESTAMP — 최신순 정렬
Untitled (follower_map)
- Key (follow_id) — Primary key — NOT NULL
- Key (email) — VARCHAR(50) — Foreign key → Untitled.Key — NOT NULL — 변경불가
- Field (target_id) — VARCHAR(50) — 변경불가
Untitled (like)
- Key (like_id) — Primary key — NOT NULL
- Key (post_id) — objectID — Foreign key → Untitled.Key — NOT NULL — mongodb _id
- Key (email) — VARCHAR(50) — Foreign key → Untitled.Key — NOT NULL — 변경불가