+ Use This Table All Design

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 NameField TypeDefaultIS NULLField CommentIndexDemo Data
cgr_sqltext查询数据SQL
okayapi_jeewms_jform_graphreport_head_codevarchar(36)编码
contentvarchar(1000)描述
okayapi_jeewms_jform_graphreport_head_namevarchar(100)名称
ytextvarchar(100)y轴文字
categoriesvarchar(1000)x轴数据
is_show_listvarchar(5)是否显示明细
x_page_jstext扩展JS

Guess You Like

MySQL Table Design okayapi_jeewms_ba_act_type

MySQL Table Design okayapi_jeewms_ba_area

MySQL Table Design okayapi_jeewms_ba_barea

MySQL Table Design okayapi_jeewms_ba_bin_type

MySQL Table Design okayapi_jeewms_ba_buss_type

MySQL Table Design okayapi_jeewms_ba_city

MySQL Table Design okayapi_jeewms_ba_city_type

MySQL Table Design okayapi_jeewms_ba_classfl

MySQL Table Design okayapi_jeewms_ba_com_deg

MySQL Table Design okayapi_jeewms_ba_com_type

MySQL Table Design okayapi_jeewms_ba_comp

MySQL Table Design okayapi_jeewms_ba_cont_spec

MySQL Table Design okayapi_jeewms_ba_cont_type

MySQL Table Design okayapi_jeewms_ba_cost

MySQL Table Design okayapi_jeewms_ba_cost_conf

MySQL Table Design okayapi_jeewms_ba_cost_type

MySQL Table Design okayapi_jeewms_ba_cus_sta

MySQL Table Design okayapi_jeewms_ba_deg_type

MySQL Table Design okayapi_jeewms_ba_del_mode

MySQL Table Design okayapi_jeewms_ba_edu_sta

TOP ↑