instagram clone
Tables (6)
Untitled (users)
- Key (user_num) — Double — Primary key — NOT NULL
- Key (follow_num) — Double — Foreign key → Untitled.Key — NOT NULL
- Field (user_id) — String
- Field2 (hashed_pw) — String
Untitled (comments)
- Key (comment_num) — Double — Primary key — NOT NULL
- Key (post_num) — Double — Foreign key → Untitled2.Key — NOT NULL
- Key (user_num) — Double — Foreign key → Untitled.Key — NOT NULL
- Field (user_id) — String
- Field2 (comment_text) — String
- Field (create_time) — Timestamp
- Field2 (update_time) — Timestamp
Untitled (follow_map)
- Key (follow_num) — Double — Primary key — NOT NULL
- Key (user_num) — Double — Foreign key → Untitled.Key — NOT NULL
- Field (target_id) — String
- Field2 (follower_id) — String
Untitled (likes_post)
- Key (like_p_num) — Double — Primary key — NOT NULL
- Key (user_num) — Double — Foreign key → Untitled.Key — NOT NULL
- Key (post_num) — Double — Foreign key → Untitled2.Key — NOT NULL
- Field (user_id) — String
- Field (timestamp) — Timestamp
Untitled (likes_comment)
- Key (like_c_num) — Double — Primary key — NOT NULL
- Key (comment_num) — Double — Foreign key → Untitled.Key — NOT NULL
- Key (user_num) — Double — Foreign key → Untitled.Key — NOT NULL
- Field (user_id) — String
- Field (timestamp) — Timestamp
Untitled2 (posts)
- Key (post_num) — Double — Primary key — NOT NULL
- Key (user_num) — Double — Foreign key → Untitled.Key — NOT NULL
- Field (image) — String
- Field (author) — String
- Field (text) — String
- Field (create_time) — Timestamp
- Field (update_time) — Timestamp