Your task

One new tab, 004_likes_tags_follows.sql. This time you get the requirements, and you choose the tables, columns and types. Match the table names below so later levels line up.

1. Tags. A tag is a short name like sql or beginner. The same name can't exist twice. A post can have many tags and a tag can be on many posts. Tables: tags, post_tags.

2. Likes. A user can like a post once, and Inkwell wants to know when they did. A user likes many posts, and a post is liked by many users. Table: likes. Columns: user_id, post_id, created_at.

3. Follows. A user can follow another user once, and Inkwell wants to know when. Table: follows. Columns: follower_id (the one doing the following), followed_id, created_at.

For every foreign key, decide the ON DELETE rule. Ask: if this post, tag or user disappears, does the link still mean anything?

4. Check your tabs are saved. The workbench writes every tab to data/migrations/sql/ (the header says Saved to …).