instaClone__sphinx

Tables (5)

Untitled (comment)

  • Key (user_id) — BIGINT — Foreign key → users.Key — NOT NULL
  • Key (post_id) — BIGINT — Foreign key → Untitled2.Key — NOT NULL
  • Field (comment) — VARCHR(100)
  • Field (timestamp) — TIMESTAMP

Untitled (follow)

    Untitled (likes)

    • Key (user_id) — BIGINT — Foreign key → users.Key — NOT NULL

    Untitled2 (post)

    • Key (post_id) — BIGINT — Primary key — NOT NULL
    • Key (user_id) — BIGINT — Foreign key → users.Key — NOT NULL
    • Field (title) — VARCHR(50)
    • Field (content) — VARCHR(100)

    users (user)

    • Key (user_id) — BIGINT — Primary key — NOT NULL
    • Field (user_email) — VARCHR(50)
    • Field (user_password) — VARCHR(50)
    • Field (user_name) — VARCHR(50)