test

Tables (6)

comments (tag_post_map)

  • Key (id) — BIGINT — Primary key — NOT NULL
  • Field (content) — VARCHAR(100)
  • Field (timestamp) — TIMESTAMP
  • Field2 (post_id) — BIGINT

follower_map

  • (follower_id) — BIGINT — Primary key — NOT NULL
  • (target_id) — BIGINT

likes

  • Key (likes_id) — BIGINT — Primary key — NOT NULL
  • (user_id) — BIGINT — Foreign key → users.user_id — NOT NULL
  • Key (comments_id) — BIGINT — Foreign key → tags.Key — NOT NULL
  • (user_id2) — BIGINT — Foreign key → tags.user_id — NOT NULL
  • Field2 (timestamp) — TIMESTAMP
  • Field3 (target_id) — BIGINT
  • Field4 (target_type) — INTEGER

posts

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

tags (comments)

  • Key (comments_id) — BIGINT — Primary key — NOT NULL
  • (user_id) — BIGINT — Foreign key → users.user_id — NOT NULL
  • Field (name) — VARCHAR

users

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