add first draft of normalized schema

1 files changed, 60 insertions, 0 deletions

diff --git a/db/normalized/user_preferences.js b/db/normalized/user_preferences.js
new file mode 100644
index 00000000..9864f4eb
--- /dev/null
+++ b/db/normalized/user_preferences.js
@@ -0,0 +1,60 @@
+const { DataTypes } = require('sequelize');
+
+const attributes = {
+  id: {
+    type: DataTypes.INTEGER(11),
+    primaryKey: true,
+    autoIncrement: true,
+    allowNull: false
+  },
+  user_id: {
+    type: DataTypes.INTEGER(11),
+    references: { model: User, key: 'id' },
+    allowNull: false,
+    comment: "Referral granted to this user (updated when token used)"
+  },
+  username: {
+    type: DataTypes.STRING(255),
+    allowNull: false,
+  },
+  gravitar: {
+    type: DataTypes.STRING(255),
+  },
+  fiat: {
+    type: DataTypes.BOOLEAN,
+    defaultValue: true,
+    allowNull: false,
+    comment: "What is this for ?"
+  },
+  default_crypto_unit: {
+    type: DataTypes.ENUM,
+    values: ['SAT', 'BTC'],
+    defaultValue: 'SAT',
+    allowNull: false
+  },
+  default_currency_code: {
+    type: DataTypes.INTEGER(11),
+    references: { model: Currency, key: 'code' },
+    defaultValue: "CAD",
+    allowNull: false
+  },
+  currencies: {
+    type: DataTypes.JSON,
+    allowNull: false,
+    defaultValue: ["USD"],
+    comment: "List of currency options to show for this user",
+  }
+}
+
+const options = {
+  tableName: "user_preferences",
+  comment: "settings that can be controlled by users themselves",
+  timestamps: true,
+  createdAt: 'created_at',
+  updatedAt: 'updated_at',
+  indexes: [
+    {fields: ['user_id']}
+  ]
+};
+
+db["UserPreference"] = db.define("user_preferences_model", attributes, options);