gas.sql

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

-- Table structure for project09_fluxconfigure_list
-- ----------------------------
CREATE TABLE `project09_fluxconfigure_list` (
  `Pro9Id` int(8) NOT NULL auto_increment,
  `Pro9FkId` int(8) default NULL,
  `FluxId` varchar(255) default NULL,
  `Type` varchar(255) default NULL,
  `Coefficient` float(10,0) default NULL,
  `Purpose` varchar(255) default NULL,
  `Price` float(10,0) default NULL,
  `InitializeValue` float(9,0) default NULL,
  `XiuzhengyiId` varchar(255) default NULL,
  `XiuzhengyiType` varchar(255) default NULL,
  `XZYInitializeValue` float(9,0) default NULL,
  PRIMARY KEY  (`Pro9Id`),
  KEY `Pro9FkId` (`Pro9FkId`),
  CONSTRAINT `project09_fluxconfigure_list_ibfk_1` FOREIGN KEY (`Pro9FkId`) REFERENCES `project04_supportgas_infor` (`Pro4Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for project10_adjustconfigure_list
-- ----------------------------
CREATE TABLE `project10_adjustconfigure_list` (
  `Pro10Id` int(8) NOT NULL auto_increment,
  `TiaoyaqiState` varchar(255) default NULL,
  `TiaoyaqiId` varchar(50) default NULL,
  `InportPress` int(8) default NULL,
  `ExportPress` int(8) default NULL,
  `LuqianPress` int(8) default NULL,
  `ClosePress` int(8) default NULL,
  `FangsanPress` int(8) default NULL,
  `CutPress` int(8) default NULL,
  `Remark` varchar(255) default NULL,
  PRIMARY KEY  (`Pro10Id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for tbl_dept
-- ----------------------------
CREATE TABLE `tbl_dept` (
  `dept_no` int(10) NOT NULL auto_increment COMMENT '部门编号',
  `dept_name` varchar(255) default NULL COMMENT '部门名称',
  `remark` varchar(255) default NULL COMMENT '备注',
  `top_dept` int(10) default NULL COMMENT '上级部门',
  PRIMARY KEY  (`dept_no`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for tbl_emp
-- ----------------------------
CREATE TABLE `tbl_emp` (
  `emp_no` int(11) NOT NULL auto_increment,
  `workNo` varchar(255) default NULL COMMENT '工号',
  `empName` varchar(40) default NULL COMMENT '员工姓名',
  `empSex` int(11) default NULL COMMENT '性别',
  `contractType` varchar(255) default NULL COMMENT '雇用合同类型',
  `birthDate` date default NULL COMMENT '出生日期',
  `nation` varchar(255) default NULL COMMENT '民族',
  `nativePlace` varchar(255) default NULL COMMENT '户口所在地',
  `workDate` date default NULL COMMENT '工作时间',
  `residence` varchar(200) default NULL COMMENT '永久居住地',
  `address` varchar(200) default NULL COMMENT '现居地',
  `street` varchar(50) default NULL COMMENT '所属街道',
  `homePhone` varchar(50) default NULL COMMENT '家用电话',
  `mobilePhone` varchar(50) default NULL COMMENT '手机号',
  `E_Mail` varchar(50) default NULL COMMENT '电子信箱',
  `IDCode` varchar(50) default NULL COMMENT '身份证',
  `degree` varchar(255) default NULL COMMENT '学历',
  `fk_empdegree` int(11) default NULL,
  `politicVisage` varchar(255) default NULL COMMENT '政治面貌',
  `marriage` varchar(255) default NULL COMMENT '婚姻状况',
  `health` varchar(255) default NULL COMMENT '健康状况',
  `graduateSchool` varchar(50) default NULL COMMENT '毕业院校',
  `graduateTime` date default NULL COMMENT '毕业时间',
  `major` varchar(50) default NULL COMMENT '专业',
  `language` varchar(50) default NULL COMMENT '外语',
  `strongSuit` varchar(50) default NULL COMMENT '特长',
  `title` varchar(50) default NULL COMMENT '技术职称',
  `entryTime` date default NULL COMMENT '进入公司时间',
  `duty` varchar(50) default NULL COMMENT '职位',
  `department` varchar(255) default NULL COMMENT '所在部门',
  `fk_dept` int(11) default NULL,
  `post` varchar(255) default NULL COMMENT '岗位',
  `contractBeginDate` date default NULL COMMENT '合同开始日期',
  `contractEndDate` date default NULL COMMENT '合同j截止日期',
  `remark` text COMMENT '备注',
  `operateDate` datetime default NULL COMMENT '操作日期',
  `operateMan` int(11) default NULL COMMENT '操作人',
  PRIMARY KEY  (`emp_no`),
  KEY `fk_group_no` (`fk_dept`),
  KEY `name` (`empName`),
  KEY `FKCF0052AC6F9650A6` (`fk_dept`),
  KEY `fk_empdegree` (`fk_empdegree`),
  KEY `operateMan` (`operateMan`),
  CONSTRAINT `tbl_emp_ibfk_9` FOREIGN KEY (`operateMan`) REFERENCES `tbl_emplogin` (`loginId`),
  CONSTRAINT `tbl_emp_ibfk_4` FOREIGN KEY (`fk_empdegree`) REFERENCES `y_empdegree` (`empdegree_id`),
  CONSTRAINT `tbl_emp_ibfk_5` FOREIGN KEY (`fk_dept`) REFERENCES `tbl_dept` (`dept_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for tbl_emplogin
-- ----------------------------
CREATE TABLE `tbl_emplogin` (
  `loginId` int(11) NOT NULL auto_increment,
  `fk_emp` int(11) default NULL,
  `empAccount` varchar(50) default NULL COMMENT '登录帐号',
  `pwd` varchar(50) default NULL COMMENT '密码',
  `checkpwd` varchar(50) default NULL COMMENT '验证密码',
  `ifAdmin` int(11) default NULL COMMENT '断判是否有权限操作,无则为普通员工只做查询',
  PRIMARY KEY  (`loginId`),
  KEY `fk_emp` (`fk_emp`),
  KEY `loginId` (`loginId`),
  CONSTRAINT `tbl_emplogin_ibfk_1` FOREIGN KEY (`fk_emp`) REFERENCES `tbl_emp` (`emp_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for tbl_litigation
-- ----------------------------
CREATE TABLE `tbl_litigation` (
  `litigation_id` int(11) NOT NULL auto_increment,
  `litigationNo` varchar(7) default NULL COMMENT '投诉编号',
  `litigator` varchar(255) default NULL COMMENT '投诉人',
  `fk_x_rsident` int(11) default NULL,
  `address` varchar(255) default NULL COMMENT '家庭住址',
  `phone` varchar(255) default NULL COMMENT '电话',
  `litigationDate` datetime default NULL COMMENT '投诉日期',
  `litigationReason` text COMMENT '投诉原由',
  `litigationPath` text COMMENT '投诉途径',
  `acceptor` varchar(255) default NULL COMMENT '受理人',
  `acceptDept` varchar(255) default NULL COMMENT '受理人所在部门',
  `fk_emp` int(11) default NULL,
  `obligator` varchar(255) default NULL COMMENT '负责人',
  `obligateDept` varchar(255) default NULL COMMENT '负责人所在部门',
  `timeLimit` varchar(50) default NULL COMMENT '理处时限',
  `acceptTime` datetime default NULL COMMENT '受理人发送日期',
  `disposal` text COMMENT '处理情况',
  `obligateTime` datetime default NULL COMMENT '责任人发送日期',
  `feedback` text COMMENT '反馈意见',
  `remark` text,
  `oprate_date` datetime default NULL,
  `operateMan` int(11) default NULL,
  `state` varchar(50) default NULL,
  PRIMARY KEY  (`litigation_id`),
  KEY `fk_x_rsident` (`fk_x_rsident`),
  KEY `fk_emp` (`fk_emp`),
  KEY `operateMan` (`operateMan`),
  CONSTRAINT `tbl_litigation_ibfk_5` FOREIGN KEY (`operateMan`) REFERENCES `tbl_emplogin` (`loginId`),
  CONSTRAINT `tbl_litigation_ibfk_1` FOREIGN KEY (`fk_x_rsident`) REFERENCES `x_resident` (`residentId`),
  CONSTRAINT `tbl_litigation_ibfk_2` FOREIGN KEY (`fk_emp`) REFERENCES `tbl_emp` (`emp_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for tbl_log
-- ----------------------------
CREATE TABLE `tbl_log` (
  `logId` int(11) NOT NULL auto_increment,
  `title` varchar(255) default NULL,
  `content` varchar(255) default NULL,
  `logDate` date default NULL,
  `fk_emp` int(11) default NULL,
  `fk_module` int(11) default NULL,
  PRIMARY KEY  (`logId`),
  KEY `fk_emp` (`fk_emp`),
  KEY `fk_module` (`fk_module`),
  CONSTRAINT `tbl_log_ibfk_1` FOREIGN KEY (`fk_emp`) REFERENCES `tbl_emp` (`emp_no`),
  CONSTRAINT `tbl_log_ibfk_2` FOREIGN KEY (`fk_module`) REFERENCES `tbl_module` (`moduleId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for tbl_module
-- ----------------------------
CREATE TABLE `tbl_module` (
  `moduleId` int(11) NOT NULL auto_increment COMMENT '一级模块编号',
  `moduleName` varchar(255) default NULL COMMENT '一级模块名称',
  `fk_dept` int(11) default NULL COMMENT '所属部门',
  PRIMARY KEY  (`moduleId`),
  KEY `fk_dept` (`fk_dept`),
  CONSTRAINT `tbl_module_ibfk_1` FOREIGN KEY (`fk_dept`) REFERENCES `tbl_dept` (`dept_no`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for tbl_rule
-- ----------------------------
CREATE TABLE `tbl_rule` (
  `rule_no` int(11) NOT NULL auto_increment,
  `select` int(11) default NULL COMMENT '询查',
  `delete` int(11) default NULL COMMENT '删除',
  `insert` int(11) default NULL COMMENT '增新',
  `updata` int(11) default NULL COMMENT '改修',
  `send` int(11) default NULL COMMENT '发送',
  `export` int(11) default NULL COMMENT '导出',
  `close` int(11) default NULL COMMENT '关闭',
  `copy` int(11) default NULL COMMENT '打印',
  `back` int(11) default NULL COMMENT '退回',
  `revert` int(11) default NULL COMMENT '回复',
  `solved` int(11) default NULL COMMENT '已解决/已处理',
  `solving` int(11) default NULL COMMENT '解决中/处理中',
  `notSolve` int(11) default NULL COMMENT '未解决/未处理',
  `checkOut` int(11) default NULL COMMENT '结单',
  `fk_module` int(11) default NULL,
  PRIMARY KEY  (`rule_no`),
  KEY `first` (`fk_module`),
  KEY `FKFE6B6DDB24D29EC` (`fk_module`),
  CONSTRAINT `tbl_rule_ibfk_1` FOREIGN KEY (`fk_module`) REFERENCES `tbl_module` (`moduleId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for tbl_submodule
-- ----------------------------
CREATE TABLE `tbl_submodule` (
  `subModuleId` int(11) NOT NULL auto_increment COMMENT '二级模块编号',
  `subModuleName` varchar(255) default NULL COMMENT '二级模块名称',
  `fk_module` int(11) default NULL COMMENT '属所一级模块',
  PRIMARY KEY  (`subModuleId`),
  KEY `fk_module` (`fk_module`),
  CONSTRAINT `tbl_submodule_ibfk_1` FOREIGN KEY (`fk_module`) REFERENCES `tbl_module` (`moduleId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for tbl_training
-- ----------------------------
CREATE TABLE `tbl_training` (
  `train_id` int(11) NOT NULL auto_increment,
  `trainingNo` varchar(255) default NULL COMMENT '培训编号',
  `trainingName` varchar(50) default NULL COMMENT '培训名称',
  `trainingContent` varchar(50) default NULL COMMENT '培训内容',
  `trainingTime` varchar(50) default NULL COMMENT '培训时间',
  `fk_y_trainingtype` int(11) default NULL COMMENT '培训类别',
  `remark` text COMMENT '备注',
  `operateDate` datetime default NULL COMMENT '操作日期',
  `operateMan` int(11) default NULL COMMENT '操作人',
  PRIMARY KEY  (`train_id`),
  KEY `fk_y_trainingtype` (`fk_y_trainingtype`),
  KEY `operateMan` (`operateMan`),
  CONSTRAINT `tbl_training_ibfk_4` FOREIGN KEY (`operateMan`) REFERENCES `tbl_emplogin` (`loginId`),
  CONSTRAINT `tbl_training_ibfk_1` FOREIGN KEY (`fk_y_trainingtype`) REFERENCES `y_trainingtype` (`trainingtype_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for tbl_traininglist
-- ----------------------------
CREATE TABLE `tbl_traininglist` (
  `trainList_id` int(11) NOT NULL auto_increment COMMENT '培训列表编号',
  `fk_emp` int(11) default NULL COMMENT '员工编号/工号',
  `empName` varchar(255) default NULL COMMENT '员工姓名',
  `sex` int(11) default NULL COMMENT '性别',
  `dept` varchar(255) default NULL COMMENT '所在部门',
  `post` varchar(255) default NULL COMMENT '岗位',
  `fk_training` int(11) default NULL COMMENT '培训类别',
  `trainingName` varchar(255) default NULL COMMENT '培训名称',
  `trainingContent` varchar(255) default NULL COMMENT '培训内容',
  `trainingType` varchar(255) default NULL COMMENT '培训类型',
  `certificateNo` varchar(50) default NULL COMMENT '证书编号',
  `deliverOrgan` varchar(50) default NULL COMMENT '发证机构',
  `effectBegin` date default NULL COMMENT '有效期（始）',
  `effectEnd` date default NULL COMMENT '有效期（止）',
  `checkResult` int(11) default NULL COMMENT '考核结果',
  `remark` text COMMENT '备注',
  PRIMARY KEY  (`trainList_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Table structure for x_cahngecost
-- ----------------------------
CREATE TABLE `x_cahngecost` (
  `datumeId` int(11) NOT NULL auto_increment,
  `changeNo` varchar(11) default NULL COMMENT '任务单编号(由相关的“移添改