update normalized models

1 files changed, 41 insertions, 0 deletions

diff --git a/db/normalized/transactions.js b/db/normalized/transactions.js
new file mode 100644
index 00000000..7180b8d7
--- /dev/null
+++ b/db/normalized/transactions.js
@@ -0,0 +1,41 @@
+exports.up = function(knex) {
+  return knex.schema.createTable('transactions', function(t) {
+      t.increments('id').unsigned().primary();
+
+      t.enu('type', ['deposit', 'withdrawal', 'transfer', 'exchange', 'invoice', 'voucher', 'new asset'])
+
+      // t.text('notes');
+
+      t.timestamps();
+  })
+};
+
+exports.down = function(knex) {
+return knex.schema.dropTable('transactions');
+};
+
+// Changes: 
+//
+// Deposit = deposit + credit
+// Withdrawal = withdrawal + debit
+// Transfer = credit + debit
+// Exchange = credit + debit + debit + credit
+// Invoice = invoice + debit ?
+// Voucher = invoice + debit ?
+// New Asset = liquid_asset + credit
+
+//
+// context for path, memo, rate, preimage, address, received, fee, tip, confirmed, redeemcode ?
+exports.up = function(knex) {
+  return knex.schema.createTable('transactions', function(t) {
+    t.increments('id').unsigned().primary();
+
+    t.enu('type', ['deposit', 'withdrawal', 'order', 'transfer', 'invoice', 'voucher'])
+
+    t.timestamps();
+  })
+};
+
+exports.down = function(knex) {
+return knex.schema.dropTable('transactions');
+};
\ No newline at end of file