인스타그램 클론 코딩

테이블 (7)

Untitled (User)

  • Key (id) — Int — 기본 키 — NOT NULL
  • Field (username) — Char
  • Field2 (nickname) — Char
  • Field3 (is_professional) — Boolean
  • Field (is_private) — Boolean
  • Field (phone_num) — Char
  • Field (email) — Char
  • Field (password) — Char

Untitled (Post)

  • Key (id) — Int — 기본 키 — NOT NULL
  • Field (author) — Char
  • Field2 (content) — Text
  • Field3 (created_time) — DateTime
  • Field4 (updated_time) — DateTime
  • Key (author_id) — Int — 외래 키 → Untitled.Key — NOT NULL
  • Field (location) — Char
  • Field (comment_available) — Boolean

Untitled (Like)

  • Key (id) — Int — 기본 키 — NOT NULL
  • Key (post_id) — Int — 외래 키 → Untitled.Key — NOT NULL
  • Key (user_id) — Int — 외래 키 → Untitled.Key — NOT NULL

Untitled (Comment)

  • Key (id) — 기본 키 — NOT NULL
  • Field (author) — Char
  • Field2 (content) — Text
  • Field (created_time) — DateTime
  • Field2 (updated_time) — DateTime
  • Key (author_id) — Int — 외래 키 → Untitled.Key — NOT NULL
  • Key (post_id) — Int — 외래 키 → Untitled.Key — NOT NULL

Untitled (File)

  • Key (id) — Int — 기본 키 — NOT NULL
  • Field (file) — File
  • Key (post_id) — Int — 외래 키 → Untitled.Key — NOT NULL

Untitled (Profile)

  • Key (id) — Int — 기본 키 — NOT NULL
  • Field (image) — File
  • Field2 (info) — Text
  • Field3 (website) — Char
  • Field (profile_name) — Char
  • Key (user_id) — Int — 외래 키 → Untitled.Key — NOT NULL
  • Field (gender) — Char
  • Field (birth_date) — Date

Untitled (Follow)

  • Key (id) — Int — 기본 키 — NOT NULL
  • Key (follower) — Int — 외래 키 → Untitled.Key — NOT NULL
  • Key (following) — Int — 외래 키 → Untitled.Key — NOT NULL