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

module.exports = function(sequelize:any, DataTypes:any) {
  return sequelize.define('ms_user_charge', {
    id: {
      type: DataTypes.INTEGER(11),
      allowNull: false,
      primaryKey: true,
      autoIncrement: true
    },
    init_time: {
      type: DataTypes.DATE,
      allowNull: true
    },
    user_id: {
      type: DataTypes.INTEGER(11),
      allowNull: false
    },
    user_name: {
      type: DataTypes.STRING(50),
      allowNull: false
    },
    app_id: {
      type: DataTypes.INTEGER(11),
      allowNull: true
    },
    pay_type_code: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    money: {
      type: DataTypes.DECIMAL,
      allowNull: false
    },
    operator_id: {
      type: DataTypes.INTEGER(11),
      allowNull: true
    },
    op_user_name: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    pay_date_time: {
      type: DataTypes.DATE,
      allowNull: true
    },
    for_malities_fees: {
      type: DataTypes.DECIMAL,
      allowNull: true
    },
    is_status: {
      type: DataTypes.INTEGER(11),
      allowNull: true
    },
    trade_no: {
      type: DataTypes.STRING(200),
      allowNull: true
    },
    partner: {
      type: DataTypes.STRING(50),
      allowNull: true
    },
    description: {
      type: DataTypes.STRING(400),
      allowNull: true
    },
    pay_type_id: {
      type: DataTypes.INTEGER(11),
      allowNull: true
    },
    user_type: {
      type: DataTypes.INTEGER(11),
      allowNull: true
    }
  }, {
    tableName: 'ms_user_charge'
  });
};