## 数据字典  | 字段 | 说明 | | --- | --- | | id | | | parent_id | 父菜单id | | type | 菜单类型;1:有界面可访问菜单,2:无界面可访问菜单,0:只作为菜单 | | status | 状态;1:显示,0:不显示 | | list_order | 排序 | | app | 应用名 | | controller | 控制器名 | | action | 操作名称 | | param | 额外参数 | | name | 菜单名称 | | icon | 菜单图标 | | remark | 备注 | ## 数据表 ``` DROP TABLE IF EXISTS `cmf_admin_menu`; CREATE TABLE `cmf_admin_menu` ( `id` int(10) unsigned NOT NULL AUTO_INCREMENT, `parent_id` int(10) unsigned NOT NULL DEFAULT '0' COMMENT '父菜单id', `type` tinyint(3) unsigned NOT NULL DEFAULT '1' COMMENT '菜单类型;1:有界面可访问菜单,2:无界面可访问菜单,0:只作为菜单', `status` tinyint(3) unsigned NOT NULL DEFAULT '0' COMMENT '状态;1:显示,0:不显示', `list_order` float NOT NULL DEFAULT '10000' COMMENT '排序', `app` varchar(15) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '应用名', `controller` varchar(30) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '控制器名', `action` varchar(30) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '操作名称', `param` varchar(50) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '额外参数', `name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '菜单名称', `icon` varchar(20) CHARACTER SET utf8 NOT NULL DEFAULT '' COMMENT '菜单图标', `remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '' COMMENT '备注', PRIMARY KEY (`id`), KEY `status` (`status`), KEY `parentid` (`parent_id`), KEY `model` (`controller`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='后台菜单表'; ```