gas.sql

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

  `consignUnit` varchar(200) default NULL COMMENT '委托单位',
  `useGasAddress` varchar(200) default NULL COMMENT '用气地址',
  `linkman` varchar(50) default NULL COMMENT '联系人',
  `tel` varchar(50) default NULL COMMENT '电话',
  `fax` varchar(50) default NULL COMMENT '传真',
  `consignContext` text COMMENT '托委内容',
  `completeTime` varchar(50) default NULL COMMENT '完成 时间',
  `remark` text COMMENT '备注',
  `underwriteDepartment` varchar(255) default NULL COMMENT '签发部门',
  `underwriteTime1` date default NULL COMMENT '签发日期',
  `lead` varchar(255) default NULL COMMENT '主管领导',
  `underwriteTime2` datetime default NULL COMMENT '签发日期',
  `inceptDept` varchar(255) default NULL COMMENT '接收部门',
  `inceptTime1` datetime default NULL COMMENT '接收日期',
  `designCharge` varchar(255) default NULL COMMENT '设计主管',
  `inceptTime2` datetime default NULL,
  `oprater` varchar(255) default NULL COMMENT '操作人',
  `oprateTime` date default NULL COMMENT '操作日期',
  PRIMARY KEY  (`designId`),
  KEY `applyListId` (`applyListId`),
  KEY `consignUnit` (`consignUnit`),
  KEY `useGasAddress` (`useGasAddress`),
  KEY `linkman` (`linkman`),
  KEY `tel` (`tel`),
  KEY `fax` (`fax`),
  KEY `projectName1` (`projectName1`),
  KEY `projectName2` (`projectName2`),
  KEY `useGasId` (`useGasId`),
  CONSTRAINT `project03_designconsigninfo_ibfk_1` FOREIGN KEY (`useGasId`) REFERENCES `project01_usegasapply` (`useGasId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for project04_deviserinfo
-- ----------------------------
CREATE TABLE `project04_deviserinfo` (
  `id` int(11) NOT NULL auto_increment,
  `deviser` varchar(255) default '' COMMENT '设计者',
  `inceptTime` date default NULL COMMENT '设计委托接收时间',
  `completeTime` date default NULL COMMENT '完成时间',
  `remark` text COMMENT '备注',
  PRIMARY KEY  (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for project04_supportgas_infor
-- ----------------------------
CREATE TABLE `project04_supportgas_infor` (
  `Pro4Id` int(8) NOT NULL auto_increment,
  `Pro4FkId1` int(8) default NULL,
  `Pro4FkId2` int(8) default NULL,
  `SupId` varchar(10) NOT NULL,
  `FkProjectName1` varchar(50) default NULL,
  `FkProjectName2` varchar(50) default NULL,
  `FkUseAddress` varchar(255) default NULL,
  `ReceiveDepartment` varchar(50) default NULL,
  `ProjectScope` varchar(50) default NULL,
  `ComCheckDate` date default NULL,
  `UseGasDate` datetime default NULL,
  `GasKind` varchar(50) default NULL,
  `GasMeterType` varchar(255) default NULL,
  `GasMeterKind` varchar(255) default NULL,
  `CheckMeterTime` int(8) default NULL,
  `Remark` varchar(255) default NULL,
  `FkWiter` varchar(255) default NULL,
  `WiteDate` date default NULL,
  `AccountDirector` varchar(255) default NULL,
  `AccountIdea` varchar(255) default NULL,
  `ThisDate` datetime default NULL,
  `FenGuanManager` varchar(255) default NULL,
  `FGMIdea` varchar(255) default NULL,
  `ThisDate2` datetime default NULL,
  `GeneralManager` varchar(255) default NULL,
  `GMIdea` varchar(255) default NULL,
  `ThisDate3` datetime default NULL,
  `ControlPerson` varchar(255) default NULL,
  `ControlDate` datetime default NULL,
  PRIMARY KEY  (`Pro4Id`),
  KEY `Pro4FkId1` (`Pro4FkId1`),
  KEY `Pro4FkId2` (`Pro4FkId2`),
  CONSTRAINT `project04_supportgas_infor_ibfk_4` FOREIGN KEY (`Pro4FkId1`) REFERENCES `project02_qualitycheck_list` (`Pro2Id`),
  CONSTRAINT `project04_supportgas_infor_ibfk_5` FOREIGN KEY (`Pro4FkId2`) REFERENCES `project01_usegasapply` (`useGasId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for project05_fluxcount_list
-- ----------------------------
CREATE TABLE `project05_fluxcount_list` (
  `Pro06Id` int(8) NOT NULL,
  `MeterType` varchar(50) default NULL,
  `Coefficient` float(10,0) default NULL,
  `XiuzhengyiType` varchar(50) default NULL,
  `GasPurpose` varchar(255) default NULL,
  `Price` float(10,0) default NULL,
  `Remark` varchar(255) default NULL,
  PRIMARY KEY  (`Pro06Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for project05_projectbudget
-- ----------------------------
CREATE TABLE `project05_projectbudget` (
  `budgetId` int(11) NOT NULL auto_increment,
  `designId` int(11) default NULL,
  `projectBudgetId` varchar(50) default '' COMMENT '工程预算审批表编号',
  `projectName1` varchar(50) default NULL COMMENT '工程名称1',
  `projectName2` varchar(50) default NULL COMMENT '工程名称2',
  `buildUnit` varchar(255) default NULL COMMENT '建设单位',
  `projectBudget` float default NULL COMMENT '程工预算价',
  `workoutDate` date default NULL COMMENT '编制日期',
  `organizer` varchar(255) default NULL COMMENT '编制人',
  `checkMan` varchar(255) default NULL COMMENT '复核人',
  `checkIdea` text COMMENT '复核意见',
  `checkDate` datetime default NULL COMMENT '复核日期',
  `oprater` varchar(255) default NULL COMMENT '操作人',
  `oprateDate` datetime default NULL COMMENT '操作日期',
  PRIMARY KEY  (`budgetId`),
  KEY `projectName1` (`projectName1`),
  KEY `projectName2` (`projectName2`),
  KEY `designId` (`designId`),
  CONSTRAINT `project05_projectbudget_ibfk_1` FOREIGN KEY (`designId`) REFERENCES `project03_designconsigninfo` (`designId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for project06_adjustpress_list
-- ----------------------------
CREATE TABLE `project06_adjustpress_list` (
  `Pro7Id` int(10) NOT NULL,
  `Type` varchar(50) default NULL,
  `ExportPress` int(8) default NULL,
  `Remark` varchar(255) default NULL,
  `Type2` varchar(50) default NULL,
  `ExportPress2` int(8) default NULL,
  `Remark2` varchar(255) default NULL,
  PRIMARY KEY  (`Pro7Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for project06_constructionmessage
-- ----------------------------
CREATE TABLE `project06_constructionmessage` (
  `messageId` int(11) NOT NULL auto_increment,
  `designId` int(11) default NULL,
  `constructionMessageId` varchar(50) default '施工任务通知单编号' COMMENT 'message',
  `projectName1` varchar(50) default NULL COMMENT '工程名称',
  `projectName2` varchar(50) default NULL,
  `projectName3` varchar(50) default NULL,
  `consignUnit` varchar(200) default NULL COMMENT '委托单位',
  `constructUnit` varchar(200) default NULL COMMENT '施工单位',
  `pactId` int(11) default NULL COMMENT '合同编号',
  `startTime` date default NULL COMMENT '开工日期',
  `completeTime` date default NULL COMMENT '完工日期',
  `constructionPicNo` varchar(20) default NULL COMMENT '施工图号',
  `projectContext` text COMMENT '工程内容及要求',
  `projectConstructionSupervise` varchar(255) default NULL COMMENT '工程施工监理',
  `constructionController` varchar(255) default NULL COMMENT '施工管理员',
  `remark` text COMMENT '备注',
  `deptPrincipal` varchar(255) default NULL COMMENT '部门负责人',
  `date1` datetime default NULL,
  `director` varchar(255) default NULL COMMENT '主管领导',
  `date2` datetime default NULL,
  `oprater` varchar(255) default NULL,
  `oprateDate` datetime default NULL,
  PRIMARY KEY  (`messageId`),
  KEY `consignUnit` (`consignUnit`),
  KEY `designId` (`designId`),
  KEY `pactId` (`pactId`),
  CONSTRAINT `project06_constructionmessage_ibfk_2` FOREIGN KEY (`pactId`) REFERENCES `project07_pact` (`pactId`),
  CONSTRAINT `project06_constructionmessage_ibfk_1` FOREIGN KEY (`designId`) REFERENCES `project03_designconsigninfo` (`designId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for project07_areagas_list
-- ----------------------------
CREATE TABLE `project07_areagas_list` (
  `Pro7Id` int(8) NOT NULL auto_increment,
  `Pro7FkId` int(8) default NULL,
  `State` varchar(255) default NULL,
  `SmallArea` varchar(255) default NULL,
  `BuidingNum` varchar(200) default NULL,
  `DoorplateNum` varchar(200) default NULL,
  `consumerCount` int(11) default NULL,
  `UserCount` int(11) default NULL,
  `Remark` varchar(255) default NULL,
  PRIMARY KEY  (`Pro7Id`),
  KEY `Pro7FkId` (`Pro7FkId`),
  CONSTRAINT `project07_areagas_list_ibfk_2` FOREIGN KEY (`Pro7FkId`) REFERENCES `project01_usegasapply` (`useGasId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for project07_pact
-- ----------------------------
CREATE TABLE `project07_pact` (
  `pactId` int(11) NOT NULL auto_increment,
  PRIMARY KEY  (`pactId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for project08_qualitycheck
-- ----------------------------
CREATE TABLE `project08_qualitycheck` (
  `id` int(11) NOT NULL auto_increment,
  `designId` int(11) default NULL,
  `checkApplyId` varchar(255) default '' COMMENT '质量验收申请单编号',
  `projectName1` varchar(50) default NULL,
  `projectName2` varchar(50) default NULL,
  `constructionUnit` varchar(200) default NULL COMMENT '施工单位',
  `useGasKind` varchar(50) default NULL COMMENT '用气性质',
  `completeDate` date default NULL COMMENT '工竣日期',
  `digLength` varchar(50) default NULL COMMENT '开挖长度',
  `backfillTerrene` varchar(50) default NULL COMMENT '回填 土质',
  `ductPlace` varchar(50) default NULL COMMENT '管位',
  `other` varchar(50) default NULL,
  `constructionControllerCheck` text COMMENT '施工管理员检查情况',
  `constructionController` varchar(255) default NULL,
  `designDate` datetime default NULL,
  `checkTime` date default NULL COMMENT '验收日期',
  `remark` text,
  `oprater` varchar(255) default NULL,
  `oprateTime` datetime default NULL,
  PRIMARY KEY  (`id`),
  KEY `designId` (`designId`),
  CONSTRAINT `project08_qualitycheck_ibfk_1` FOREIGN KEY (`designId`) REFERENCES `project03_designconsigninfo` (`designId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for project08_startadjust_list
-- ----------------------------
CREATE TABLE `project08_startadjust_list` (
  `Pro8Id` int(8) NOT NULL auto_increment,
  `FkPro8Id` int(8) default NULL,
  `AdjustTaskId` varchar(255) default NULL,
  `SupportInforId` varchar(255) default NULL,
  `UserCompany` varchar(255) default NULL,
  `BookingStartDate` varchar(255) default NULL,
  `SignPerson` varchar(255) default NULL,
  `GasSourceKind` varchar(255) default NULL,
  `StandardPressure` int(8) default NULL,
  `TaskChargePerson` varchar(255) default NULL,
  `TaskWorker` varchar(255) default NULL,
  `AdjustEquipment` varchar(255) default NULL,
  `AdjustEquipmentId` varchar(255) default NULL,
  `ProductCompany` varchar(255) default NULL,
  `MainControlType` varchar(255) default NULL,
  `MainControlId` varchar(255) default NULL,
  `PipeChangeCourse` varchar(255) default NULL,
  `CheckLeakPerson` varchar(50) default NULL,
  `InterfaceLeakCheck` varchar(255) default NULL,
  `TYQgenzongResult` varchar(200) default NULL,
  `TaskTime` date default NULL,
  `ForbidFire` varchar(255) default NULL,
  `NowState` varchar(255) default NULL,
  `Remark` varchar(255) default NULL,
  `ControlPerson` varchar(255) default NULL,
  `ControlDate` varchar(255) default NULL,
  PRIMARY KEY  (`Pro8Id`),
  KEY `FkPro8Id` (`FkPro8Id`),
  CONSTRAINT `project08_startadjust_list_ibfk_1` FOREIGN KEY (`FkPro8Id`) REFERENCES `project04_supportgas_infor` (`Pro4Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for project09_constructioncontext
-- ----------------------------
CREATE TABLE `project09_constructioncontext` (
  `contextId` int(11) NOT NULL auto_increment,
  `type` varchar(200) default NULL,
  `context` varchar(50) default NULL,
  PRIMARY KEY  (`contextId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------