-
Notifications
You must be signed in to change notification settings - Fork 5
/
Copy pathcds.sql
41 lines (30 loc) · 12.2 KB
/
cds.sql
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
/*
SQLyog Community v8.4 Beta2
MySQL - 5.5.12 : Database - cds
*********************************************************************
*/
/*!40101 SET NAMES utf8 */;
/*!40101 SET SQL_MODE=''*/;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
CREATE DATABASE /*!32312 IF NOT EXISTS*/`cds` /*!40100 DEFAULT CHARACTER SET latin1 */;
USE `cds`;
/*Table structure for table `cds_store` */
DROP TABLE IF EXISTS `cds_store`;
CREATE TABLE `cds_store` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`destination` varchar(45) NOT NULL,
`message` blob NOT NULL,
`voided` tinyint(1) NOT NULL,
`received_datetime` datetime NOT NULL,
`voided_datetime` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
/*Data for the table `cds_store` */
insert into `cds_store`(`id`,`destination`,`message`,`voided`,`received_datetime`,`voided_datetime`) values (1,'ke.go.moh.facility.14080.tb.reception','<?xml version=\"1.0\" encoding=\"utf-8\" standalone=\"no\"?>\r\n<PRPA_IN201302UV02 xmlns=\"urn:hl7-org:v3\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" ITSVersion=\"XML_1.0\" xsi:schemaLocation=\"urn:hl7-org:v3 ../../schema/HL7V3/NE2008/multicacheschemas/PRPA_IN201311UV.xsd\">\r\n <id extension=\"13160650464701\" root=\"1.3.6.1.4.1.150.2474.11.1.1\"/>\r\n <creationTime value=\"201101010930\"/>\r\n <interactionId extension=\"PRPA_IN201302UV02\" root=\"2.16.840.1.113883.1.6\"/>\r\n <processingCode code=\"P\"/>\r\n <processingModeCode code=\"T\"/>\r\n <acceptAckCode code=\"NE\"/>\r\n <receiver typeCode=\"RCV\">\r\n <device classCode=\"DEV\" determinerCode=\"INSTANCE\">\r\n <id extension=\"ke.go.moh.facility.14080.cds\" root=\"1.3.6.1.4.1.150.2474.11.1.2\"/>\r\n <name>Clinical Document Store</name>\r\n </device>\r\n </receiver>\r\n <sender>\r\n <device classCode=\"DEV\" determinerCode=\"INSTANCE\">\r\n <id extension=\"ke.go.moh.facility.14080.tb.reception\" root=\"1.3.6.1.4.1.150.2474.11.1.2\"/>\r\n <name>Cds Test application </name>\r\n </device>\r\n </sender>\r\n <controlActProcess classCode=\"CACT\" moodCode=\"EVN\">\r\n <code code=\"PRPA_TE201302UV02\" codeSystem=\"2.16.840.1.113883.1.6\"/>\r\n <subject typeCode=\"SUBJ\">\r\n <registrationEvent classCode=\"REG\" moodCode=\"EVN\">\r\n <id nullFlavor=\"NA\"/>\r\n <statusCode code=\"active\"/>\r\n <subject1 typeCode=\"SBJ\">\r\n <patient classCode=\"PAT\">\r\n <statusCode code=\"active\"/>\r\n <patientPerson>\r\n <name>\r\n <given>Harry</given>\r\n <given>Kimani</given>\r\n <family>Thuku</family>\r\n </name>\r\n <administrativeGenderCode code=\"M\"/>\r\n <deceasedTime value=\"20110601\"/>\r\n <id extension=\"no\" root=\"1.3.6.1.4.1.150.2474.11.1.4.3\"/>\r\n <id extension=\"12945-12345/2010\" root=\"1.3.6.1.4.1.150.2474.11.1.5.4\"/>\r\n <id extension=\"ke.go.moh.facility.14080.tb.reception\" root=\"1.3.6.1.4.1.150.2474.11.1.6.1\"/>\r\n <id extension=\"20110915\" root=\"1.3.6.1.4.1.150.2474.11.1.6.2\"/>\r\n </patientPerson>\r\n </patient>\r\n </subject1>\r\n </registrationEvent>\r\n </subject>\r\n </controlActProcess>\r\n</PRPA_IN201302UV02>\r\n',0,'2011-09-15 08:37:26',NULL),(2,'ke.go.moh.facility.14080.tb.reception','<?xml version=\"1.0\" encoding=\"utf-8\" standalone=\"no\"?>\r\n<PRPA_IN201302UV02 xmlns=\"urn:hl7-org:v3\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" ITSVersion=\"XML_1.0\" xsi:schemaLocation=\"urn:hl7-org:v3 ../../schema/HL7V3/NE2008/multicacheschemas/PRPA_IN201311UV.xsd\">\r\n <id extension=\"13605756141392\" root=\"1.3.6.1.4.1.150.2474.11.1.1\"/>\r\n <creationTime value=\"201101010930\"/>\r\n <interactionId extension=\"PRPA_IN201302UV02\" root=\"2.16.840.1.113883.1.6\"/>\r\n <processingCode code=\"P\"/>\r\n <processingModeCode code=\"T\"/>\r\n <acceptAckCode code=\"NE\"/>\r\n <receiver typeCode=\"RCV\">\r\n <device classCode=\"DEV\" determinerCode=\"INSTANCE\">\r\n <id extension=\"ke.go.moh.facility.14080.cds\" root=\"1.3.6.1.4.1.150.2474.11.1.2\"/>\r\n <name>Clinical Document Store</name>\r\n </device>\r\n </receiver>\r\n <sender>\r\n <device classCode=\"DEV\" determinerCode=\"INSTANCE\">\r\n <id extension=\"ke.go.moh.mpi\" root=\"1.3.6.1.4.1.150.2474.11.1.2\"/>\r\n <name>Master Person Index</name>\r\n </device>\r\n </sender>\r\n <controlActProcess classCode=\"CACT\" moodCode=\"EVN\">\r\n <code code=\"PRPA_TE201302UV02\" codeSystem=\"2.16.840.1.113883.1.6\"/>\r\n <subject typeCode=\"SUBJ\">\r\n <registrationEvent classCode=\"REG\" moodCode=\"EVN\">\r\n <id nullFlavor=\"NA\"/>\r\n <statusCode code=\"active\"/>\r\n <subject1 typeCode=\"SBJ\">\r\n <patient classCode=\"PAT\">\r\n <id extension=\"628d2acc-fa4a-11e0-b4b3-001e101f6c46\" root=\"1.3.6.1.4.1.150.2474.11.1.5.1\"/>\r\n <statusCode code=\"active\"/>\r\n <patientPerson>\r\n <name>\r\n <given>JAMES</given>\r\n <given>ODUOR</given>\r\n <family>OTIENO</family>\r\n </name>\r\n <administrativeGenderCode code=\"M\"/>\r\n <birthTime value=\"19830715\"/>\r\n <id extension=\"Jimmy Jam\" root=\"1.3.6.1.4.1.150.2474.11.1.4.1\"/>\r\n <id extension=\"Some clan name\" root=\"1.3.6.1.4.1.150.2474.11.1.4.2\"/>\r\n <id extension=\"single\" root=\"1.3.6.1.4.1.150.2474.11.1.4.13\"/>\r\n <id extension=\"yes\" root=\"1.3.6.1.4.1.150.2474.11.1.4.14\"/>\r\n <id extension=\"Obunga\" root=\"1.3.6.1.4.1.150.2474.11.1.4.15\"/>\r\n <id extension=\"Kenya Re\" root=\"1.3.6.1.4.1.150.2474.11.1.4.16\"/>\r\n <id extension=\"20130210\" root=\"1.3.6.1.4.1.150.2474.11.1.4.17\"/>\r\n <id extension=\"12345-67890\" root=\"1.3.6.1.4.1.150.2474.11.1.5.4\"/>\r\n <id extension=\"1-1-1-1\" root=\"1.3.6.1.4.1.150.2474.11.1.5.5\"/>\r\n <id extension=\"20130211\" root=\"1.3.6.1.4.1.150.2474.11.1.6.1.1\"/>\r\n <id extension=\"ke.go.moh.facility.14080.tb.reception\" root=\"1.3.6.1.4.1.150.2474.11.1.6.1.2\"/>\r\n <id extension=\"Siaya District Hospital\" root=\"1.3.6.1.4.1.150.2474.11.1.6.1.3\"/>\r\n </patientPerson>\r\n </patient>\r\n </subject1>\r\n </registrationEvent>\r\n </subject>\r\n </controlActProcess>\r\n</PRPA_IN201302UV02>\r\n',0,'2013-02-11 12:40:15',NULL),(3,'ke.go.moh.facility.14080.tb.reception','<?xml version=\"1.0\" encoding=\"utf-8\" standalone=\"no\"?>\r\n<PRPA_IN201302UV02 xmlns=\"urn:hl7-org:v3\" xmlns:xsi=\"http://www.w3.org/2001/XMLSchema-instance\" ITSVersion=\"XML_1.0\" xsi:schemaLocation=\"urn:hl7-org:v3 ../../schema/HL7V3/NE2008/multicacheschemas/PRPA_IN201311UV.xsd\">\r\n <id extension=\"13605884957332\" root=\"1.3.6.1.4.1.150.2474.11.1.1\"/>\r\n <creationTime value=\"201101010930\"/>\r\n <interactionId extension=\"PRPA_IN201302UV02\" root=\"2.16.840.1.113883.1.6\"/>\r\n <processingCode code=\"P\"/>\r\n <processingModeCode code=\"T\"/>\r\n <acceptAckCode code=\"NE\"/>\r\n <receiver typeCode=\"RCV\">\r\n <device classCode=\"DEV\" determinerCode=\"INSTANCE\">\r\n <id extension=\"ke.go.moh.facility.14080.cds\" root=\"1.3.6.1.4.1.150.2474.11.1.2\"/>\r\n <name>Clinical Document Store</name>\r\n </device>\r\n </receiver>\r\n <sender>\r\n <device classCode=\"DEV\" determinerCode=\"INSTANCE\">\r\n <id extension=\"ke.go.moh.mpi\" root=\"1.3.6.1.4.1.150.2474.11.1.2\"/>\r\n <name>Master Person Index</name>\r\n </device>\r\n </sender>\r\n <controlActProcess classCode=\"CACT\" moodCode=\"EVN\">\r\n <code code=\"PRPA_TE201302UV02\" codeSystem=\"2.16.840.1.113883.1.6\"/>\r\n <subject typeCode=\"SUBJ\">\r\n <registrationEvent classCode=\"REG\" moodCode=\"EVN\">\r\n <id nullFlavor=\"NA\"/>\r\n <statusCode code=\"active\"/>\r\n <subject1 typeCode=\"SBJ\">\r\n <patient classCode=\"PAT\">\r\n <id extension=\"628d2acc-fa4a-11e0-b4b3-001e101f6c46\" root=\"1.3.6.1.4.1.150.2474.11.1.5.1\"/>\r\n <statusCode code=\"active\"/>\r\n <patientPerson>\r\n <name>\r\n <given>JAMES</given>\r\n <given>ODUOR</given>\r\n <family>OTIENO</family>\r\n </name>\r\n <administrativeGenderCode code=\"M\"/>\r\n <birthTime value=\"19830715\"/>\r\n <id extension=\"Jimmy Jam\" root=\"1.3.6.1.4.1.150.2474.11.1.4.1\"/>\r\n <id extension=\"Some clan name\" root=\"1.3.6.1.4.1.150.2474.11.1.4.2\"/>\r\n <id extension=\"\" root=\"1.3.6.1.4.1.150.2474.11.1.4.4\"/>\r\n <id extension=\"\" root=\"1.3.6.1.4.1.150.2474.11.1.4.5\"/>\r\n <id extension=\"\" root=\"1.3.6.1.4.1.150.2474.11.1.4.6\"/>\r\n <id extension=\"\" root=\"1.3.6.1.4.1.150.2474.11.1.4.7\"/>\r\n <id extension=\"\" root=\"1.3.6.1.4.1.150.2474.11.1.4.8\"/>\r\n <id extension=\"\" root=\"1.3.6.1.4.1.150.2474.11.1.4.9\"/>\r\n <id extension=\"\" root=\"1.3.6.1.4.1.150.2474.11.1.4.10\"/>\r\n <id extension=\"\" root=\"1.3.6.1.4.1.150.2474.11.1.4.11\"/>\r\n <id extension=\"\" root=\"1.3.6.1.4.1.150.2474.11.1.4.12\"/>\r\n <id extension=\"single\" root=\"1.3.6.1.4.1.150.2474.11.1.4.13\"/>\r\n <id extension=\"yes\" root=\"1.3.6.1.4.1.150.2474.11.1.4.14\"/>\r\n <id extension=\"OBUNGA\" root=\"1.3.6.1.4.1.150.2474.11.1.4.15\"/>\r\n <id extension=\"20130608\" root=\"1.3.6.1.4.1.150.2474.11.1.4.18\"/>\r\n <id extension=\"12345-67890\" root=\"1.3.6.1.4.1.150.2474.11.1.5.4\"/>\r\n <id extension=\"1-1-1-1\" root=\"1.3.6.1.4.1.150.2474.11.1.5.5\"/>\r\n <id extension=\"20130211\" root=\"1.3.6.1.4.1.150.2474.11.1.6.1.1\"/>\r\n <id extension=\"ke.go.moh.facility.14080.tb.reception\" root=\"1.3.6.1.4.1.150.2474.11.1.6.1.2\"/>\r\n <id extension=\"Siaya District Hospital\" root=\"1.3.6.1.4.1.150.2474.11.1.6.1.3\"/>\r\n </patientPerson>\r\n </patient>\r\n </subject1>\r\n </registrationEvent>\r\n </subject>\r\n </controlActProcess>\r\n</PRPA_IN201302UV02>\r\n',0,'2013-02-11 16:14:58',NULL);
/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;