db/migrations/20210625232223_add_invoice_id_to_payments.js


1
2
3
4
5
6
7
8
9
10
11
12
13

exports.up = async function (knex) {
  return knex.schema.table("payments", function(table) {
    table.integer("invoice_id");
    table.foreign("invoice_id").references("invoices.id");
  })
}

exports.down = async function (knex) {
  return knex.schema.table("payments", function(table) {
    table.dropForeign("invoice_id");
    table.dropColumn("invoice_id");
  })
}