88 lines
1.7 KiB
JavaScript
88 lines
1.7 KiB
JavaScript
const db = require("../../middleware/db");
|
|
const Sequelize = require("sequelize");
|
|
// 菜单表
|
|
module.exports = sys_menu = db.define("sys_menu", {
|
|
// 菜单名称
|
|
name: {
|
|
type: Sequelize.STRING(100),
|
|
allowNull: false,
|
|
defaultValue: "",
|
|
comment: "菜单名称",
|
|
},
|
|
|
|
// 父id
|
|
parent_id: {
|
|
type: Sequelize.INTEGER(11).UNSIGNED,
|
|
allowNull: true,
|
|
defaultValue: 0,
|
|
comment: "父id",
|
|
},
|
|
|
|
// 图标
|
|
icon: {
|
|
type: Sequelize.STRING(100),
|
|
allowNull: false,
|
|
defaultValue: "",
|
|
comment: "图标",
|
|
},
|
|
path: {
|
|
type: Sequelize.STRING(255),
|
|
allowNull: false,
|
|
defaultValue: "",
|
|
comment: "路径",
|
|
},
|
|
|
|
// 菜单类型 "菜单", "页面", "外链", "功能"
|
|
type: {
|
|
type: Sequelize.STRING(255),
|
|
allowNull: false,
|
|
defaultValue: "页面",
|
|
comment: "菜单类型",
|
|
},
|
|
//模型id
|
|
model_id: {
|
|
type: Sequelize.INTEGER(11).UNSIGNED,
|
|
allowNull: true,
|
|
defaultValue: 0,
|
|
comment: "模型id",
|
|
},
|
|
// 组件地址
|
|
component: {
|
|
type: Sequelize.STRING(100),
|
|
allowNull: false,
|
|
defaultValue: "",
|
|
comment: "组件地址",
|
|
},
|
|
|
|
// api地址
|
|
api_path: {
|
|
type: Sequelize.STRING(100),
|
|
allowNull: false,
|
|
defaultValue: "",
|
|
comment: "api地址",
|
|
},
|
|
// 是否显示在菜单中
|
|
is_show_menu: {
|
|
type: Sequelize.INTEGER(1),
|
|
allowNull: false,
|
|
defaultValue: true,
|
|
comment: "是否显示在菜单中",
|
|
},
|
|
is_show: {
|
|
type: Sequelize.INTEGER(1),
|
|
allowNull: false,
|
|
defaultValue: true,
|
|
comment: "是否展示",
|
|
},
|
|
|
|
// 菜单类型
|
|
sort: {
|
|
type: Sequelize.INTEGER(11),
|
|
allowNull: false,
|
|
defaultValue: "0",
|
|
comment: "菜单类型",
|
|
},
|
|
});
|
|
|
|
// sys_menu.sync({ force: true })
|