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