From 4eacfda951f8275ac4f3a1283368884e53285ed0 Mon Sep 17 00:00:00 2001 From: Ran Guin Date: Wed, 14 Jul 2021 18:00:30 -0700 Subject: update normalized models --- db/normalized/vouchers.js | 18 ++++++++++++++++++ 1 file changed, 18 insertions(+) create mode 100644 db/normalized/vouchers.js (limited to 'db/normalized/vouchers.js') diff --git a/db/normalized/vouchers.js b/db/normalized/vouchers.js new file mode 100644 index 00000000..fa5e12a4 --- /dev/null +++ b/db/normalized/vouchers.js @@ -0,0 +1,18 @@ +exports.up = function(knex) { + return knex.schema.createTable('vouchers', function(t) { + t.increments('id').unsigned().primary(); + + t.int('invoice_id').notNull(); + t.foreign('invoice_id').references('invoices.id'); + + t.string('redemption_code').notNull(); + + t.enu('status', ['pending', 'redeemed', 'cancelled']).notNull(); + + t.timestamps(); + }) +} + +exports.down = function(knex) { + return knex.schema.dropTable('vouchers'); +}; \ No newline at end of file -- cgit v1.2.3