Instagram
Tables (6)
Follow
- Key (follow_id) — int — Primary key — NOT NULL
- Key (user_id) — int — Foreign key → User.Key — NOT NULL
- Field (follower_id) — int — NOT NULL
- Field2 (following_id) — int — NOT NULL
Untitled (Post)
- Key (post_id) — int — Primary key — NOT NULL
- Key (user_id) — int — Foreign key → User.Key — NOT NULL
- Field (content) — text
- Field (hashtag) — text
- Field2 (like_count) — int
- Field3 (created_date) — timestamp — NOT NULL
- Field4 (modified_date) — timestamp — NOT NULL
Untitled (Comment)
- Key (comment_id) — int — Primary key — NOT NULL
- Key (post_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field3 (content) — text
- Field2 (like) — int
- Field (created_date) — timestamp — NOT NULL
- Field2 (modified_date) — timestamp — NOT NULL
Untitled (Story)
- Key (story_id) — int — Primary key — NOT NULL
- Key (user_id) — int — Foreign key → User.Key — NOT NULL
- Field (view_count) — int
- Field (created_date) — timestamp — NOT NULL
Untitled (Image)
- Key (image_id) — int — Primary key — NOT NULL
- Key (post_id) — int — Foreign key → Untitled.Key — NOT NULL
- Key (user_id) — int — Foreign key → Untitled.Key — NOT NULL
- Field (image_url) — text — NOT NULL
User
- Key (user_id) — int — Primary key — NOT NULL
- Field (email) — varchar(45) — NOT NULL
- Field2 (nickname) — varchar(45) — NOT NULL
- Field3 (password) — varchar(45) — NOT NULL
- Field (created_date) — timestamp — NOT NULL
- Field2 (modified_date) — timestamp — NOT NULL