ms_admin_menu.ts 1.7 KB
/*********************************************************************
# Autor: sandyWqh
# Date: 2020-11-02 17:42:13
# Description: 
# Version: 1.0
# LastEditors: sandyWqh
# LastEditTime: 2020-11-11 09:36:59
**********************************************************************/
/* jshint indent: 2 */

module.exports = function(sequelize:any, DataTypes:any) {
    return sequelize.define('ms_admin_menu', {
      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
      },
      pid: {
        type: DataTypes.INTEGER(11),
        allowNull: true
      },
      menu_name: {
        type: DataTypes.STRING(50),
        allowNull: false
      },
      menu_url: {
        type: DataTypes.STRING(255),
        allowNull: true
      },
      menu_code: {
        type: DataTypes.STRING(50),
        allowNull: true
      },
      menu_status: {
        type: DataTypes.INTEGER(11),
        allowNull: true,
        defaultValue: '1'
      },
      menu_type: {
        type: DataTypes.STRING(20),
        allowNull: true
      },
      description: {
        type: DataTypes.STRING(200),
        allowNull: true
      },
      icon_url: {
        type: DataTypes.STRING(200),
        allowNull: true
      },
      sort: {
        type: DataTypes.INTEGER(11),
        allowNull: true
      },
      oper_user_id:{
        type: DataTypes.INTEGER(6),
        allowNull: true,
        defaultValue: 0
      }
    }, {
      tableName: 'ms_admin_menu'
    });
  };