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