clouddueling · June 14, 2014 17:33 · Jun 14, 2014
diff --git a/AccountRole.js b/AccountRole.js
@@ -0,0 +1,18 @@
+module.exports = {
+
+  tableName: 'account_roles',
+
+  attributes: {
+    account_id: 'integer',
+    name: 'string',
+    description: 'text',
+    deleted: 'boolean',
+
+    users: {
+      collection: 'user',
+      via: 'accountRoles',
+      through: 'accountroleuser'
+    }
+  }
+
+};
diff --git a/AccountRoleUser.js b/AccountRoleUser.js
@@ -0,0 +1,37 @@
+module.exports = {
+
+  tableName: 'account_role_user',
+
+  tables: ['users', 'account_roles'],
+
+  junctionTable: true,
+
+  attributes: {
+    id: {
+      primaryKey: true,
+      autoIncrement: true,
+      type: 'integer'
+    },
+
+    users: {
+      columnName: 'user_id',
+      type: 'integer',
+      foreignKey: true,
+      references: 'user',
+      on: 'id',
+      via: 'accountroles',
+      groupBy: 'user'
+    },
+
+    accountRoles: {
+      columnName: 'account_role_id',
+      type: 'integer',
+      foreignKey: true,
+      references: 'accountrole',
+      on: 'id',
+      via: 'users',
+      groupBy: 'accountrole'
+    }
+  }
+
+};
diff --git a/User.js b/User.js
@@ -0,0 +1,26 @@
+module.exports = {
+
+  tableName: 'users',
+
+  attributes: {
+    name: 'string',
+    password: {
+      type: 'string',
+      minLength: 4,
+      required: true
+    },
+    bio: 'string',
+    email: {
+      type: 'email',
+      required: true
+    },
+    cloudinary_public_id: 'string',
+
+    accountRoles: {
+      collection: 'accountRole',
+      via: 'users',
+      through: 'accountroleuser'
+    }
+  }
+
+};