MySQL Create Table SQL
Table Structure: okayapi_jeewms_jform_graphreport_head:/tablelist/okayapi_jeewms_jform_graphreport_head.html
-- MySQL Table okayapi_jeewms_jform_graphreport_head
-- From: OkayAPI.com
CREATE TABLE `okayapi_jeewms_jform_graphreport_head` (
`id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
`cgr_sql` text NULL COMMENT '查询数据SQL',
`okayapi_jeewms_jform_graphreport_head_code` varchar(36) NULL COMMENT '编码',
`content` varchar(1000) NULL COMMENT '描述',
`okayapi_jeewms_jform_graphreport_head_name` varchar(100) NULL COMMENT '名称',
`ytext` varchar(100) NULL COMMENT 'y轴文字',
`categories` varchar(1000) NULL COMMENT 'x轴数据',
`is_show_list` varchar(5) NULL COMMENT '是否显示明细',
`x_page_js` text NULL COMMENT '扩展JS',
KEY `cgr_sql` (`cgr_sql`),
KEY `okayapi_jeewms_jform_graphreport_head_code` (`okayapi_jeewms_jform_graphreport_head_code`),
KEY `content` (`content`),
KEY `okayapi_jeewms_jform_graphreport_head_name` (`okayapi_jeewms_jform_graphreport_head_name`),
KEY `ytext` (`ytext`),
KEY `categories` (`categories`),
KEY `is_show_list` (`is_show_list`),
KEY `x_page_js` (`x_page_js`),
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-8 of 8 results.
Field Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
cgr_sql | text | 否 | 查询数据SQL | |||
okayapi_jeewms_jform_graphreport_head_code | varchar(36) | 否 | 编码 | |||
content | varchar(1000) | 否 | 描述 | |||
okayapi_jeewms_jform_graphreport_head_name | varchar(100) | 否 | 名称 | |||
ytext | varchar(100) | 否 | y轴文字 | |||
categories | varchar(1000) | 否 | x轴数据 | |||
is_show_list | varchar(5) | 是 | 是否显示明细 | |||
x_page_js | text | 是 | 扩展JS |