update normalized models

1 files changed, 18 insertions, 0 deletions

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