/*
 Navicat MySQL Data Transfer

 Source Server         : localhost3306
 Source Server Type    : MySQL
 Source Server Version : 50703
 Source Host           : localhost:3306
 Source Schema         : 雷神山医院管理

 Target Server Type    : MySQL
 Target Server Version : 50703
 File Encoding         : 65001

 Date: 27/04/2020 11:41:30
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for fangjianshiyongqingkuangbiao
-- ----------------------------
DROP TABLE IF EXISTS `fangjianshiyongqingkuangbiao`;
CREATE TABLE `fangjianshiyongqingkuangbiao`  (
  `fangjianhao` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `fangjianweizhi` int(3) NULL DEFAULT NULL,
  `fangjianshifoumanyuan` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`fangjianhao`) USING BTREE,
  INDEX `seven_six`(`fangjianweizhi`) USING BTREE,
  CONSTRAINT `seven_six` FOREIGN KEY (`fangjianweizhi`) REFERENCES `huanzherjibenxinxibiao` (`fangjianweizhi`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of fangjianshiyongqingkuangbiao
-- ----------------------------
INSERT INTO `fangjianshiyongqingkuangbiao` VALUES ('107', 107, '是');
INSERT INTO `fangjianshiyongqingkuangbiao` VALUES ('205', 205, '是');
INSERT INTO `fangjianshiyongqingkuangbiao` VALUES ('209', 209, '是');
INSERT INTO `fangjianshiyongqingkuangbiao` VALUES ('215', 215, '是');
INSERT INTO `fangjianshiyongqingkuangbiao` VALUES ('220', 220, '否');
INSERT INTO `fangjianshiyongqingkuangbiao` VALUES ('301', 301, '否');
INSERT INTO `fangjianshiyongqingkuangbiao` VALUES ('306', 306, '否');
INSERT INTO `fangjianshiyongqingkuangbiao` VALUES ('307', 307, '是');
INSERT INTO `fangjianshiyongqingkuangbiao` VALUES ('314', 314, '是');
INSERT INTO `fangjianshiyongqingkuangbiao` VALUES ('401', 401, '否');
INSERT INTO `fangjianshiyongqingkuangbiao` VALUES ('402', 402, '是');
INSERT INTO `fangjianshiyongqingkuangbiao` VALUES ('403', 403, '否');
INSERT INTO `fangjianshiyongqingkuangbiao` VALUES ('404', 404, '否');
INSERT INTO `fangjianshiyongqingkuangbiao` VALUES ('501', 501, '否');
INSERT INTO `fangjianshiyongqingkuangbiao` VALUES ('506', 506, '是');
INSERT INTO `fangjianshiyongqingkuangbiao` VALUES ('509', 509, '否');

-- ----------------------------
-- Table structure for huanzhebingqingcanzhaobiao
-- ----------------------------
DROP TABLE IF EXISTS `huanzhebingqingcanzhaobiao`;
CREATE TABLE `huanzhebingqingcanzhaobiao`  (
  `huanzhebingqingdaihao` int(2) NOT NULL,
  `jutibingqing` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`huanzhebingqingdaihao`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of huanzhebingqingcanzhaobiao
-- ----------------------------
INSERT INTO `huanzhebingqingcanzhaobiao` VALUES (1, '重度');
INSERT INTO `huanzhebingqingcanzhaobiao` VALUES (2, '轻度');
INSERT INTO `huanzhebingqingcanzhaobiao` VALUES (3, '轻微');

-- ----------------------------
-- Table structure for huanzhebingqingzhuangkuangbiao
-- ----------------------------
DROP TABLE IF EXISTS `huanzhebingqingzhuangkuangbiao`;
CREATE TABLE `huanzhebingqingzhuangkuangbiao`  (
  `huanzhehao` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `fangjianhao` int(3) NULL DEFAULT NULL,
  `huanzhebingqingdaihao` int(2) NULL DEFAULT NULL,
  `teshuqingkuangbeizhu` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `jiashuyouwuganran` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`huanzhehao`) USING BTREE,
  INDEX `one_two`(`huanzhebingqingdaihao`) USING BTREE,
  INDEX `fangjianhao`(`fangjianhao`) USING BTREE,
  CONSTRAINT `one_two` FOREIGN KEY (`huanzhebingqingdaihao`) REFERENCES `huanzhebingqingcanzhaobiao` (`huanzhebingqingdaihao`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of huanzhebingqingzhuangkuangbiao
-- ----------------------------
INSERT INTO `huanzhebingqingzhuangkuangbiao` VALUES ('2212020001', 301, 1, '无', '无');
INSERT INTO `huanzhebingqingzhuangkuangbiao` VALUES ('2212020021', 301, 1, '无', '无');
INSERT INTO `huanzhebingqingzhuangkuangbiao` VALUES ('5112020003', 205, 1, '无', '无');
INSERT INTO `huanzhebingqingzhuangkuangbiao` VALUES ('5122020001', 403, 2, '无', '无');
INSERT INTO `huanzhebingqingzhuangkuangbiao` VALUES ('5122020002', 403, 2, '无', '无');
INSERT INTO `huanzhebingqingzhuangkuangbiao` VALUES ('5132020034', 220, 3, '无', '无');
INSERT INTO `huanzhebingqingzhuangkuangbiao` VALUES ('5132020094', 220, 3, '无', '无');
INSERT INTO `huanzhebingqingzhuangkuangbiao` VALUES ('5142020020', 209, 1, '无', '无');
INSERT INTO `huanzhebingqingzhuangkuangbiao` VALUES ('5142020045', 209, 1, '无', '无');
INSERT INTO `huanzhebingqingzhuangkuangbiao` VALUES ('5152020005', 306, 1, '无', '无');
INSERT INTO `huanzhebingqingzhuangkuangbiao` VALUES ('5152020021', 306, 2, '无', '无');
INSERT INTO `huanzhebingqingzhuangkuangbiao` VALUES ('5162020006', 307, 1, '无', '有');
INSERT INTO `huanzhebingqingzhuangkuangbiao` VALUES ('5162020013', 307, 2, '无', '无');
INSERT INTO `huanzhebingqingzhuangkuangbiao` VALUES ('5172020012', 314, 1, '无', '有');
INSERT INTO `huanzhebingqingzhuangkuangbiao` VALUES ('5172020056', 314, 2, '无', '有');
INSERT INTO `huanzhebingqingzhuangkuangbiao` VALUES ('5182020026', 404, 2, '无', '无');
INSERT INTO `huanzhebingqingzhuangkuangbiao` VALUES ('5182020032', 404, 3, '无', '有');
INSERT INTO `huanzhebingqingzhuangkuangbiao` VALUES ('5192020038', 402, 3, '无', '无');
INSERT INTO `huanzhebingqingzhuangkuangbiao` VALUES ('5192020043', 403, 3, '无', '有');
INSERT INTO `huanzhebingqingzhuangkuangbiao` VALUES ('5192020063', 402, 3, '无', '有');
INSERT INTO `huanzhebingqingzhuangkuangbiao` VALUES ('5202020018', 401, 1, '无', '有');
INSERT INTO `huanzhebingqingzhuangkuangbiao` VALUES ('5202020069', 401, 2, '注意休息', '无');
INSERT INTO `huanzhebingqingzhuangkuangbiao` VALUES ('5212020026', 215, 2, '无', '有');
INSERT INTO `huanzhebingqingzhuangkuangbiao` VALUES ('5212020054', 215, 1, '饮食清淡', '无');
INSERT INTO `huanzhebingqingzhuangkuangbiao` VALUES ('5222020013', 501, 1, '无', '无');
INSERT INTO `huanzhebingqingzhuangkuangbiao` VALUES ('5222020078', 501, 3, '避免通风', '无');
INSERT INTO `huanzhebingqingzhuangkuangbiao` VALUES ('5232020004', 509, 2, '无', '无');
INSERT INTO `huanzhebingqingzhuangkuangbiao` VALUES ('5232020045', 509, 3, '避免接触', '有');
INSERT INTO `huanzhebingqingzhuangkuangbiao` VALUES ('5242020028', 506, 3, '无', '有');
INSERT INTO `huanzhebingqingzhuangkuangbiao` VALUES ('5242020035', 506, 3, '无', '无');
INSERT INTO `huanzhebingqingzhuangkuangbiao` VALUES ('5252020007', 504, 2, '无', '无');
INSERT INTO `huanzhebingqingzhuangkuangbiao` VALUES ('5252020084', 504, 2, '注意不要接触手术部位', '无');
INSERT INTO `huanzhebingqingzhuangkuangbiao` VALUES ('5292020009', 107, 2, '无', '无');
INSERT INTO `huanzhebingqingzhuangkuangbiao` VALUES ('5292020036', 107, 1, '无', '无');

-- ----------------------------
-- Table structure for huanzherjibenxinxibiao
-- ----------------------------
DROP TABLE IF EXISTS `huanzherjibenxinxibiao`;
CREATE TABLE `huanzherjibenxinxibiao`  (
  `shenfenzhenghao` varchar(18) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `xingming` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `xingbie` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `nianling` int(3) NULL DEFAULT NULL,
  `jiguan` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `huanzhehao` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `fangjianweizhi` int(3) NULL DEFAULT NULL,
  `ruyuanshijian` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `jiashulianxitianhua` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`shenfenzhenghao`) USING BTREE,
  INDEX `患者号`(`huanzhehao`) USING BTREE,
  INDEX `房间位置`(`fangjianweizhi`) USING BTREE,
  CONSTRAINT `six_two` FOREIGN KEY (`huanzhehao`) REFERENCES `huanzhebingqingzhuangkuangbiao` (`huanzhehao`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of huanzherjibenxinxibiao
-- ----------------------------
INSERT INTO `huanzherjibenxinxibiao` VALUES ('152983199504259864', '杜组建', '男', 25, '湖北宜昌', '5132020034', 220, '20200117', '18883073333');
INSERT INTO `huanzherjibenxinxibiao` VALUES ('211165199203029864', '刘海燕', '男', 31, '湖南益阳', '5142020020', 209, '20200119', '18323333339');
INSERT INTO `huanzherjibenxinxibiao` VALUES ('231154199202282143', '周前进', '女', 29, '湖北枣阳', '5122020002', 403, '20200101', '13883622222');
INSERT INTO `huanzherjibenxinxibiao` VALUES ('233424198901248765', '黄安', '男', 46, '湖北宜昌', '5142020045', 209, '20200113', '13996362222');
INSERT INTO `huanzherjibenxinxibiao` VALUES ('234221199906278461', '谢鹏', '女', 31, '陕西西安', '5152020005', 306, '20200112', '18883587777');
INSERT INTO `huanzherjibenxinxibiao` VALUES ('235432199712030432', '王有福', '男', 39, '湖北荆门', '5152020021', 306, '20200113', '18883897777');
INSERT INTO `huanzherjibenxinxibiao` VALUES ('242221200108063451', '李雪钟', '男', 33, '湖南娄底', '5162020006', 307, '20200114', '13960228888');
INSERT INTO `huanzherjibenxinxibiao` VALUES ('242323200405032341', '周家国', '女', 36, '湖北利川', '5162020013', 307, '20200115', '13996262222');
INSERT INTO `huanzherjibenxinxibiao` VALUES ('311134200411230932', '韩爽', '男', 27, '重庆长寿', '5172020012', 314, '20200116', '18883567783');
INSERT INTO `huanzherjibenxinxibiao` VALUES ('312434199205071532', '陈晓敏', '男', 32, '湖北荆州', '5182020032', 404, '20200117', '15034567843');
INSERT INTO `huanzherjibenxinxibiao` VALUES ('321154198303312014', '柳林', '女', 28, '湖南益阳', '5182020026', 404, '20200118', '18889999990');
INSERT INTO `huanzherjibenxinxibiao` VALUES ('321234299612050321', '赵保国', '女', 32, '重庆开州', '5192020038', 402, '20200119', '16783945747');
INSERT INTO `huanzherjibenxinxibiao` VALUES ('32324319846243564', '单楠楠', '男', 22, '湖北咸宁', '5192020063', 403, '20200101', '17342724848');
INSERT INTO `huanzherjibenxinxibiao` VALUES ('334254199804089821', '刘向华', '女', 37, '江西南昌', '5202020018', 401, '20200102', '17389477574');
INSERT INTO `huanzherjibenxinxibiao` VALUES ('362222199406042154', '刘华美', '女', 36, '湖北宜昌', '2212020001', 301, '20200103', '15384563476');
INSERT INTO `huanzherjibenxinxibiao` VALUES ('376345199002186743', '石栏', '男', 35, '湖北武汉', '5202020069', 401, '20200104', '13478456344');
INSERT INTO `huanzherjibenxinxibiao` VALUES ('429221200112078751', '杜大伟', '女', 36, '湖北荆门', '5212020054', 215, '20200105', '17483535334');
INSERT INTO `huanzherjibenxinxibiao` VALUES ('432221198812040602', '郝总生', '女', 26, '湖北广水', '5222020013', 501, '20200106', '14835734538');
INSERT INTO `huanzherjibenxinxibiao` VALUES ('432223199229162314', '刘海', '男', 35, '湖北襄阳', '5112020003', 205, '20200107', '13294857349');
INSERT INTO `huanzherjibenxinxibiao` VALUES ('433122199302046732', '卢平', '女', 32, '湖北潜江', '5212020026', 215, '20200106', '14353653463');
INSERT INTO `huanzherjibenxinxibiao` VALUES ('452441199508042031', '王凤虚', '男', 47, '湖南岳阳', '5222020078', 501, '20200108', '14357837348');
INSERT INTO `huanzherjibenxinxibiao` VALUES ('50022818747843', '阳明路', '男', 34, '重庆忠县', '5122020001', 403, '20200104', '17865876695');
INSERT INTO `huanzherjibenxinxibiao` VALUES ('500228198703046754', '石师', '女', 38, '重庆开州', '5192020043', 301, '20200102', '15890043574');
INSERT INTO `huanzherjibenxinxibiao` VALUES ('500228199405176754', '刘妮昂', '女', 39, '湖北恩施', '5132020094', 220, '20200117', '17867549001');
INSERT INTO `huanzherjibenxinxibiao` VALUES ('512223197803023421', '王茜金', '女', 42, '湖北宜昌', '2212020021', 301, '20200118', '17829364578');
INSERT INTO `huanzherjibenxinxibiao` VALUES ('512225198705074564', '吴国栋', '男', 34, '湖北武汉', '5172020056', 314, '20200178', '15846736654');
INSERT INTO `huanzherjibenxinxibiao` VALUES ('512341199610096732', '马金龙', '男', 42, '湖北武汉', '5232020004', 509, '20200111', '17483738758');
INSERT INTO `huanzherjibenxinxibiao` VALUES ('522142199206088453', '张兆', '女', 25, '江西南昌', '5232020045', 509, '20200112', '13432745388');
INSERT INTO `huanzherjibenxinxibiao` VALUES ('532164199303097432', '于勇', '男', 32, '湖南长沙', '5242020028', 506, '20200113', '17432853739');
INSERT INTO `huanzherjibenxinxibiao` VALUES ('532356199509046741', '孙松林', '男', 23, '重庆开州', '5242020035', 506, '20200114', '19435738734');
INSERT INTO `huanzherjibenxinxibiao` VALUES ('535231200304053214', '刘丽萍', '男', 34, '江西南昌', '5252020007', 504, '20200115', '14398757874');
INSERT INTO `huanzherjibenxinxibiao` VALUES ('541197199405278563', '吴建明', '女', 33, '重庆开州', '5252020084', 504, '20200116', '43856574435');
INSERT INTO `huanzherjibenxinxibiao` VALUES ('542331199311020431', '王桂霞', '女', 43, '湖南长沙', '5292020009', 107, '20200117', '15484674967');
INSERT INTO `huanzherjibenxinxibiao` VALUES ('652564199106077844', '刘健夫', '女', 33, '湖南娄底', '5292020036', 107, '20200118', '54387643653');

-- ----------------------------
-- Table structure for shebeishiyongqingkuangbiao
-- ----------------------------
DROP TABLE IF EXISTS `shebeishiyongqingkuangbiao`;
CREATE TABLE `shebeishiyongqingkuangbiao`  (
  `shebeihao` varchar(5) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `shebeileixing` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `shifoushiyong` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `yongyunagehuanzhe(huanzhehao)` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`shebeihao`) USING BTREE,
  INDEX `eight_six`(`yongyunagehuanzhe(huanzhehao)`) USING BTREE,
  CONSTRAINT `eight_six` FOREIGN KEY (`yongyunagehuanzhe(huanzhehao)`) REFERENCES `huanzherjibenxinxibiao` (`huanzhehao`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of shebeishiyongqingkuangbiao
-- ----------------------------
INSERT INTO `shebeishiyongqingkuangbiao` VALUES ('22110', '洗肠机', '否', '2212020001');
INSERT INTO `shebeishiyongqingkuangbiao` VALUES ('22111', '洗肠机', '是', '2212020021');
INSERT INTO `shebeishiyongqingkuangbiao` VALUES ('51101', '全景口腔x光机', '是', '5112020003');
INSERT INTO `shebeishiyongqingkuangbiao` VALUES ('51201', '综合验光仪', '是', '5122020001');
INSERT INTO `shebeishiyongqingkuangbiao` VALUES ('51202', '综合验光仪', '否', '5122020002');
INSERT INTO `shebeishiyongqingkuangbiao` VALUES ('51301', '听力计', '是', '5132020034');
INSERT INTO `shebeishiyongqingkuangbiao` VALUES ('51302', '听力计', '是', '5132020094');
INSERT INTO `shebeishiyongqingkuangbiao` VALUES ('51411', '微创治疗仪', '是', '5142020045');
INSERT INTO `shebeishiyongqingkuangbiao` VALUES ('51416', '微创治疗仪', '否', '5142020020');
INSERT INTO `shebeishiyongqingkuangbiao` VALUES ('51502', '监护仪', '否', '5152020021');
INSERT INTO `shebeishiyongqingkuangbiao` VALUES ('51504', '监护仪', '是', '5152020005');
INSERT INTO `shebeishiyongqingkuangbiao` VALUES ('51612', '引流管', '是', '5162020006');
INSERT INTO `shebeishiyongqingkuangbiao` VALUES ('51621', '引流管', '是', '5162020013');
INSERT INTO `shebeishiyongqingkuangbiao` VALUES ('51704', '血压计', '否', '5172020056');
INSERT INTO `shebeishiyongqingkuangbiao` VALUES ('51722', '血压计', '否', '5172020012');
INSERT INTO `shebeishiyongqingkuangbiao` VALUES ('51812', '电动吸引器', '是', '5182020026');
INSERT INTO `shebeishiyongqingkuangbiao` VALUES ('51813', '电动吸引器', '是', '5182020032');
INSERT INTO `shebeishiyongqingkuangbiao` VALUES ('51901', '超声', '否', '5192020063');
INSERT INTO `shebeishiyongqingkuangbiao` VALUES ('51902', '超声', '否', '5192020043');
INSERT INTO `shebeishiyongqingkuangbiao` VALUES ('51905', '超声', '是', '5192020038');
INSERT INTO `shebeishiyongqingkuangbiao` VALUES ('52001', '心理测试系统', '是', '5202020018');
INSERT INTO `shebeishiyongqingkuangbiao` VALUES ('52002', '心理测试系统', '是', '5202020069');
INSERT INTO `shebeishiyongqingkuangbiao` VALUES ('52101', '医用气体设备', '是', '5212020054');
INSERT INTO `shebeishiyongqingkuangbiao` VALUES ('52102', '医用气体设备', '否', '5212020026');
INSERT INTO `shebeishiyongqingkuangbiao` VALUES ('52201', '光热治疗仪', '是', '5222020013');
INSERT INTO `shebeishiyongqingkuangbiao` VALUES ('52202', '光热治疗仪', '否', '5222020078');
INSERT INTO `shebeishiyongqingkuangbiao` VALUES ('52301', 'b超', '是', '5232020004');
INSERT INTO `shebeishiyongqingkuangbiao` VALUES ('52302', 'b超', '是', '5232020045');
INSERT INTO `shebeishiyongqingkuangbiao` VALUES ('52401', '疫苗', '是', '5242020028');
INSERT INTO `shebeishiyongqingkuangbiao` VALUES ('52402', '疫苗', '是', '5242020035');
INSERT INTO `shebeishiyongqingkuangbiao` VALUES ('52501', '激光治疗仪', '是', '5252020007');
INSERT INTO `shebeishiyongqingkuangbiao` VALUES ('52502', '激光治疗仪', '否', '5252020084');
INSERT INTO `shebeishiyongqingkuangbiao` VALUES ('52901', '无影灯', '否', '5292020009');
INSERT INTO `shebeishiyongqingkuangbiao` VALUES ('52902', '无影灯', '否', '5292020036');

-- ----------------------------
-- Table structure for siwanghuanzhebiao
-- ----------------------------
DROP TABLE IF EXISTS `siwanghuanzhebiao`;
CREATE TABLE `siwanghuanzhebiao`  (
  `xingming` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `xingbie` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `nianling` int(3) NULL DEFAULT NULL,
  `shenfenzhenghao` varchar(18) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `siwangshijian` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`shenfenzhenghao`) USING BTREE,
  CONSTRAINT `ten_six` FOREIGN KEY (`shenfenzhenghao`) REFERENCES `huanzherjibenxinxibiao` (`shenfenzhenghao`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Table structure for yihuanguanxibiao
-- ----------------------------
DROP TABLE IF EXISTS `yihuanguanxibiao`;
CREATE TABLE `yihuanguanxibiao`  (
  `huanzhehao` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `yishenggongzuozhenghao` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `yiyurenyuandegongzuoleixingdaihao` int(4) NULL DEFAULT NULL,
  PRIMARY KEY (`huanzhehao`) USING BTREE,
  INDEX `five_four`(`yishenggongzuozhenghao`) USING BTREE,
  CONSTRAINT `five_four` FOREIGN KEY (`yishenggongzuozhenghao`) REFERENCES `yiyuanrenyuanxinxibiao` (`yishenggongzuozhenghao`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `five_six` FOREIGN KEY (`huanzhehao`) REFERENCES `huanzherjibenxinxibiao` (`huanzhehao`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of yihuanguanxibiao
-- ----------------------------
INSERT INTO `yihuanguanxibiao` VALUES ('2212020001', '2212020001', 221);
INSERT INTO `yihuanguanxibiao` VALUES ('2212020021', '2212020002', 221);
INSERT INTO `yihuanguanxibiao` VALUES ('5112020003', '5112020001', 511);
INSERT INTO `yihuanguanxibiao` VALUES ('5122020001', '5122020001', 512);
INSERT INTO `yihuanguanxibiao` VALUES ('5122020002', '5122020001', 512);
INSERT INTO `yihuanguanxibiao` VALUES ('5132020034', '5132020001', 513);
INSERT INTO `yihuanguanxibiao` VALUES ('5132020094', '5132020001', 513);
INSERT INTO `yihuanguanxibiao` VALUES ('5142020020', '5142020001', 514);
INSERT INTO `yihuanguanxibiao` VALUES ('5142020045', '5142020001', 514);
INSERT INTO `yihuanguanxibiao` VALUES ('5152020005', '5152020002', 515);
INSERT INTO `yihuanguanxibiao` VALUES ('5152020021', '5152020002', 515);
INSERT INTO `yihuanguanxibiao` VALUES ('5162020006', '5162020003', 516);
INSERT INTO `yihuanguanxibiao` VALUES ('5162020013', '5162020003', 516);
INSERT INTO `yihuanguanxibiao` VALUES ('5172020012', '5172020004', 517);
INSERT INTO `yihuanguanxibiao` VALUES ('5172020056', '2102020002', 210);
INSERT INTO `yihuanguanxibiao` VALUES ('5182020026', '5182020001', 518);
INSERT INTO `yihuanguanxibiao` VALUES ('5182020032', '5182020001', 518);
INSERT INTO `yihuanguanxibiao` VALUES ('5192020038', '5192020002', 519);
INSERT INTO `yihuanguanxibiao` VALUES ('5192020043', '5192020002', 519);
INSERT INTO `yihuanguanxibiao` VALUES ('5192020063', '5192020002', 519);
INSERT INTO `yihuanguanxibiao` VALUES ('5202020018', '5202020001', 520);
INSERT INTO `yihuanguanxibiao` VALUES ('5202020069', '5202020001', 520);
INSERT INTO `yihuanguanxibiao` VALUES ('5212020026', '5212020001', 521);
INSERT INTO `yihuanguanxibiao` VALUES ('5212020054', '5212020001', 521);
INSERT INTO `yihuanguanxibiao` VALUES ('5222020013', '5222020003', 522);
INSERT INTO `yihuanguanxibiao` VALUES ('5222020078', '5222020003', 522);
INSERT INTO `yihuanguanxibiao` VALUES ('5232020004', '5232020001', 523);
INSERT INTO `yihuanguanxibiao` VALUES ('5232020045', '5232020001', 523);
INSERT INTO `yihuanguanxibiao` VALUES ('5242020028', '5242020001', 624);
INSERT INTO `yihuanguanxibiao` VALUES ('5242020035', '5242020001', 524);
INSERT INTO `yihuanguanxibiao` VALUES ('5252020007', '5252020003', 525);
INSERT INTO `yihuanguanxibiao` VALUES ('5252020084', '5252020003', 525);
INSERT INTO `yihuanguanxibiao` VALUES ('5292020009', '5292020005', 529);
INSERT INTO `yihuanguanxibiao` VALUES ('5292020036', '5292020005', 529);

-- ----------------------------
-- Table structure for yiyuanrenyuangongzuoqufenbiao
-- ----------------------------
DROP TABLE IF EXISTS `yiyuanrenyuangongzuoqufenbiao`;
CREATE TABLE `yiyuanrenyuangongzuoqufenbiao`  (
  `yiyuanrenyuandegongzuoleixingdaihao` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `jutigongzuoleixing` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`yiyuanrenyuandegongzuoleixingdaihao`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of yiyuanrenyuangongzuoqufenbiao
-- ----------------------------
INSERT INTO `yiyuanrenyuangongzuoqufenbiao` VALUES ('100', '综合医生');
INSERT INTO `yiyuanrenyuangongzuoqufenbiao` VALUES ('210', '中医');
INSERT INTO `yiyuanrenyuangongzuoqufenbiao` VALUES ('221', '腔肠');
INSERT INTO `yiyuanrenyuangongzuoqufenbiao` VALUES ('222', '骨伤');
INSERT INTO `yiyuanrenyuangongzuoqufenbiao` VALUES ('223', '针灸');
INSERT INTO `yiyuanrenyuangongzuoqufenbiao` VALUES ('511', '口腔');
INSERT INTO `yiyuanrenyuangongzuoqufenbiao` VALUES ('512', '眼科');
INSERT INTO `yiyuanrenyuangongzuoqufenbiao` VALUES ('513', '耳喉鼻');
INSERT INTO `yiyuanrenyuangongzuoqufenbiao` VALUES ('514', '肿瘤');
INSERT INTO `yiyuanrenyuangongzuoqufenbiao` VALUES ('515', '心血管');
INSERT INTO `yiyuanrenyuangongzuoqufenbiao` VALUES ('516', '胸腔');
INSERT INTO `yiyuanrenyuangongzuoqufenbiao` VALUES ('517', '血液');
INSERT INTO `yiyuanrenyuangongzuoqufenbiao` VALUES ('518', '妇产');
INSERT INTO `yiyuanrenyuangongzuoqufenbiao` VALUES ('519', '儿科');
INSERT INTO `yiyuanrenyuangongzuoqufenbiao` VALUES ('520', '精神科');
INSERT INTO `yiyuanrenyuangongzuoqufenbiao` VALUES ('521', '传染');
INSERT INTO `yiyuanrenyuangongzuoqufenbiao` VALUES ('522', '皮肤科');
INSERT INTO `yiyuanrenyuangongzuoqufenbiao` VALUES ('523', '结核');
INSERT INTO `yiyuanrenyuangongzuoqufenbiao` VALUES ('524', '麻风');
INSERT INTO `yiyuanrenyuangongzuoqufenbiao` VALUES ('525', '整形外科');
INSERT INTO `yiyuanrenyuangongzuoqufenbiao` VALUES ('529', '美容科');
INSERT INTO `yiyuanrenyuangongzuoqufenbiao` VALUES ('710', '护士');
INSERT INTO `yiyuanrenyuangongzuoqufenbiao` VALUES ('720', '护士长');

-- ----------------------------
-- Table structure for yiyuanrenyuanxinxibiao
-- ----------------------------
DROP TABLE IF EXISTS `yiyuanrenyuanxinxibiao`;
CREATE TABLE `yiyuanrenyuanxinxibiao`  (
  `yishenggongzuozhenghao` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `xingming` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `xingbie` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `nianling` int(3) NOT NULL,
  `dianhua` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `shifoudushengzinv` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `shifoudangyuan` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `gongzuonianling` int(2) NOT NULL,
  `yiyuanrenyuandegongzuoleixingdaihao` varchar(4) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  PRIMARY KEY (`yishenggongzuozhenghao`) USING BTREE,
  INDEX `three_four`(`yiyuanrenyuandegongzuoleixingdaihao`) USING BTREE,
  CONSTRAINT `three_four` FOREIGN KEY (`yiyuanrenyuandegongzuoleixingdaihao`) REFERENCES `yiyuanrenyuangongzuoqufenbiao` (`yiyuanrenyuandegongzuoleixingdaihao`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of yiyuanrenyuanxinxibiao
-- ----------------------------
INSERT INTO `yiyuanrenyuanxinxibiao` VALUES ('1002020001', '王长根', '男', 35, '18874051001', '是', '是', 18, '100');
INSERT INTO `yiyuanrenyuanxinxibiao` VALUES ('1002020002', '肖长文', '男', 34, '18874051002', '否', '否', 15, '100');
INSERT INTO `yiyuanrenyuanxinxibiao` VALUES ('2102020001', '苏红卫', '男', 36, '18874051003', '是', '否', 17, '210');
INSERT INTO `yiyuanrenyuanxinxibiao` VALUES ('2102020002', '陶清风', '男', 45, '18874051004', '否', '是', 20, '210');
INSERT INTO `yiyuanrenyuanxinxibiao` VALUES ('2212020001', '赵福彩', '女', 38, '18874051005', '是', '是', 18, '221');
INSERT INTO `yiyuanrenyuanxinxibiao` VALUES ('2212020002', '杨敏节', '男', 47, '18874051006', '是', '是', 27, '221');
INSERT INTO `yiyuanrenyuanxinxibiao` VALUES ('2222020001', '梁峰', '男', 33, '18874051007', '否', '否', 13, '222');
INSERT INTO `yiyuanrenyuanxinxibiao` VALUES ('2222020002', '张敏', '女', 32, '18874951008', '是', '否', 12, '222');
INSERT INTO `yiyuanrenyuanxinxibiao` VALUES ('2232020001', '戴博', '男', 41, '18874051010', '是', '是', 21, '223');
INSERT INTO `yiyuanrenyuanxinxibiao` VALUES ('2232020002', '黄志强', '男', 35, '18874051011', '否', '否', 15, '223');
INSERT INTO `yiyuanrenyuanxinxibiao` VALUES ('5112020001', '李亚军', '男', 23, '18874051012', '是', '是', 2, '511');
INSERT INTO `yiyuanrenyuanxinxibiao` VALUES ('5122020001', '韩正', '女', 25, '18874051020', '否', '否', 3, '512');
INSERT INTO `yiyuanrenyuanxinxibiao` VALUES ('5132020001', '马军', '男', 27, '18874051021', '是', '是', 6, '513');
INSERT INTO `yiyuanrenyuanxinxibiao` VALUES ('5142020001', '赵健航', '男', 29, '18874035001', '是', '是', 7, '514');
INSERT INTO `yiyuanrenyuanxinxibiao` VALUES ('5152020002', '谭玉彬', '男', 48, '18874051029', '否', '是', 26, '515');
INSERT INTO `yiyuanrenyuanxinxibiao` VALUES ('5162020003', '钟发更', '男', 50, '18874051093', '是', '是', 28, '516');
INSERT INTO `yiyuanrenyuanxinxibiao` VALUES ('5172020004', '郭占农', '男', 35, '18874051023', '是', '是', 12, '517');
INSERT INTO `yiyuanrenyuanxinxibiao` VALUES ('5182020001', '李静', '女', 25, '18874930004', '是', '否', 3, '518');
INSERT INTO `yiyuanrenyuanxinxibiao` VALUES ('5192020002', '唐红', '女', 26, '18890450003', '是', '是', 4, '519');
INSERT INTO `yiyuanrenyuanxinxibiao` VALUES ('5202020001', '胡蕴华', '女', 30, '18874937654', '是', '是', 8, '520');
INSERT INTO `yiyuanrenyuanxinxibiao` VALUES ('5212020001', '尚海风', '男', 31, '17790453689', '否', '是', 9, '521');
INSERT INTO `yiyuanrenyuanxinxibiao` VALUES ('5222020003', '陈专', '男', 29, '18874051095', '是', '是', 8, '522');
INSERT INTO `yiyuanrenyuanxinxibiao` VALUES ('5232020001', '龙永', '男', 38, '18874038934', '是', '是', 16, '523');
INSERT INTO `yiyuanrenyuanxinxibiao` VALUES ('5242020001', '许明明', '男', 34, '18934567833', '是', '是', 12, '524');
INSERT INTO `yiyuanrenyuanxinxibiao` VALUES ('5252020003', '李健', '男', 23, '18874051098', '是', '否', 1, '525');
INSERT INTO `yiyuanrenyuanxinxibiao` VALUES ('5292020005', '胡新文', '女', 27, '18894005001', '是', '是', 5, '529');
INSERT INTO `yiyuanrenyuanxinxibiao` VALUES ('7102020005', '严冬雪', '女', 25, '13390209004', '是', '是', 3, '710');
INSERT INTO `yiyuanrenyuanxinxibiao` VALUES ('7202020001', '韩梦', '女', 38, '17789023421', '否', 'f否', 16, '720');

-- ----------------------------
-- Table structure for zhiyuhuanzhebiao
-- ----------------------------
DROP TABLE IF EXISTS `zhiyuhuanzhebiao`;
CREATE TABLE `zhiyuhuanzhebiao`  (
  `xingming` varchar(3) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `xingbie` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `nianling` int(3) NULL DEFAULT NULL,
  `shenfenzhenghao` varchar(18) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `zhiyushijian` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `lianxidianhua` varchar(11) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  PRIMARY KEY (`shenfenzhenghao`) USING BTREE,
  CONSTRAINT `nine_six` FOREIGN KEY (`shenfenzhenghao`) REFERENCES `huanzherjibenxinxibiao` (`shenfenzhenghao`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;

SET FOREIGN_KEY_CHECKS = 1;
