Write task migration

Initialize migration file

npm run migrate create task-table

Write up migration

pgm.createTable('tasks', {
  task_id: {
    type: 'serial',
    primaryKey: true
  },
  user_id: {
    type: 'integer',
    notNull: true,
    references: '"users"',
    onDelete: 'cascade'
  },
  title: {
    type: 'text',
    notNull: true
  },
  completed: {
    type: 'boolean',
    notNull: true,
    default: false
  },
  due_date: {
    type: 'date'
  }
});

Write down migration

pgm.dropTable('tasks');

Run migration

npm run migrate up

Commit

git add .
git commit -m 'Adds tasks table'

Next: Write task model