prediction_template.ts 1.3 KB
/* jshint indent: 2 */

module.exports = function(sequelize:any, DataTypes:any) {
  return sequelize.define('prediction_template', {
    id: {
      type: DataTypes.INTEGER(11),
      allowNull: false,
      primaryKey: true,
      autoIncrement: true
    },
    expert_user_id: {
      type: DataTypes.INTEGER(11),
      allowNull: true
    },
    lottery_id: {
      type: DataTypes.INTEGER(11),
      allowNull: true
    },
    type1: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    type2: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    type3: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    check_data_list: {
      type: DataTypes.JSON,
      allowNull: true
    },
    admin_user_id: {
      type: DataTypes.INTEGER(11),
      allowNull: true
    },
    ejs_body: {
      type: DataTypes.TEXT,
      allowNull: true
    },
    ejs_title: {
      type: DataTypes.TEXT,
      allowNull: true
    },
    ejs_result: {
      type: DataTypes.JSON,
      allowNull: true
    },
    created_at: {
      type: DataTypes.DATE,
      allowNull: true
    },
    update_at: {
      type: DataTypes.DATE,
      allowNull: true
    },
    status: {
      type: DataTypes.STRING(20),
      allowNull: true
    }
  }, {
    tableName: 'prediction_template'
  });
};