/*
MySQL Data Transfer
Source Host: localhost
Source Database: medical_monitor
Target Host: localhost
Target Database: medical_monitor
Date: 2020/7/29 17:04:27
*/
SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for device
-- ----------------------------
CREATE TABLE `device` (
`dev_id` int(11) NOT NULL auto_increment,
`serial` varchar(16) default NULL,
`refresh` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
PRIMARY KEY (`dev_id`),
UNIQUE KEY `serial` (`serial`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for device_patient
-- ----------------------------
CREATE TABLE `device_patient` (
`dev_id` int(11) default NULL,
`patient_id` int(11) NOT NULL,
`time` timestamp NOT NULL default CURRENT_TIMESTAMP,
PRIMARY KEY (`patient_id`),
KEY `fk_device` (`dev_id`),
CONSTRAINT `fk_device` FOREIGN KEY (`dev_id`) REFERENCES `device` (`dev_id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `fk_patient` FOREIGN KEY (`patient_id`) REFERENCES `patient` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for doctor
-- ----------------------------
CREATE TABLE `doctor` (
`uid` varchar(10) NOT NULL default '',
`name` varchar(255) default NULL,
`mobile` binary(11) default NULL,
`password` binary(6) default NULL,
PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for ecg_sample
-- ----------------------------
CREATE TABLE `ecg_sample` (
`value` varbinary(1000) NOT NULL,
`time` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`dev_id` int(11) default NULL,
KEY `fk_sample_device` (`dev_id`),
CONSTRAINT `fk_sample_device` FOREIGN KEY (`dev_id`) REFERENCES `device` (`dev_id`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Table structure for patient
-- ----------------------------
CREATE TABLE `patient` (
`id` int(11) NOT NULL auto_increment,
`name` char(5) NOT NULL,
`sex` char(1) default NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
-- ----------------------------
-- Records
-- ----------------------------
INSERT INTO `device` VALUES ('1', 'DEV-001', '2020-07-26 17:31:27');
INSERT INTO `device` VALUES ('2', 'DEV-002', '2020-07-27 12:08:46');
INSERT INTO `device` VALUES ('3', 'DEV-003', '2020-07-26 17:31:40');
INSERT INTO `device` VALUES ('4', 'DEV-004', '2020-07-26 17:32:13');
INSERT INTO `device_patient` VALUES (null, '1', '2020-07-23 16:11:52');
INSERT INTO `device_patient` VALUES ('2', '2', '2020-07-23 16:07:55');
INSERT INTO `device_patient` VALUES (null, '3', '2020-07-23 16:08:21');
INSERT INTO `device_patient` VALUES ('3', '4', '2020-07-27 12:17:47');
INSERT INTO `device_patient` VALUES (null, '5', '2020-07-27 12:18:38');
INSERT INTO `device_patient` VALUES ('1', '6', '2020-07-27 12:18:42');
INSERT INTO `device_patient` VALUES (null, '7', '2020-07-27 12:18:44');
INSERT INTO `device_patient` VALUES (null, '8', '2020-07-27 12:18:48');
INSERT INTO `device_patient` VALUES ('4', '9', '2020-07-27 13:24:36');
INSERT INTO `doctor` VALUES ('0', 'demo', '11111111111', '0');
INSERT INTO `doctor` VALUES ('1', 'å¹³ä¸æ', '13100000001', '000001');
INSERT INTO `doctor` VALUES ('2', 'è¡éç', '13100000002', '000002');
INSERT INTO `doctor` VALUES ('3', 'ç°è´è´', '15045110578', '990210');
INSERT INTO `ecg_sample` VALUES ('2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,\r\n2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,\r\n2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,\r\n2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,\r\n2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,\r\n2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,\r\n2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,\r\n2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,\r\n2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,\r\n2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,\r\n2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,\r\n2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,\r\n2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,\r\n2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,\r\n2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,\r\n2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,\r\n2000, 2000, 2000, 2000, 2000, 2000, 2000, ', '2020-07-27 13:53:27', null);
INSERT INTO `ecg_sample` VALUES ('', '2020-07-27 14:36:23', null);
INSERT INTO `ecg_sample` VALUES ('0', '2020-07-27 14:52:32', null);
INSERT INTO `ecg_sample` VALUES ('0', '2020-07-27 14:52:37', null);
INSERT INTO `ecg_sample` VALUES ('0', '2020-07-27 14:52:39', null);
INSERT INTO `ecg_sample` VALUES ('2000', '2020-07-27 15:01:45', null);
INSERT INTO `ecg_sample` VALUES ('2000', '2020-07-27 15:02:22', null);
INSERT INTO `ecg_sample` VALUES ('2000,2000', '2020-07-27 15:02:42', null);
INSERT INTO `ecg_sample` VALUES ('2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,2000, 2000, 200', '2020-07-27 15:10:36', null);
INSERT INTO `ecg_sample` VALUES ('2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000, 2000,2000, 2000, 200', '2020-07-27 15:14:31', null);
INSERT INTO `ecg_sample` VALUES ('2000', '2020-07-27 15:18:09', null);
INSERT INTO `ecg_sample` VALUES ('2000', '2020-07-27 15:22:20', null);
INSERT INTO `ecg_sample` VALUES ('2000', '2020-07-27 15:28:24', null);
INSERT INTO `ecg_sample` VALUES ('Ð', '2020-07-28 20:17:07', null);
INSERT INTO `ecg_sample` VALUES ('ÐÐÐÐÐÐÐÐÐÐ', '2020-07-28 20:18:46', null);
INSERT INTO `ecg_sample` VALUES ('ÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐÐ
基于Linux操作系统，嵌入arm，交叉编译实现的生命特征监护仪源码
版权申诉
87 浏览量
2024-01-20
21:27:47
上传
评论
收藏 2.59MB ZIP 举报
scsx-master.zip （4个子文件） 
scsx-master 
Documents.rar 10KB
medical_monitor.sql 382KB chaunkou - 副本.rar 11KB WorkStation.rar 2.58MB资源评论
