ms_admin_role.ts 1.1 KB
/* jshint indent: 2 */

module.exports = function(sequelize:any, DataTypes:any) {
    return sequelize.define('ms_admin_role', {
      id: {
        type: DataTypes.INTEGER(11),
        allowNull: false,
        primaryKey: true,
        autoIncrement: true
      },
      created_at: {
        type: DataTypes.DATE,
        allowNull: false
      },
      updated_at: {
        type: DataTypes.DATE,
        allowNull: false
      },
      role_name: {
        type: DataTypes.STRING(20),
        allowNull: false
      },
      role_code: {
        type: DataTypes.STRING(20),
        allowNull: false
      },
      menu_id: {
        type: DataTypes.STRING(50),
        allowNull: true
      },
      description: {
        type: DataTypes.STRING(200),
        allowNull: true
      },
      sort: {
        type: DataTypes.INTEGER(6),
        allowNull: true
      },
      role_status: {
        type: DataTypes.STRING(255),
        allowNull: true,
        defaultValue: '1'
      },
      oper_user_id:{
        type: DataTypes.INTEGER(6),
        allowNull: true,
        defaultValue: 0
      }
    }, {
      tableName: 'ms_admin_role'
    });
  };