+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_migo_sys_menu:/tablelist/okayapi_migo_sys_menu.html


-- MySQL Table okayapi_migo_sys_menu
-- From: OkayAPI.com
CREATE TABLE `okayapi_migo_sys_menu` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `menu_id` bigint(20) NULL COMMENT '',
    `parent_id` bigint(20) NULL COMMENT '父菜单ID,一级菜单为0',
    `okayapi_migo_sys_menu_name` varchar(50) NULL COMMENT '菜单名称',
    `url` varchar(200) NULL COMMENT '菜单URL',
    `perms` varchar(500) NULL COMMENT '授权(多个用逗号分隔,如:user:list,user:create)',
    `okayapi_migo_sys_menu_type` int(11) NULL COMMENT '类型   0:目录   1:菜单   2:按钮',
    `icon` varchar(50) NULL COMMENT '菜单图标',
    `order_num` int(11) NULL COMMENT '排序',
    KEY `menu_id` (`menu_id`),
    KEY `parent_id` (`parent_id`),
    KEY `okayapi_migo_sys_menu_name` (`okayapi_migo_sys_menu_name`),
    KEY `url` (`url`),
    KEY `perms` (`perms`),
    KEY `okayapi_migo_sys_menu_type` (`okayapi_migo_sys_menu_type`),
    KEY `icon` (`icon`),
    KEY `order_num` (`order_num`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'migo权限管理-菜单管理';

After replication, you can go to the database to create the database table.


MySQL database table structure design

Displaying 1-8 of 8 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
menu_idbigint(20)
parent_idbigint(20)父菜单ID,一级菜单为0
okayapi_migo_sys_menu_namevarchar(50)菜单名称
urlvarchar(200)菜单URL
permsvarchar(500)授权(多个用逗号分隔,如:user:list,user:create)
okayapi_migo_sys_menu_typeint(11)类型 0:目录 1:菜单 2:按钮
iconvarchar(50)菜单图标
order_numint(11)排序

Guess You Like

MySQL Table Design okayapi_migo_schedule_job

MySQL Table Design okayapi_migo_schedule_job_log

MySQL Table Design okayapi_migo_sys_config

MySQL Table Design okayapi_migo_sys_log

MySQL Table Design okayapi_migo_sys_oss

MySQL Table Design okayapi_migo_sys_role

MySQL Table Design okayapi_migo_sys_role_menu

MySQL Table Design okayapi_migo_sys_user

MySQL Table Design okayapi_migo_sys_user_role

MySQL Table Design okayapi_migo_tb_token

MySQL Table Design okayapi_migo_tb_user

MySQL Table Design okayapi_rights_assign

TOP ↑