+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_sys_menu_manage:/tablelist/okayapi_sys_menu_manage.html


-- MySQL Table okayapi_sys_menu_manage
-- From: OkayAPI.com
CREATE TABLE `okayapi_sys_menu_manage` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `title` varchar(50) NULL COMMENT '标题',
    `pid` int(50) NULL DEFAULT '0' COMMENT '上级id',
    `url` varchar(50) NULL COMMENT '链接地址',
    `menu_css` varchar(50) NULL COMMENT '样式',
    `sort` int(5) NULL DEFAULT '0' COMMENT '排序',
    `level` tinyint(1) NULL DEFAULT '1' COMMENT '级别',
    `cate_id` tinyint(5) NULL DEFAULT '0' COMMENT '分类id',
    `dev` tinyint(4) NULL DEFAULT '0' COMMENT '开发者[0:都可见;1开发模式可见]',
    `params` varchar(1000) NULL COMMENT '参数',
    `status` tinyint(1) NULL DEFAULT '1' COMMENT '状态[-1:删除;0:禁用;1启用]',
    KEY `title` (`title`),
    KEY `pid` (`pid`),
    KEY `url` (`url`),
    KEY `menu_css` (`menu_css`),
    KEY `sort` (`sort`),
    KEY `level` (`level`),
    KEY `cate_id` (`cate_id`),
    KEY `dev` (`dev`),
    KEY `params` (`params`),
    KEY `status` (`status`),
    PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT '菜单导航权限管理表';

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


MySQL database table structure design

Displaying 1-10 of 10 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
titlevarchar(50)标题
pidint(50)0上级id0
urlvarchar(50)链接地址
menu_cssvarchar(50)样式
sortint(5)0排序0
leveltinyint(1)1级别1
cate_idtinyint(5)0分类id0
devtinyint(4)0开发者[0:都可见;1开发模式可见]0
paramsvarchar(1000)参数
statustinyint(1)1状态[-1:删除;0:禁用;1启用]1

Guess You Like

MySQL Table Design okayapi_file_uploads

MySQL Table Design okayapi_framework_log

MySQL Table Design okayapi_provinces_log

MySQL Table Design okayapi_sms_log

MySQL Table Design okayapi_member_datas_log

MySQL Table Design okayapi_member_vip

MySQL Table Design okayapi_sys_message

MySQL Table Design okayapi_sys_notice_manage

MySQL Table Design okayapi_sys_config_manage

MySQL Table Design okayapi_sys_addon_manage

MySQL Table Design okayapi_server_manage

TOP ↑