update normalized models

1 files changed, 24 insertions, 0 deletions

diff --git a/db/normalized/bank_accounts.js b/db/normalized/bank_accounts.js
new file mode 100644
index 00000000..3877ffd3
--- /dev/null
+++ b/db/normalized/bank_accounts.js
@@ -0,0 +1,24 @@
+exports.up = function(knex) {
+  return knex.schema.createTable('bank_accounts', function(t) {
+    t.increments('id').unsigned().primary();
+    t.int('user_id').notNull();
+    t.foreign('user_id').references('users.id');
+
+    t.int('transit_number');
+    t.int('institution_number');
+    t.int('account_number');
+
+    t.string('swift');
+    t.string('iban');
+    
+    t.timestamps();
+  })
+}
+
+exports.down = function(knex) {
+  return knex.schema.dropTable('user_security');
+};
+
+// Changes:
+//
+// bank info -> bank_account records