ms_user_operation.ts 1.5 KB
/* jshint indent: 2 */

module.exports = function(sequelize:any, DataTypes:any) {
  return sequelize.define('ms_user_operation', {
    uuid: {
      type: DataTypes.STRING(50),
      allowNull: false,
      primaryKey: true
    },
    created_at: {
      type: DataTypes.DATE,
      allowNull: true
    },
    user_id: {
      type: DataTypes.BIGINT,
      allowNull: true
    },
    ip: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    memo: {
      type: DataTypes.STRING(100),
      allowNull: true
    },
    app_id: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    coin: {
      type: DataTypes.INTEGER(11),
      allowNull: true
    },
    updated_at: {
      type: DataTypes.DATE,
      allowNull: true
    },
    type_name: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    type_id: {
      type: DataTypes.INTEGER(11),
      allowNull: true,
      defaultValue: '0'
    },
    user_nick_name: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    user_safe_code: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    money: {
      type: DataTypes.DECIMAL,
      allowNull: false,
      defaultValue: '0'
    },
    balance: {
      type: DataTypes.DECIMAL,
      allowNull: false,
      defaultValue: '0'
    },
    freeze: {
      type: DataTypes.DECIMAL,
      allowNull: false,
      defaultValue: '0'
    },
    user_name: {
      type: DataTypes.STRING(50),
      allowNull: true
    }
  }, {
    tableName: 'ms_user_operation'
  });
};