newsfeedv1

Tables (4)

follower_followee

  • id — bigint — Primary key — NOT NULL
  • follower_id — bigint — Foreign key → user.id — NOT NULL
  • followee_id — bigint — Foreign key → user.id — NOT NULL

news_feed

  • id (Key) — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → user.id — NOT NULL
  • post_id — bigint — Foreign key → post.id — NOT NULL
  • posted_at — datetime

post

  • id — bigint — Primary key — NOT NULL
  • user_id — bigint — Foreign key → user.id — NOT NULL
  • content — text
  • posted_at — datetime

user

  • id — bigint — Primary key — NOT NULL
  • name — varchar