+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_qi_ace_sys_menu:/tablelist/okayapi_qi_ace_sys_menu.html


-- MySQL Table okayapi_qi_ace_sys_menu
-- From: OkayAPI.com
CREATE TABLE `okayapi_qi_ace_sys_menu` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `menu_id` int(11) NULL COMMENT '菜单ID',
    `okayapi_qi_ace_sys_menu_name` varchar(32) NULL COMMENT '菜单名称',
    `permission` varchar(32) NULL COMMENT '菜单权限标识',
    `path` varchar(128) NULL COMMENT '前端URL',
    `parent_id` int(11) NULL COMMENT '父菜单ID',
    `icon` varchar(32) NULL COMMENT '图标',
    `component` varchar(64) NULL COMMENT 'VUE页面',
    `sort` int(11) NULL DEFAULT '1' COMMENT '排序值',
    `keep_alive` char(1) NULL DEFAULT '0' COMMENT '0-开启,1- 关闭',
    `okayapi_qi_ace_sys_menu_type` char(1) NULL COMMENT '菜单类型 (0菜单 1按钮)',
    `create_time` datetime NULL COMMENT '创建时间',
    `del_flag` char(1) NULL DEFAULT '0' COMMENT '逻辑删除标记(0--正常 1--删除)',
    KEY `menu_id` (`menu_id`),
    KEY `okayapi_qi_ace_sys_menu_name` (`okayapi_qi_ace_sys_menu_name`),
    KEY `permission` (`permission`),
    KEY `path` (`path`),
    KEY `parent_id` (`parent_id`),
    KEY `icon` (`icon`),
    KEY `component` (`component`),
    KEY `sort` (`sort`),
    KEY `keep_alive` (`keep_alive`),
    KEY `okayapi_qi_ace_sys_menu_type` (`okayapi_qi_ace_sys_menu_type`),
    KEY `create_time` (`create_time`),
    KEY `del_flag` (`del_flag`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'qi后台管理系统-菜单权限表';

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


MySQL database table structure design

Displaying 1-12 of 12 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
menu_idint(11)菜单ID
okayapi_qi_ace_sys_menu_namevarchar(32)菜单名称
permissionvarchar(32)菜单权限标识
pathvarchar(128)前端URL
parent_idint(11)父菜单ID
iconvarchar(32)图标
componentvarchar(64)VUE页面
sortint(11)1排序值1
keep_alivechar(1)00-开启,1- 关闭0
okayapi_qi_ace_sys_menu_typechar(1)菜单类型 (0菜单 1按钮)
create_timedatetime创建时间
del_flagchar(1)0逻辑删除标记(0--正常 1--删除)0

Guess You Like

MySQL Table Design okayapi_qi_ace_sys_dept_relation

MySQL Table Design okayapi_qi_ace_sys_oauth_client_details

MySQL Table Design okayapi_qi_ace_sys_role_menu

MySQL Table Design okayapi_qi_ace_base_group

MySQL Table Design okayapi_qi_ace_base_group_leader

MySQL Table Design okayapi_qi_ace_base_group_member

MySQL Table Design okayapi_qi_ace_base_group_type

MySQL Table Design okayapi_qi_ace_base_menu

MySQL Table Design okayapi_qi_ace_base_resource_authority

MySQL Table Design okayapi_qi_ace_base_user

MySQL Table Design okayapi_qi_ace_gate_log

MySQL Table Design okayapi_qi_ace_auth_client

MySQL Table Design okayapi_qi_ace_auth_client_service

MySQL Table Design okayapi_qi_ace_sys_dict

MySQL Table Design okayapi_qi_ace_sys_dict_item

MySQL Table Design okayapi_qi_ace_sys_log

TOP ↑