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 Name | Field Type | Default | IS NULL | Field Comment | Index | Demo Data |
---|---|---|---|---|---|---|
a | double | 否 | 机构合计 | |||
b1 | double | 否 | 行政小计 | |||
b11 | varchar(100) | 否 | 行政省 | |||
b12 | varchar(100) | 否 | 行政市 | |||
b13 | varchar(100) | 否 | 行政县 | |||
b2 | double | 否 | 事业合计 | |||
b3 | double | 否 | 参公小计 | |||
b31 | varchar(100) | 否 | 参公省 | |||
b32 | varchar(100) | 否 | 参公市 | |||
b33 | varchar(100) | 否 | 参公县 | |||
c1 | double | 否 | 全额拨款 | |||
c2 | double | 否 | 差额拨款 | |||
c3 | double | 否 | 自收自支 | |||
d | int(11) | 否 | 经费合计 | |||
d1 | longtext | 否 | 机构资质 |