# 数据表 ## 数据字典  字段 说明id parent\_id 父菜单idtype 菜单类型;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='后台菜单表'; ```