One-to-one relationships in Sequelize

We need to associate each post with a user, to fill in the gap that we created in our GraphQL response. A post must have an author. It would not make sense to have a post without an associated user.

First, we will generate a User model and migration. We will use the Sequelize CLI again, as follows:

sequelize model:generate --models-path src/server/models --migrations-path src/server/migrations --name User --attributes avatar:string,username:string

The migration file creates the Users table and adds the avatar and username columns. A data row looks like a post in our fake data, but it also includes an autogenerated ID and two timestamps, as you saw previously.

The relationship of the users to their specific posts is still missing as we have only created the model and migration file. We still have to add the relationship between posts and users. This will be covered in the next section.

What every post needs is an extra field called...