인스타그램 클론
테이블 (14)
Untitled (users)
- Key (user_id) — int — 기본 키 — NOT NULL
- Field (email) — varchar(100) — NOT NULL
- Field (password) — varchar(255) — NOT NULL
- Field (last_active_at) — date — NOT NULL — need to decide which to ref
- Field (created_at) — date — NOT NULL
- Field (updated_at) — date — NOT NULL
Untitled (profile)
- Key (user_id) — int — 외래 키 → Untitled.Key — NOT NULL
- Field (username) — varchar(100) — NOT NULL
- Field (fullname) — varchar(100) — NOT NULL
- Field (image_url) — varchar(255)
- Field (description) — varchar(255)
- Field (gender) — varchar(1)
- Field (website_url) — varchar(500)
Untitled (follow)
- Key (follower_id) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (followee_id) — int — 외래 키 → Untitled.Key — NOT NULL
Untitled (post)
- Key (post_id) — int — 기본 키 — NOT NULL
- Key (user_id) — int — 외래 키 → Untitled.Key — NOT NULL
- Field (content) — varchar(500)
- Field (created_at) — date — NOT NULL
- Field (updated_at) — date — NOT NULL
Untitled (post_like)
- Key (user_id) — int — 외래 키 → Untitled.Key — NOT NULL — comb key
- Key (post_id) — int — 외래 키 → Untitled.Key — NOT NULL — comb key
Untitled (comment)
- Key (comment_id) — int — 기본 키 — NOT NULL
- Key (post_id) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (user_id) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (parent_id) — int — 외래 키 → Untitled.Key
- Field (content) — text — NOT NULL
- Field (depth) — int — NOT NULL — default = 1 (maxLim= 2)
- Field (created_at) — date — NOT NULL
- Field (updated_at) — date — NOT NULL
Untitled (comment_like)
- Key (user_id) — int — 외래 키 → Untitled.Key — NOT NULL — comb key
- Key (comment_id) — int — 외래 키 → Untitled.Key — NOT NULL — comb key
Untitled (user_chatroom)
- Key (user_chatroom_id) — int — 기본 키 — NOT NULL
- Key (user_id) — int — 외래 키 → Untitled.Key — NOT NULL — unique comb w/ chatroom_id
- Key (chatroom_id) — int — 외래 키 → Untitled.Key — NOT NULL — unique comb w/ user_id
Untitled (chatroom)
- Key (chatroom_id) — int — 기본 키 — NOT NULL
- Field (created_at) — date — NOT NULL
- Field (updated_at) — date — NOT NULL
Untitled (photo)
- Key (id) — int — 기본 키 — NOT NULL
- Key (post_id) — int — 외래 키 → Untitled.Key — NOT NULL
- Field (url) — varchar(255) — NOT NULL
Untitled (tag)
- Key (tag_id) — int — 기본 키 — NOT NULL
- Key (tag) — varchar(100) — 기본 키 — NOT NULL — unique
Untitled (message)
- Key (message_id) — int — 기본 키 — NOT NULL
- Key (user_chatroom_id) — int — 외래 키 → Untitled.Key — NOT NULL
- Key (parent_id) — int — 외래 키 → Untitled.Key
- Field (content) — text — NOT NULL
- Field (created_at) — date — NOT NULL
- Field (updated_at) — date — NOT NULL
- Field (depth) — int — NOT NULL — default = 1 (maxLim= 2)
Untitled (message_like)
- Key (message_id) — int — 외래 키 → Untitled.Key — NOT NULL — comb key
- Key (user_id) — int — 외래 키 → Untitled.Key — NOT NULL — comb key
Untitled (tag_post)
- Key (post_id) — int — 외래 키 → Untitled.Key — NOT NULL — comb key
- Key (tag_id) — int — 외래 키 → Untitled.Key — NOT NULL — comb key