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