인스타그램 클론 코딩
테이블 (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