gas.sql

数据库源代码,用来创建一个数据库,是做一个燃气系统的.

  `rbbId` int(11) NOT NULL auto_increment,
  `scrbbNo` varchar(255) default NULL,
  `scrbbDate` date default NULL,
  `weather` varchar(255) default NULL,
  `bbtj_date` date default NULL,
  `zhjl` varchar(255) default NULL,
  `tbr` varchar(255) default NULL,
  `max_1` float default NULL,
  `min_1` float default NULL,
  `8h_1` float default NULL,
  `8h_kc_1` float default NULL,
  `max_2` float default NULL,
  `min_2` float default NULL,
  `8h_2` float default NULL,
  `8h_kc_2` float default NULL,
  `max_3` float default NULL,
  `min_3` float default NULL,
  `8h_3` float default NULL,
  `8h_kc_3` float default NULL,
  `max_w` float default NULL,
  `min_w` float default NULL,
  `8h_w` float default NULL,
  `8h_kc_w` float default NULL,
  `total` float default NULL,
  `max_pa_1` float default NULL,
  `min_pa_1` float default NULL,
  `avg_pa_1` float default NULL,
  `max_pa_2` float default NULL,
  `min_pa_2` float default NULL,
  `avg_pa_2` float default NULL,
  `max_pa_3` float default NULL,
  `min_pa_3` float default NULL,
  `avg_pa_3` float default NULL,
  `max_pa_w` float default NULL,
  `min_pa_w` float default NULL,
  `avg_pa_w` float default NULL,
  `max_c_1` float default NULL,
  `min_c_1` float default NULL,
  `avg_c_1` float default NULL,
  `max_c_2` float default NULL,
  `min_c_2` float default NULL,
  `avg_c_2` float default NULL,
  `max_c_3` float default NULL,
  `min_c_3` float default NULL,
  `avg_c_3` float default NULL,
  `max_c_w` float default NULL,
  `min_c_w` float default NULL,
  `avg_c_w` float default NULL,
  `drcl` int(11) default NULL,
  `pjrz` int(11) default NULL,
  `dylj_hh` int(11) default NULL,
  `zdyl` int(11) default NULL,
  `syjl` int(11) default NULL,
  `xyjl` int(11) default NULL,
  `dylj_trq` int(11) default NULL,
  `dr_ls_p` int(11) default NULL,
  `dr_ls_kg` int(11) default NULL,
  `dy_ls_p` int(11) default NULL,
  `dy_ls_kg` int(11) default NULL,
  `dr_zs_kg` float default NULL,
  `dy_zs_kg` float default NULL,
  `dr_total` float default NULL,
  `dy_total` float default NULL,
  `dr_car_total` int(11) default NULL,
  `dy_car_total` int(11) default NULL,
  `dr_top_total` float default NULL,
  `dy_top_total` float default NULL,
  `operator_man` int(10) default NULL,
  `operation_date` date default NULL,
  PRIMARY KEY  (`rbbId`),
  KEY `operator_man` (`operator_man`),
  CONSTRAINT `p_scrbb_ibfk_1` FOREIGN KEY (`operator_man`) REFERENCES `tbl_emplogin` (`loginId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for p_scybb
-- ----------------------------
CREATE TABLE `p_scybb` (
  `ybbId` int(11) NOT NULL auto_increment,
  `ybbNo` varchar(255) default NULL,
  `srybbDate` date default NULL,
  `department` varchar(255) default NULL,
  `tbr` varchar(255) default NULL,
  `bbtj_date` date default NULL,
  `bycs` int(11) default NULL,
  `byzl_rk` float default NULL,
  `byps_15` int(11) default NULL,
  `ljps_15` int(11) default NULL,
  `byps_50` int(11) default NULL,
  `ljps_50` int(11) default NULL,
  `byps_ex` int(11) default NULL,
  `ljps_ex` int(11) default NULL,
  `byzl_ck_w` float default NULL,
  `ljzl_ck_w` float default NULL,
  `byzl_ck_n` float default NULL,
  `ljzl_ck_n` float default NULL,
  `by_total` float default NULL,
  `lj_total` float default NULL,
  `bycs_zs` int(11) default NULL,
  `byzl_zs` float default NULL,
  `ljcs_zs` int(11) default NULL,
  `ljzl_zs` float default NULL,
  `by_gdxh` float default NULL,
  `nlj_gdxh` float default NULL,
  `by_glxh` float default NULL,
  `nlj_glxh` float default NULL,
  `yhqkcl` float default NULL,
  `ywkc` float default NULL,
  `by_yd` float default NULL,
  `lj_yd` float default NULL,
  `by_ys` float default NULL,
  `lj_ys` float default NULL,
  `by_hhq` float default NULL,
  `nlj_hhq` float default NULL,
  `hhq_startdate` date default NULL,
  `hhq_enddate` date default NULL,
  `hhq_num` float default NULL,
  `by_trq_ycl` float default NULL,
  `by_trq_sjl` float default NULL,
  `nlj_bysjl` float default NULL,
  `trq_startdate` date default NULL,
  `trq_enddate` date default NULL,
  `trq_ql` float default NULL,
  `operator_man` int(11) default NULL,
  `operation_date` date default NULL,
  PRIMARY KEY  (`ybbId`),
  KEY `operator` (`operator_man`),
  CONSTRAINT `p_scybb_ibfk_1` FOREIGN KEY (`ybbId`) REFERENCES `tbl_emplogin` (`loginId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for project01_complete_infor
-- ----------------------------
CREATE TABLE `project01_complete_infor` (
  `Pro1Id` int(8) NOT NULL auto_increment,
  `Pro1fkId` int(8) default NULL,
  `InforId` varchar(11) default NULL,
  `CheckYear` int(4) default NULL,
  `CheckMonth` int(2) default NULL,
  `CheckDate` int(2) default NULL,
  `CheckAM` bit(1) default NULL,
  `FkProjectName1` varchar(50) default NULL,
  `FkProjectName2` varchar(50) default NULL,
  `SignDate` date default NULL,
  `ControlPerson` varchar(255) default NULL,
  `ControlDate` date default NULL,
  PRIMARY KEY  (`Pro1Id`),
  KEY `ProjectName1` (`FkProjectName1`),
  KEY `ProjectName2` (`FkProjectName2`),
  KEY `Pro1fkId` (`Pro1fkId`),
  CONSTRAINT `project01_complete_infor_ibfk_4` FOREIGN KEY (`Pro1fkId`) REFERENCES `project03_designconsigninfo` (`designId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='InnoDB free: 10240 kB';

-- ----------------------------
-- Table structure for project01_usegasapply
-- ----------------------------
CREATE TABLE `project01_usegasapply` (
  `useGasId` int(10) NOT NULL auto_increment,
  `applyListId` varchar(7) default '' COMMENT '申请单编号',
  `clientType` varchar(4) default NULL COMMENT '客户类型',
  `applyKind` varchar(2) default NULL COMMENT '请申性质',
  `useGasKind` varchar(10) default NULL COMMENT '用气种类',
  `applyUnit` varchar(50) default NULL COMMENT '申请单位',
  `useGasAddress1` varchar(50) default NULL COMMENT '用气地址',
  `useGasAddress2` varchar(50) default NULL,
  `unitKind` varchar(20) default NULL COMMENT '单位性质',
  `industry` varchar(255) default NULL COMMENT '业行',
  `linkman` varchar(50) default NULL COMMENT '联系人',
  `tel` varchar(50) default NULL COMMENT '电话',
  `fax` varchar(50) default NULL COMMENT '真传',
  `proposer` varchar(255) default NULL COMMENT '申请人',
  `applyDate` date default NULL COMMENT '申请日期',
  `remark` varchar(255) default NULL COMMENT '备注',
  `isaccept` bit(1) default NULL COMMENT '是否接受',
  `reason` varchar(255) default NULL COMMENT '因原',
  `operand` varchar(255) default NULL COMMENT '操作人',
  `operationDate` datetime default NULL COMMENT '作操日期',
  PRIMARY KEY  (`useGasId`),
  KEY `applyUnit` (`applyUnit`),
  KEY `useGasAddress2` (`useGasAddress2`),
  KEY `linkman` (`linkman`),
  KEY `tel` (`tel`),
  KEY `fax` (`fax`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for project02_fixtureinfo
-- ----------------------------
CREATE TABLE `project02_fixtureinfo` (
  `fixtureId` int(11) NOT NULL auto_increment,
  `fixtureName` varchar(50) default NULL COMMENT '备名称设',
  `fixtureNumber` int(8) default NULL COMMENT '数量',
  `useGasQuantity` int(8) default NULL COMMENT '最大小时用气量',
  `useTime` int(8) default NULL COMMENT '每天用气时间',
  `useGasPressure` int(8) default NULL COMMENT '气用压力',
  `requestTime` int(8) default NULL COMMENT '求要用气时间',
  PRIMARY KEY  (`fixtureId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for project02_qualitycheck_list
-- ----------------------------
CREATE TABLE `project02_qualitycheck_list` (
  `Pro2Id` int(8) NOT NULL auto_increment,
  `Pro2FkIdjungong` int(8) default NULL,
  `Pro2FkIdshigong` int(8) default NULL,
  `CheckId` varchar(10) default '',
  `FkProjectName1` varchar(50) default NULL,
  `FkProjectName2` varchar(50) default NULL,
  `ProjectAddress` varchar(50) default NULL,
  `FkConstructCompany` varchar(255) default NULL,
  `FkConstructPhase` varchar(50) default NULL,
  `FkCheckTime` varchar(255) default NULL,
  `FkConstructPicNo` varchar(20) default NULL,
  `FkCheckPerson` varchar(255) default NULL,
  `Idea` varchar(200) default NULL,
  `FkAuditPerson` varchar(255) default NULL,
  `IdeaDate` date default NULL,
  `Safety` varchar(200) default NULL,
  `Equipment` varchar(200) default NULL,
  `PracticalityCheck` varchar(200) default NULL,
  `GasCloseCheck` varchar(200) default NULL,
  `CheckResult` bit(2) default NULL,
  `CheckvVerdict` varchar(200) default NULL,
  `CheckDate` date default NULL,
  `ProblemResult` varchar(255) default NULL,
  `ResultDate` date default NULL,
  `UserIdea` varchar(255) default NULL,
  `UserIdeaDate` date default NULL,
  `Remark` varchar(255) default NULL,
  `ControlPerson` varchar(255) default NULL,
  `ControlDate` date default NULL,
  PRIMARY KEY  (`Pro2Id`),
  KEY `Pro2FkIdjungong` (`Pro2FkIdjungong`),
  KEY `Pro2FkIdshigong` (`Pro2FkIdshigong`),
  CONSTRAINT `project02_qualitycheck_list_ibfk_7` FOREIGN KEY (`Pro2FkIdjungong`) REFERENCES `project01_complete_infor` (`Pro1Id`),
  CONSTRAINT `project02_qualitycheck_list_ibfk_8` FOREIGN KEY (`Pro2FkIdshigong`) REFERENCES `project06_constructionmessage` (`messageId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for project03_complete_eligibilityinfor
-- ----------------------------
CREATE TABLE `project03_complete_eligibilityinfor` (
  `Pro3Id` int(8) NOT NULL,
  `Pro3FkId` int(8) default NULL,
  `Id` varchar(10) NOT NULL,
  `FkProjectName1` varchar(50) default NULL,
  `FkProjectName2` varchar(50) default NULL,
  `CheckDate` date default NULL,
  `SignDate` date default NULL,
  `ControlPerson` varchar(255) default NULL,
  `ControlDate` date default NULL,
  PRIMARY KEY  (`Pro3Id`),
  KEY `Pro3FkId` (`Pro3FkId`),
  CONSTRAINT `project03_complete_eligibilityinfor_ibfk_3` FOREIGN KEY (`Pro3FkId`) REFERENCES `project08_qualitycheck` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for project03_designconsigninfo
-- ----------------------------
CREATE TABLE `project03_designconsigninfo` (
  `designId` int(11) NOT NULL auto_increment,
  `useGasId` int(11) default NULL,
  `designConsignId` varchar(50) default '' COMMENT '设计委托编号',
  `applyListId` varchar(7) default NULL COMMENT '气用申请单编号',
  `projectScope` varchar(50) default NULL COMMENT '工程范围',
  `itemId1` varchar(50) default NULL COMMENT '项目编号',
  `itemId2` varchar(50) default NULL,
  `projectName1` varchar(50) default NULL,
  `projectName2` varchar(50) default NULL,