1 files changed, 36 insertions, 0 deletions
diff --git a/src/routers/vault/models/vault/identity.js b/src/routers/vault/models/vault/identity.js
new file mode 100644
index 0000000..e10970f
--- /dev/null
+++ b/src/routers/vault/models/vault/identity.js
@@ -0,0 +1,36 @@
+const Sequelize = require("sequelize"); // from npm registry
+
+module.exports = {
+    fields: {
+        id: {
+            type: Sequelize.INTEGER.UNSIGNED,
+            primaryKey: true,
+            autoIncrement: true,
+            allowNull: false,
+        },
+        userId: {
+            type: Sequelize.INTEGER.UNSIGNED,
+            allowNull: false,
+        },
+        email: {
+            type: Sequelize.STRING(320),
+            allowNull: false,
+        },
+        addedDate: {
+            type: Sequelize.DATE,
+            allowNull: false,
+            defaultValue: Sequelize.NOW,
+        },
+    },
+    options: {
+        indexes: [
+            {
+                fields: ["user_id"],  // BUG: table option {underscored: true} does not work on indexes
+            },
+            {
+                fields: ["email"],
+                unique: true,
+            }
+        ]
+    }
+};