kingkong instagram

Tables (5)

Untitled (comments)

  • Key (comments_id) — BIGINT — Primary key — NOT NULL
  • id (post_id) — BIGINT — Foreign key → posts.id — NOT NULL
  • id (user_id) — BIGINT — Foreign key → posts.id — NOT NULL
  • id (user_id2) — BIGINT — Foreign key → users.id — NOT NULL
  • Field (content) — VARCHAR(100)
  • Field (timestamp) — TIMESTAMP

follower_map

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

likes

  • id (likes_id) — BIGINT — Primary key — NOT NULL
  • id (post_id) — BIGINT — Foreign key → posts.id — NOT NULL
  • id (user_id) — BIGINT — Foreign key → posts.id — NOT NULL
  • id (user_id2) — BIGINT — Foreign key → users.id — NOT NULL
  • timestamp — TIMESTAMP
  • target_type — INTEGER

posts

  • id (post_id) — BIGINT — Primary key — NOT NULL
  • id (user_id) — BIGINT — Foreign key → users.id — NOT NULL
  • timestamp — TIMESTAMP
  • content — VARCHAR(100)

users (user)

  • id (user_id) — BIGINT — Primary key — NOT NULL
  • email — VARCHAR(50)
  • password — VARCHAR(50)
  • name — VARCHAR(50)