MySQL Create Table SQL
Table Structure: okayapi_fie_nav_menu:/tablelist/okayapi_fie_nav_menu.html
-- MySQL Table okayapi_fie_nav_menu
-- From: OkayAPI.com
CREATE TABLE `okayapi_fie_nav_menu` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`nav_id` int(11) NOT NULL COMMENT '导航 id',
`parent_id` int(11) NOT NULL COMMENT '父 id',
`okayapi_fie_nav_menu_status` tinyint(3) NOT NULL DEFAULT '1' COMMENT '状态;1:显示;0:隐藏',
`list_order` float NOT NULL DEFAULT '10000' COMMENT '排序',
`okayapi_fie_nav_menu_name` varchar(50) NOT NULL COMMENT '菜单名称',
`target` varchar(10) NOT NULL COMMENT '打开方式',
`href` varchar(100) NOT NULL COMMENT '链接',
`icon` varchar(20) NOT NULL COMMENT '图标',
`path` varchar(255) NOT NULL COMMENT '层级关系',
KEY `nav_id` (`nav_id`),
KEY `parent_id` (`parent_id`),
KEY `okayapi_fie_nav_menu_status` (`okayapi_fie_nav_menu_status`),
KEY `list_order` (`list_order`),
KEY `okayapi_fie_nav_menu_name` (`okayapi_fie_nav_menu_name`),
KEY `target` (`target`),
KEY `href` (`href`),
KEY `icon` (`icon`),
KEY `path` (`path`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'fie内容管理-前台导航菜单表';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-9 of 9 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
nav_id | int(11) | 否 | 导航 id | |||
parent_id | int(11) | 否 | 父 id | |||
okayapi_fie_nav_menu_status | tinyint(3) | 1 | 否 | 状态;1:显示;0:隐藏 | 1 | |
list_order | float | 10000 | 否 | 排序 | 10000 | |
okayapi_fie_nav_menu_name | varchar(50) | 否 | 菜单名称 | |||
target | varchar(10) | 否 | 打开方式 | |||
href | varchar(100) | 否 | 链接 | |||
icon | varchar(20) | 否 | 图标 | |||
path | varchar(255) | 否 | 层级关系 |