MySQL Create Table SQL
Table Structure: okayapi_vhr_menu:/tablelist/okayapi_vhr_menu.html
-- MySQL Table okayapi_vhr_menu
-- From: OkayAPI.com
CREATE TABLE `okayapi_vhr_menu` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`url` varchar(64) NULL COMMENT '',
`path` varchar(64) NULL COMMENT '',
`component` varchar(64) NULL COMMENT '',
`name` varchar(64) NULL COMMENT '',
`iconCls` varchar(64) NULL COMMENT '',
`keepAlive` tinyint(1) NULL COMMENT '',
`requireAuth` tinyint(1) NULL COMMENT '',
`parentId` int(11) NULL COMMENT '',
`enabled` tinyint(1) NULL DEFAULT '1' COMMENT '',
KEY `url` (`url`),
KEY `path` (`path`),
KEY `component` (`component`),
KEY `name` (`name`),
KEY `iconCls` (`iconCls`),
KEY `keepAlive` (`keepAlive`),
KEY `requireAuth` (`requireAuth`),
KEY `parentId` (`parentId`),
KEY `enabled` (`enabled`),
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-9 of 9 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
url | varchar(64) | 是 | ||||
path | varchar(64) | 是 | ||||
component | varchar(64) | 是 | ||||
name | varchar(64) | 是 | ||||
iconCls | varchar(64) | 是 | ||||
keepAlive | tinyint(1) | 是 | ||||
requireAuth | tinyint(1) | 是 | ||||
parentId | int(11) | 是 | Normal Index | |||
enabled | tinyint(1) | 1 | 是 | 1 |