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 — 변경불가