Carstagram

Tables (6)

Copy Of Users (posts)

  • Key (post_id) — BIGINT — Primary key — NOT NULL
  • Key (user_id) — BIGINT — Foreign key → Users.Key — NOT NULL
  • Field (timestamp) — TIMESTAMP
  • Field2 (content) — VARCHAR(100)

Untitled (postlikes)

  • Key (postlike_id) — BIGINT — Primary key — NOT NULL
  • Key (user_id) — BIGINT — Foreign key → Users.Key — NOT NULL
  • Key (post_id) — BIGINT — Foreign key → Copy Of Users.Key — NOT NULL
  • Field (timestamp) — TIMESTAMP
  • Field2 (target_type) — INTEGER

Untitled (commentlikes)

  • Key (commentlike_id) — BIGINT — Primary key — NOT NULL
  • Key (comment_id) — BIGINT — Foreign key → Untitled3.Key — NOT NULL
  • Key (user_id) — BIGINT — Foreign key → Untitled3.Key — NOT NULL
  • Field (timestamp) — TIMESTAMP
  • Field2 (target_type) — INTEGER

Untitled2 (follower_map)

  • Key (follower_id) — BIGINT — Primary key — NOT NULL
  • Key (user_id) — BIGINT — Foreign key → Users.Key — NOT NULL
  • Field (target_id) — BIGINT

Untitled3 (comments)

  • Key (comment_id) — BIGINT — Primary key — NOT NULL
  • Key (user_id) — BIGINT — Foreign key → Users.Key — NOT NULL
  • Field (content) — VARCHAR(100)
  • Field2 (timestamp) — TIMESTAMP

Users (users)

  • Key (user_id) — BIGINT — Primary key — NOT NULL
  • Field (email) — VARCHAR(50)
  • Field2 (password) — VARCHAR(50)
  • Field3 (name) — VARCHAR(50)