MySQL Create Table SQL
Table Structure: okayapi_jsh_functions:/tablelist/okayapi_jsh_functions.html
-- MySQL Table okayapi_jsh_functions
-- From: OkayAPI.com
CREATE TABLE `okayapi_jsh_functions` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`Id` bigint(20) NULL COMMENT '主键',
`Number` varchar(50) NULL COMMENT '编号',
`Name` varchar(50) NULL COMMENT '名称',
`PNumber` varchar(50) NULL COMMENT '上级编号',
`URL` varchar(100) NULL COMMENT '链接',
`State` bit(1) NULL COMMENT '收缩',
`Sort` varchar(50) NULL COMMENT '排序',
`Enabled` bit(1) NULL COMMENT '启用',
`Type` varchar(50) NULL COMMENT '类型',
`PushBtn` varchar(50) NULL COMMENT '功能按钮',
`delete_Flag` varchar(1) NULL DEFAULT '0' COMMENT '删除标记,0未删除,1删除',
KEY `Id` (`Id`),
KEY `Number` (`Number`),
KEY `Name` (`Name`),
KEY `PNumber` (`PNumber`),
KEY `URL` (`URL`),
KEY `State` (`State`),
KEY `Sort` (`Sort`),
KEY `Enabled` (`Enabled`),
KEY `Type` (`Type`),
KEY `PushBtn` (`PushBtn`),
KEY `delete_Flag` (`delete_Flag`),
PRIMARY KEY (`id`)
) ENGINE=InnoDB COMMENT 'ERP进销存-功能模块表';
After replication, you can go to the database to create the database table.
MySQL database table structure design
Displaying 1-11 of 11 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
Id | bigint(20) | 否 | 主键 | |||
Number | varchar(50) | 是 | 编号 | |||
Name | varchar(50) | 是 | 名称 | |||
PNumber | varchar(50) | 是 | 上级编号 | |||
URL | varchar(100) | 是 | 链接 | |||
State | bit(1) | 是 | 收缩 | |||
Sort | varchar(50) | 是 | 排序 | |||
Enabled | bit(1) | 是 | 启用 | |||
Type | varchar(50) | 是 | 类型 | |||
PushBtn | varchar(50) | 是 | 功能按钮 | |||
delete_Flag | varchar(1) | 0 | 是 | 删除标记,0未删除,1删除 | 0 |