+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_ry_sys_menu:/tablelist/okayapi_ry_sys_menu.html


-- MySQL Table okayapi_ry_sys_menu
-- From: OkayAPI.com
CREATE TABLE `okayapi_ry_sys_menu` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `menu_id` bigint(20) NULL COMMENT '菜单ID',
    `menu_name` varchar(50) NULL COMMENT '菜单名称',
    `parent_id` bigint(20) NULL DEFAULT '0' COMMENT '父菜单ID',
    `order_num` int(4) NULL DEFAULT '0' COMMENT '显示顺序',
    `url` varchar(200) NULL DEFAULT '#' COMMENT '请求地址',
    `target` varchar(20) NULL COMMENT '打开方式(menuItem页签 menuBlank新窗口)',
    `menu_type` char(1) NULL COMMENT '菜单类型(M目录 C菜单 F按钮)',
    `visible` char(1) NULL DEFAULT '0' COMMENT '菜单状态(0显示 1隐藏)',
    `is_refresh` char(1) NULL DEFAULT '1' COMMENT '是否刷新(0刷新 1不刷新)',
    `perms` varchar(100) NULL COMMENT '权限标识',
    `icon` varchar(100) NULL DEFAULT '#' COMMENT '菜单图标',
    `create_by` varchar(64) NULL COMMENT '创建者',
    `create_time` datetime NULL COMMENT '创建时间',
    `update_by` varchar(64) NULL COMMENT '更新者',
    `remark` varchar(500) NULL COMMENT '备注',
    KEY `menu_id` (`menu_id`),
    KEY `menu_name` (`menu_name`),
    KEY `parent_id` (`parent_id`),
    KEY `order_num` (`order_num`),
    KEY `url` (`url`),
    KEY `target` (`target`),
    KEY `menu_type` (`menu_type`),
    KEY `visible` (`visible`),
    KEY `is_refresh` (`is_refresh`),
    KEY `perms` (`perms`),
    KEY `icon` (`icon`),
    KEY `create_by` (`create_by`),
    KEY `create_time` (`create_time`),
    KEY `update_by` (`update_by`),
    KEY `remark` (`remark`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'RuoYi后台管理系统-菜单权限表';

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


MySQL database table structure design

Displaying 1-15 of 15 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
menu_idbigint(20)菜单ID
menu_namevarchar(50)菜单名称
parent_idbigint(20)0父菜单ID0
order_numint(4)0显示顺序0
urlvarchar(200)#请求地址#
targetvarchar(20)打开方式(menuItem页签 menuBlank新窗口)
menu_typechar(1)菜单类型(M目录 C菜单 F按钮)
visiblechar(1)0菜单状态(0显示 1隐藏)0
is_refreshchar(1)1是否刷新(0刷新 1不刷新)1
permsvarchar(100)权限标识
iconvarchar(100)#菜单图标#
create_byvarchar(64)创建者
create_timedatetime创建时间
update_byvarchar(64)更新者
remarkvarchar(500)备注

Guess You Like

MySQL Table Design okayapi_ry_sys_dept

MySQL Table Design okayapi_ry_sys_user

MySQL Table Design okayapi_ry_sys_post

MySQL Table Design okayapi_ry_sys_role

MySQL Table Design okayapi_ry_sys_user_role

MySQL Table Design okayapi_ry_sys_role_menu

MySQL Table Design okayapi_ry_sys_role_dept

MySQL Table Design okayapi_ry_sys_user_post

MySQL Table Design okayapi_ry_sys_oper_log

MySQL Table Design okayapi_ry_sys_dict_type

MySQL Table Design okayapi_ry_sys_dict_data

MySQL Table Design okayapi_ry_sys_config

MySQL Table Design okayapi_ry_sys_logininfor

MySQL Table Design okayapi_ry_sys_user_online

MySQL Table Design okayapi_ry_sys_job

MySQL Table Design okayapi_ry_sys_job_log

MySQL Table Design okayapi_ry_sys_notice

MySQL Table Design okayapi_ry_gen_table

MySQL Table Design okayapi_ry_gen_table_column

TOP ↑