like

Tables (3)

Like

  • post_id — BIGINT — Primary key — NOT NULL
  • created_at — DATETIME
  • INDEX — idx_post_id
  • user_id — BIGINT — NOT NULL
  • user_id (user_id2) — BIGINT — Foreign key → User.user_id
  • user_id (user_id3) — BIGINT — Foreign key → Post.user_id — NOT NULL
  • post_id (post_id2) — BIGINT — Foreign key → Post.post_id

Post

  • user_id — BIGINT — Primary key — NOT NULL
  • post_id — BIGINT — Primary key
  • content — TEXT — NOT NULL
  • created_at — DATETIME
  • user_id (user_id2) — BIGINT — Foreign key → User.user_id

User

  • user_id — BIGINT — Primary key
  • username — VARCHAR(50) — NOT NULL
  • created_at — DATETIME