Initial design is complete for the “build your feed”
Next is to insert new tables into the DB, something like
| Field | Purpose |
|---|---|
user_id |
The member |
category_id |
Category being measured |
impressions |
Meaningful appearances |
opens |
Topics opened |
likes |
Topics liked |
replies |
Replies made |
dwell_seconds |
Accumulated reading time |
affinity_score |
Calculated preference |
updated_at |
Last recalculated |
For the first version, only the interests table is required. The behaviour table will be added later once i figure out which route to take.