+ Use This Table All Design

MySQL Create Table SQL

Table Structure: okayapi_jeewms_jform_price1:/tablelist/okayapi_jeewms_jform_price1.html


-- MySQL Table okayapi_jeewms_jform_price1
-- From: OkayAPI.com
CREATE TABLE `okayapi_jeewms_jform_price1` (
    `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
    `a` double NOT NULL COMMENT '机构合计',
    `b1` double NOT NULL COMMENT '行政小计',
    `b11` varchar(100) NOT NULL COMMENT '行政省',
    `b12` varchar(100) NOT NULL COMMENT '行政市',
    `b13` varchar(100) NOT NULL COMMENT '行政县',
    `b2` double NOT NULL COMMENT '事业合计',
    `b3` double NOT NULL COMMENT '参公小计',
    `b31` varchar(100) NOT NULL COMMENT '参公省',
    `b32` varchar(100) NOT NULL COMMENT '参公市',
    `b33` varchar(100) NOT NULL COMMENT '参公县',
    `c1` double NOT NULL COMMENT '全额拨款',
    `c2` double NOT NULL COMMENT '差额拨款',
    `c3` double NOT NULL COMMENT '自收自支',
    `d` int(11) NOT NULL COMMENT '经费合计',
    `d1` longtext NOT NULL COMMENT '机构资质',
    KEY `a` (`a`),
    KEY `b1` (`b1`),
    KEY `b11` (`b11`),
    KEY `b12` (`b12`),
    KEY `b13` (`b13`),
    KEY `b2` (`b2`),
    KEY `b3` (`b3`),
    KEY `b31` (`b31`),
    KEY `b32` (`b32`),
    KEY `b33` (`b33`),
    KEY `c1` (`c1`),
    KEY `c2` (`c2`),
    KEY `c3` (`c3`),
    KEY `d` (`d`),
    KEY `d1` (`d1`),
    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-15 of 15 results.
Field NameField TypeDefaultIS NULLField CommentIndexDemo Data
adouble机构合计
b1double行政小计
b11varchar(100)行政省
b12varchar(100)行政市
b13varchar(100)行政县
b2double事业合计
b3double参公小计
b31varchar(100)参公省
b32varchar(100)参公市
b33varchar(100)参公县
c1double全额拨款
c2double差额拨款
c3double自收自支
dint(11)经费合计
d1longtext机构资质

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 ↑