3. Likes, tags and follows · Done when

Done when

  • The diagram shows 7 tables: users, posts, comments, tags, post_tags, likes, follows.
  • follows has two lines going to users.
  • Your schema makes it impossible for a user to like the same post twice. Say which line does that.
  • You can answer: why not store tags as a tags text column on posts holding 'sql, beginner'? Think about how you'd find every post tagged sql, or rename a tag.