add imported db models

1 files changed, 30 insertions, 0 deletions

diff --git a/models/match_dimension.js b/models/match_dimension.js
new file mode 100644
index 0000000..c6c0c45
--- /dev/null
+++ b/models/match_dimension.js
@@ -0,0 +1,30 @@
+/* jshint indent: 2 */
+
+module.exports = function(sequelize, DataTypes) {
+  return sequelize.define('match_dimension', {
+    id: {
+      type: DataTypes.INTEGER(10).UNSIGNED,
+      allowNull: false,
+      primaryKey: true,
+      autoIncrement: true
+    },
+    match_id: {
+      type: DataTypes.INTEGER(11),
+      allowNull: false
+    },
+    dimension_id: {
+      type: DataTypes.INTEGER(11),
+      allowNull: false
+    },
+    stats_id: {
+      type: DataTypes.INTEGER(11),
+      allowNull: false
+    },
+    computed_on: {
+      type: DataTypes.DATE,
+      allowNull: false
+    }
+  }, {
+    tableName: 'match_dimension'
+  });
+};