# 數據表 ## 數據字典  字段 說明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='后臺菜單表'; ```