[507] | 1 | -- MySQL dump 10.11
|
---|
| 2 | --
|
---|
| 3 | -- Host: localhost Database: aggregator
|
---|
| 4 | -- ------------------------------------------------------
|
---|
| 5 | -- Server version 5.0.51b-community-nt
|
---|
| 6 |
|
---|
| 7 | /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
|
---|
| 8 | /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
|
---|
| 9 | /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
|
---|
| 10 | /*!40101 SET NAMES utf8 */;
|
---|
| 11 | /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
|
---|
| 12 | /*!40103 SET TIME_ZONE='+00:00' */;
|
---|
| 13 | /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
|
---|
| 14 | /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
|
---|
| 15 | /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
|
---|
| 16 | /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
|
---|
| 17 |
|
---|
| 18 | --
|
---|
| 19 | -- Current Database: `aggregator`
|
---|
| 20 | --
|
---|
| 21 |
|
---|
| 22 | CREATE DATABASE /*!32312 IF NOT EXISTS*/ `aggregator` /*!40100 DEFAULT CHARACTER SET latin1 */;
|
---|
| 23 |
|
---|
| 24 | USE `aggregator`;
|
---|
| 25 |
|
---|
| 26 | --
|
---|
| 27 | -- Table structure for table `agg_message_results`
|
---|
| 28 | --
|
---|
| 29 |
|
---|
| 30 | DROP TABLE IF EXISTS `agg_message_results`;
|
---|
| 31 | SET @saved_cs_client = @@character_set_client;
|
---|
| 32 | SET character_set_client = utf8;
|
---|
| 33 | CREATE TABLE `agg_message_results` (
|
---|
| 34 | `MessageId` varchar(32) NOT NULL COMMENT 'This will be a UUID.',
|
---|
| 35 | `TransactionId` varchar(32) NOT NULL COMMENT 'This will be a UUID. - Foreign Key to the agg_transaction table.',
|
---|
| 36 | `MessageKey` varchar(1000) NOT NULL COMMENT 'This is the key used to tie the response to the original request.',
|
---|
| 37 | `MessageOutTime` datetime default NULL COMMENT 'This is the date/time when the outbound request was recorded. Format of YYYYMMDDHHMMSS',
|
---|
| 38 | `ResponseReceivedTime` datetime default NULL COMMENT 'This is the date/time when the response was recorded. Format of YYYYMMDDHHMMSS',
|
---|
| 39 | `ResponseMessageType` varchar(100) default NULL COMMENT 'This is the name of the outer layer JAXB class for the response message.',
|
---|
| 40 | `ResponseMessage` longtext COMMENT 'The response message in XML - Based on marshalling using JAXB',
|
---|
| 41 | PRIMARY KEY (`MessageId`)
|
---|
| 42 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
---|
| 43 | SET character_set_client = @saved_cs_client;
|
---|
| 44 |
|
---|
| 45 | --
|
---|
| 46 | -- Dumping data for table `agg_message_results`
|
---|
| 47 | --
|
---|
| 48 |
|
---|
| 49 | LOCK TABLES `agg_message_results` WRITE;
|
---|
| 50 | /*!40000 ALTER TABLE `agg_message_results` DISABLE KEYS */;
|
---|
| 51 | /*!40000 ALTER TABLE `agg_message_results` ENABLE KEYS */;
|
---|
| 52 | UNLOCK TABLES;
|
---|
| 53 |
|
---|
| 54 | --
|
---|
| 55 | -- Table structure for table `agg_transaction`
|
---|
| 56 | --
|
---|
| 57 |
|
---|
| 58 | DROP TABLE IF EXISTS `agg_transaction`;
|
---|
| 59 | SET @saved_cs_client = @@character_set_client;
|
---|
| 60 | SET character_set_client = utf8;
|
---|
| 61 | CREATE TABLE `agg_transaction` (
|
---|
| 62 | `TransactionId` varchar(32) NOT NULL COMMENT 'This will be a UUID',
|
---|
| 63 | `ServiceType` varchar(64) NOT NULL,
|
---|
| 64 | `TransactionStartTime` datetime default NULL COMMENT 'Format of YYYYMMDDHHMMSS',
|
---|
| 65 | PRIMARY KEY (`TransactionId`)
|
---|
| 66 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
---|
| 67 | SET character_set_client = @saved_cs_client;
|
---|
| 68 |
|
---|
| 69 | --
|
---|
| 70 | -- Dumping data for table `agg_transaction`
|
---|
| 71 | --
|
---|
| 72 |
|
---|
| 73 | LOCK TABLES `agg_transaction` WRITE;
|
---|
| 74 | /*!40000 ALTER TABLE `agg_transaction` DISABLE KEYS */;
|
---|
| 75 | /*!40000 ALTER TABLE `agg_transaction` ENABLE KEYS */;
|
---|
| 76 | UNLOCK TABLES;
|
---|
| 77 |
|
---|
| 78 | --
|
---|
| 79 | -- Current Database: `assigningauthoritydb`
|
---|
| 80 | --
|
---|
| 81 |
|
---|
| 82 | CREATE DATABASE /*!32312 IF NOT EXISTS*/ `assigningauthoritydb` /*!40100 DEFAULT CHARACTER SET latin1 */;
|
---|
| 83 |
|
---|
| 84 | USE `assigningauthoritydb`;
|
---|
| 85 |
|
---|
| 86 | --
|
---|
| 87 | -- Table structure for table `assigningauthoritytohomecommunitymapping`
|
---|
| 88 | --
|
---|
| 89 |
|
---|
| 90 | DROP TABLE IF EXISTS `assigningauthoritytohomecommunitymapping`;
|
---|
| 91 | SET @saved_cs_client = @@character_set_client;
|
---|
| 92 | SET character_set_client = utf8;
|
---|
| 93 | CREATE TABLE `assigningauthoritytohomecommunitymapping` (
|
---|
| 94 | `id` int(10) unsigned NOT NULL auto_increment,
|
---|
| 95 | `assigningauthorityid` varchar(45) NOT NULL,
|
---|
| 96 | `homecommunityid` varchar(45) NOT NULL,
|
---|
| 97 | PRIMARY KEY (`id`,`assigningauthorityid`)
|
---|
| 98 | ) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=latin1;
|
---|
| 99 | SET character_set_client = @saved_cs_client;
|
---|
| 100 |
|
---|
| 101 | --
|
---|
| 102 | -- Dumping data for table `assigningauthoritytohomecommunitymapping`
|
---|
| 103 | --
|
---|
| 104 |
|
---|
| 105 | LOCK TABLES `assigningauthoritytohomecommunitymapping` WRITE;
|
---|
| 106 | /*!40000 ALTER TABLE `assigningauthoritytohomecommunitymapping` DISABLE KEYS */;
|
---|
| 107 | INSERT INTO `assigningauthoritytohomecommunitymapping` VALUES (1,'1.1','1.2.3.4.55.500'),(2,'1.2','1.2.3.4.55.501'),(3,'1.3','2.16.840.1.113883.3.200'),(4,'1.4','2.16.840.1.113883.3.198'),(5,'1.5','2.16.840.1.113883.3.184');
|
---|
| 108 | /*!40000 ALTER TABLE `assigningauthoritytohomecommunitymapping` ENABLE KEYS */;
|
---|
| 109 | UNLOCK TABLES;
|
---|
| 110 |
|
---|
| 111 | --
|
---|
| 112 | -- Current Database: `auditrepo`
|
---|
| 113 | --
|
---|
| 114 |
|
---|
| 115 | CREATE DATABASE /*!32312 IF NOT EXISTS*/ `auditrepo` /*!40100 DEFAULT CHARACTER SET latin1 */;
|
---|
| 116 |
|
---|
| 117 | USE `auditrepo`;
|
---|
| 118 |
|
---|
| 119 | --
|
---|
| 120 | -- Table structure for table `auditrepository`
|
---|
| 121 | --
|
---|
| 122 |
|
---|
| 123 | DROP TABLE IF EXISTS `auditrepository`;
|
---|
| 124 | SET @saved_cs_client = @@character_set_client;
|
---|
| 125 | SET character_set_client = utf8;
|
---|
| 126 | CREATE TABLE `auditrepository` (
|
---|
| 127 | `id` bigint(20) NOT NULL auto_increment,
|
---|
| 128 | `timestamp` datetime default NULL,
|
---|
| 129 | `eventId` bigint(20) NOT NULL,
|
---|
| 130 | `userId` varchar(100) default NULL,
|
---|
| 131 | `participationTypeCode` smallint(6) default NULL,
|
---|
| 132 | `participationTypeCodeRole` smallint(6) default NULL,
|
---|
| 133 | `participationIDTypeCode` varchar(100) default NULL,
|
---|
| 134 | `receiverPatientId` varchar(100) default NULL,
|
---|
| 135 | `senderPatientId` varchar(100) default NULL,
|
---|
| 136 | `communityId` varchar(255) default NULL,
|
---|
| 137 | `messageType` varchar(100) NOT NULL,
|
---|
| 138 | `message` blob,
|
---|
| 139 | PRIMARY KEY (`id`),
|
---|
| 140 | UNIQUE KEY `UQ_eventlog_id` (`id`)
|
---|
| 141 | ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
|
---|
| 142 | SET character_set_client = @saved_cs_client;
|
---|
| 143 |
|
---|
| 144 | --
|
---|
| 145 | -- Dumping data for table `auditrepository`
|
---|
| 146 | --
|
---|
| 147 |
|
---|
| 148 | LOCK TABLES `auditrepository` WRITE;
|
---|
| 149 | /*!40000 ALTER TABLE `auditrepository` DISABLE KEYS */;
|
---|
| 150 | INSERT INTO `auditrepository` VALUES (1,'2009-02-20 13:18:44',0,'Alexandra Rodriquez',1,1,'2','65456^^^&2.16.840.1.113883.3.192&ISO',NULL,'2.16.840.1.113883.3.192','logAdhocQueryRequest','<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?><AuditMessage xmlns=\"http://nhinc.services.com/schema/auditmessage\"><EventIdentification EventOutcomeIndicator=\"0\" EventDateTime=\"2009-02-20T18:18:44.671Z\" EventActionCode=\"E\"><EventID codeSystemName=\"DCM\" codeSystem=\"Query\" displayName=\"Query\" code=\"DCM\"/></EventIdentification><ActiveParticipant NetworkAccessPointTypeCode=\"2\" NetworkAccessPointID=\"192.168.101.137\" UserIsRequestor=\"true\" UserName=\"Alexandra Rodriquez\" UserID=\"Alexandra Rodriquez\"/><AuditSourceIdentification AuditSourceID=\"2.16.840.1.113883.3.192\" AuditEnterpriseSiteID=\"Cleveland Clinic\"/><ParticipantObjectIdentification ParticipantObjectTypeCodeRole=\"1\" ParticipantObjectTypeCode=\"1\" ParticipantObjectID=\"65456\"><ParticipantObjectIDTypeCode code=\"2\"/><ParticipantObjectQuery>PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiIHN0YW5kYWxvbmU9InllcyI/PjxBZGhvY1F1ZXJ5UmVxdWVzdCB4bWxucz0idXJuOm9hc2lzOm5hbWVzOnRjOmVieG1sLXJlZ3JlcDp4c2Q6cXVlcnk6My4wIiB4bWxuczpuczI9InVybjpvYXNpczpuYW1lczp0YzplYnhtbC1yZWdyZXA6eHNkOnJpbTozLjAiIHhtbG5zOm5zMz0idXJuOm9hc2lzOm5hbWVzOnRjOmVieG1sLXJlZ3JlcDp4c2Q6cnM6My4wIiB4bWxuczpuczQ9InVybjpvYXNpczpuYW1lczp0YzplYnhtbC1yZWdyZXA6eHNkOmxjbTozLjAiIG1heFJlc3VsdHM9Ii0xIiBzdGFydEluZGV4PSIwIiBmZWRlcmF0aW9uPSI/IiBmZWRlcmF0ZWQ9ImZhbHNlIiBjb21tZW50PSI/IiBpZD0iPyI+PFJlc3BvbnNlT3B0aW9uIHJldHVybkNvbXBvc2VkT2JqZWN0cz0iZmFsc2UiIHJldHVyblR5cGU9IlJlZ2lzdHJ5T2JqZWN0Ii8+PG5zMjpBZGhvY1F1ZXJ5IHN0YXR1cz0iPyIgb2JqZWN0VHlwZT0iPyIgbGlkPSI/IiBob21lPSI/IiBpZD0iPyIvPjwvQWRob2NRdWVyeVJlcXVlc3Q+</ParticipantObjectQuery></ParticipantObjectIdentification></AuditMessage>'),(2,'2009-02-20 13:19:38',0,'Phillip Kirkman',1,1,'2','989898^^^&2.16.840.1.113883.3.185&ISO',NULL,'2.16.840.1.113883.3.185','logAdhocQueryResponse','<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?><AuditMessage xmlns=\"http://nhinc.services.com/schema/auditmessage\"><EventIdentification EventOutcomeIndicator=\"0\" EventDateTime=\"2009-02-20T18:19:38.906Z\" EventActionCode=\"E\"><EventID codeSystemName=\"DCM\" codeSystem=\"Query\" displayName=\"Query\" code=\"DCM\"/></EventIdentification><ActiveParticipant NetworkAccessPointTypeCode=\"2\" NetworkAccessPointID=\"192.168.101.137\" UserIsRequestor=\"true\" UserName=\"Phillip Kirkman\" UserID=\"Phillip Kirkman\"/><AuditSourceIdentification AuditSourceID=\"2.16.840.1.113883.3.185\"/><ParticipantObjectIdentification ParticipantObjectTypeCodeRole=\"1\" ParticipantObjectTypeCode=\"1\" ParticipantObjectID=\"989898\"><ParticipantObjectIDTypeCode code=\"2\"/><ParticipantObjectQuery>PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiIHN0YW5kYWxvbmU9InllcyI/PjxBZGhvY1F1ZXJ5UmVzcG9uc2UgeG1sbnM9InVybjpvYXNpczpuYW1lczp0YzplYnhtbC1yZWdyZXA6eHNkOnF1ZXJ5OjMuMCIgeG1sbnM6bnMyPSJ1cm46b2FzaXM6bmFtZXM6dGM6ZWJ4bWwtcmVncmVwOnhzZDpyaW06My4wIiB4bWxuczpuczM9InVybjpvYXNpczpuYW1lczp0YzplYnhtbC1yZWdyZXA6eHNkOnJzOjMuMCIgeG1sbnM6bnM0PSJ1cm46b2FzaXM6bmFtZXM6dGM6ZWJ4bWwtcmVncmVwOnhzZDpsY206My4wIiB0b3RhbFJlc3VsdENvdW50PSIxIiBzdGFydEluZGV4PSIwIiByZXF1ZXN0SWQ9Ij8iIHN0YXR1cz0iPyI+PG5zMjpSZWdpc3RyeU9iamVjdExpc3Q+PG5zMjpJZGVudGlmaWFibGUgaG9tZT0iMi4xNi44NDAuMS4xMTM4ODMuMy4xODUiIGlkPSJEZWxhd2FyZSBSZWdpb24iLz48bnMyOkV4dHJpbnNpY09iamVjdCBpc09wYXF1ZT0iZmFsc2UiIG1pbWVUeXBlPSJ0ZXh0L3htbCIgc3RhdHVzPSJ1cm46b2FzaXM6bmFtZXM6dGM6ZWJ4bWwtcmVncmVwOlN0YXR1c1R5cGU6QXBwcm92ZWQiIG9iamVjdFR5cGU9InVybjp1dWlkOjdlZGNhODJmLTA1NGQtNDdmMi1hMDMyLTliMmE1YjUxODZjMSIgaG9tZT0idXJuOm9pZDoyLjE2Ljg0MC4xLjExMzg4My4zLjE4NSIgaWQ9InVybjp1dWlkOmM5MWFjMGUyLWI1MzctNDNmZS1iNWExLWU5NGRiMDc5YWNmMiI+PG5zMjpTbG90IG5hbWU9ImNyZWF0aW9uVGltZSI+PG5zMjpWYWx1ZUxpc3Q+PG5zMjpWYWx1ZT4yMDA4MDEyMDA1MDUwNS0wNzAwPC9uczI6VmFsdWU+PC9uczI6VmFsdWVMaXN0PjwvbnMyOlNsb3Q+PG5zMjpTbG90IG5hbWU9Imhhc2giPjxuczI6VmFsdWVMaXN0PjxuczI6VmFsdWU+MTU2OTYwODk0MDwvbnMyOlZhbHVlPjwvbnMyOlZhbHVlTGlzdD48L25zMjpTbG90PjxuczI6U2xvdCBuYW1lPSJpbnRlbmRlZFJlY2lwaWVudCI+PG5zMjpWYWx1ZUxpc3Q+PG5zMjpWYWx1ZT5pbnRlbmRlZFJlY2lwaWVudFBlcnNvbl92YWx1ZTwvbnMyOlZhbHVlPjwvbnMyOlZhbHVlTGlzdD48L25zMjpTbG90PjxuczI6U2xvdCBuYW1lPSJsYW5ndWFnZUNvZGUiPjxuczI6VmFsdWVMaXN0PjxuczI6VmFsdWU+bGFuZ3VhZ2VDb2RlX3ZhbHVlPC9uczI6VmFsdWU+PC9uczI6VmFsdWVMaXN0PjwvbnMyOlNsb3Q+PG5zMjpTbG90IG5hbWU9ImxlZ2FsQXV0aGVudGljYXRvciI+PG5zMjpWYWx1ZUxpc3Q+PG5zMjpWYWx1ZT5sZWdhbEF1dGhlbnRpY2F0b3JfdmFsdWU8L25zMjpWYWx1ZT48L25zMjpWYWx1ZUxpc3Q+PC9uczI6U2xvdD48bnMyOlNsb3QgbmFtZT0ic2VydmljZVN0YXJ0VGltZSI+PG5zMjpWYWx1ZUxpc3Q+PG5zMjpWYWx1ZT4yMDA4MDUwMTwvbnMyOlZhbHVlPjwvbnMyOlZhbHVlTGlzdD48L25zMjpTbG90PjxuczI6U2xvdCBuYW1lPSJzZXJ2aWNlU3RvcFRpbWUiPjxuczI6VmFsdWVMaXN0PjxuczI6VmFsdWU+MjAwODA1MTU8L25zMjpWYWx1ZT48L25zMjpWYWx1ZUxpc3Q+PC9uczI6U2xvdD48bnMyOlNsb3QgbmFtZT0ic2l6ZSI+PG5zMjpWYWx1ZUxpc3Q+PG5zMjpWYWx1ZT4xMjM0PC9uczI6VmFsdWU+PC9uczI6VmFsdWVMaXN0PjwvbnMyOlNsb3Q+PG5zMjpTbG90IG5hbWU9InNvdXJjZVBhdGllbnRJZCI+PG5zMjpWYWx1ZUxpc3Q+PG5zMjpWYWx1ZT5zb3VyY2VQYXRpZW50SWRfdmFsdWU8L25zMjpWYWx1ZT48L25zMjpWYWx1ZUxpc3Q+PC9uczI6U2xvdD48bnMyOlNsb3QgbmFtZT0ic291cmNlUGF0aWVudEluZm8iPjxuczI6VmFsdWVMaXN0PjxuczI6VmFsdWU+UElELTN8cGlkM192YWx1ZTwvbnMyOlZhbHVlPjxuczI6VmFsdWU+UElELTV8cGlkNV92YWx1ZTwvbnMyOlZhbHVlPjxuczI6VmFsdWU+UElELTd8cGlkN192YWx1ZTwvbnMyOlZhbHVlPjxuczI6VmFsdWU+UElELTh8cGlkOF92YWx1ZTwvbnMyOlZhbHVlPjxuczI6VmFsdWU+UElELTExfHBpZDExX3ZhbHVlPC9uczI6VmFsdWU+PC9uczI6VmFsdWVMaXN0PjwvbnMyOlNsb3Q+PG5zMjpTbG90IG5hbWU9IlVSSSI+PG5zMjpWYWx1ZUxpc3Q+PG5zMjpWYWx1ZT5kb2N1bWVudFVyaV92YWx1ZTwvbnMyOlZhbHVlPjwvbnMyOlZhbHVlTGlzdD48L25zMjpTbG90PjxuczI6U2xvdCBuYW1lPSJyZXBvc2l0b3J5VW5pcXVlSWQiPjxuczI6VmFsdWVMaXN0PjxuczI6VmFsdWU+MTwvbnMyOlZhbHVlPjwvbnMyOlZhbHVlTGlzdD48L25zMjpTbG90PjxuczI6TmFtZT48bnMyOkxvY2FsaXplZFN0cmluZyB2YWx1ZT0iQkhJRSBEb2N1bWVudCAxIi8+PC9uczI6TmFtZT48bnMyOkRlc2NyaXB0aW9uPjxuczI6TG9jYWxpemVkU3RyaW5nIHZhbHVlPSJEb2N1bWVudCAxIGNvbW1lbnRzIi8+PC9uczI6RGVzY3JpcHRpb24+PG5zMjpDbGFzc2lmaWNhdGlvbiBub2RlUmVwcmVzZW50YXRpb249IiIgY2xhc3NpZmllZE9iamVjdD0idXJuOnV1aWQ6YzkxYWMwZTItYjUzNy00M2ZlLWI1YTEtZTk0ZGIwNzlhY2YyIiBjbGFzc2lmaWNhdGlvblNjaGVtZT0idXJuOnV1aWQ6OTM2MDZiY2YtOTQ5NC00M2VjLTliNGUtYTc3NDhkMWE4MzhkIiBpZD0iIj48bnMyOlNsb3QgbmFtZT0iYXV0aG9yUGVyc29uIj48bnMyOlZhbHVlTGlzdD48bnMyOlZhbHVlPkJvYiBEaWxsYW48L25zMjpWYWx1ZT48L25zMjpWYWx1ZUxpc3Q+PC9uczI6U2xvdD48bnMyOlNsb3QgbmFtZT0iYXV0aG9ySW5zdGl0dXRpb24iPjxuczI6VmFsdWVMaXN0PjxuczI6VmFsdWU+RGlsbGFuIEluc3RpdHV0ZTwvbnMyOlZhbHVlPjwvbnMyOlZhbHVlTGlzdD48L25zMjpTbG90PjxuczI6U2xvdCBuYW1lPSJhdXRob3JSb2xlIj48bnMyOlZhbHVlTGlzdD48bnMyOlZhbHVlPlJldmVpd2VyPC9uczI6VmFsdWU+PC9uczI6VmFsdWVMaXN0PjwvbnMyOlNsb3Q+PG5zMjpTbG90IG5hbWU9ImF1dGhvclNwZWNpYWx0eSI+PG5zMjpWYWx1ZUxpc3Q+PG5zMjpWYWx1ZT5hdXRob3JTcGVjaWFsdHlfdmFsdWU8L25zMjpWYWx1ZT48L25zMjpWYWx1ZUxpc3Q+PC9uczI6U2xvdD48L25zMjpDbGFzc2lmaWNhdGlvbj48bnMyOkNsYXNzaWZpY2F0aW9uIG5vZGVSZXByZXNlbnRhdGlvbj0iQ2xhc3NfMTExIiBjbGFzc2lmaWVkT2JqZWN0PSJ1cm46dXVpZDpjOTFhYzBlMi1iNTM3LTQzZmUtYjVhMS1lOTRkYjA3OWFjZjIiIGNsYXNzaWZpY2F0aW9uU2NoZW1lPSJ1cm46dXVpZDo0MWE1ODg3Zi04ODY1LTRjMDktYWRmNy1lMzYyNDc1YjE0M2EiIGlkPSIiPjxuczI6U2xvdCBuYW1lPSJjb2RpbmdTY2hlbWUiPjxuczI6VmFsdWVMaXN0PjxuczI6VmFsdWU+Q2xhc3Nfc2NoZW1lXzExMTwvbnMyOlZhbHVlPjwvbnMyOlZhbHVlTGlzdD48L25zMjpTbG90PjxuczI6TmFtZT48bnMyOkxvY2FsaXplZFN0cmluZyB2YWx1ZT0iY2xhc3NDb2RlRGlzcGxheU5hbWVfdmFsdWUiLz48L25zMjpOYW1lPjwvbnMyOkNsYXNzaWZpY2F0aW9uPjxuczI6Q2xhc3NpZmljYXRpb24gbm9kZVJlcHJlc2VudGF0aW9uPSJjb25maWRlbnRpYWxpdHlDb2RlX3ZhbHVlIiBjbGFzc2lmaWVkT2JqZWN0PSJ1cm46dXVpZDpjOTFhYzBlMi1iNTM3LTQzZmUtYjVhMS1lOTRkYjA3OWFjZjIiIGNsYXNzaWZpY2F0aW9uU2NoZW1lPSJ1cm46dXVpZDpmNGY4NWVhYy1lNmNiLTQ4ODMtYjUyNC1mMjcwNTM5NDg0MGYiIGlkPSIiPjxuczI6U2xvdCBuYW1lPSJjb2RpbmdTY2hlbWUiPjxuczI6VmFsdWVMaXN0PjxuczI6VmFsdWU+Y29uZmlkZW50aWFsaXR5Q29kZVNjaGVtZV92YWx1ZTwvbnMyOlZhbHVlPjwvbnMyOlZhbHVlTGlzdD48L25zMjpTbG90PjxuczI6TmFtZT48bnMyOkxvY2FsaXplZFN0cmluZyB2YWx1ZT0iY29uZmlkZW50aWFsaXR5Q29kZURpc3BsYXlOYW1lX3ZhbHVlIi8+PC9uczI6TmFtZT48L25zMjpDbGFzc2lmaWNhdGlvbj48bnMyOkNsYXNzaWZpY2F0aW9uIG5vZGVSZXByZXNlbnRhdGlvbj0iY29kZV92YWx1ZSIgY2xhc3NpZmllZE9iamVjdD0idXJuOnV1aWQ6YzkxYWMwZTItYjUzNy00M2ZlLWI1YTEtZTk0ZGIwNzlhY2YyIiBjbGFzc2lmaWNhdGlvblNjaGVtZT0idXJuOnV1aWQ6MmM2YjhjYjctOGIyYS00MDUxLWIyOTEtYjFhZTZhNTc1ZWY0IiBpZD0iIj48bnMyOlNsb3QgbmFtZT0iY29kaW5nU2NoZW1lIj48bnMyOlZhbHVlTGlzdD48bnMyOlZhbHVlPmNvZGVTY2hlbWFfdmFsdWU8L25zMjpWYWx1ZT48L25zMjpWYWx1ZUxpc3Q+PC9uczI6U2xvdD48bnMyOk5hbWU+PG5zMjpMb2NhbGl6ZWRTdHJpbmcgdmFsdWU9ImNvZGVEaXNwbGF5TmFtZV92YWx1ZSIvPjwvbnMyOk5hbWU+PC9uczI6Q2xhc3NpZmljYXRpb24+PG5zMjpDbGFzc2lmaWNhdGlvbiBub2RlUmVwcmVzZW50YXRpb249InRlc3QiIGNsYXNzaWZpZWRPYmplY3Q9InVybjp1dWlkOmM5MWFjMGUyLWI1MzctNDNmZS1iNWExLWU5NGRiMDc5YWNmMiIgY2xhc3NpZmljYXRpb25TY2hlbWU9InVybjp1dWlkOjJjNmI4Y2I3LThiMmEtNDA1MS1iMjkxLWIxYWU2YTU3NWVmNCIgaWQ9IiI+PG5zMjpTbG90IG5hbWU9ImNvZGluZ1NjaGVtZSI+PG5zMjpWYWx1ZUxpc3Q+PG5zMjpWYWx1ZT50ZXN0PC9uczI6VmFsdWU+PC9uczI6VmFsdWVMaXN0PjwvbnMyOlNsb3Q+PG5zMjpOYW1lPjxuczI6TG9jYWxpemVkU3RyaW5nIHZhbHVlPSJ0ZXN0Ii8+PC9uczI6TmFtZT48L25zMjpDbGFzc2lmaWNhdGlvbj48bnMyOkNsYXNzaWZpY2F0aW9uIG5vZGVSZXByZXNlbnRhdGlvbj0idGVzdCIgY2xhc3NpZmllZE9iamVjdD0idXJuOnV1aWQ6YzkxYWMwZTItYjUzNy00M2ZlLWI1YTEtZTk0ZGIwNzlhY2YyIiBjbGFzc2lmaWNhdGlvblNjaGVtZT0idXJuOnV1aWQ6MmM2YjhjYjctOGIyYS00MDUxLWIyOTEtYjFhZTZhNTc1ZWY0IiBpZD0iIj48bnMyOlNsb3QgbmFtZT0iY29kaW5nU2NoZW1lIj48bnMyOlZhbHVlTGlzdD48bnMyOlZhbHVlPnRlc3Q8L25zMjpWYWx1ZT48L25zMjpWYWx1ZUxpc3Q+PC9uczI6U2xvdD48bnMyOk5hbWU+PG5zMjpMb2NhbGl6ZWRTdHJpbmcgdmFsdWU9InRlc3QiLz48L25zMjpOYW1lPjwvbnMyOkNsYXNzaWZpY2F0aW9uPjxuczI6Q2xhc3NpZmljYXRpb24gbm9kZVJlcHJlc2VudGF0aW9uPSJ0ZXN0IiBjbGFzc2lmaWVkT2JqZWN0PSJ1cm46dXVpZDpjOTFhYzBlMi1iNTM3LTQzZmUtYjVhMS1lOTRkYjA3OWFjZjIiIGNsYXNzaWZpY2F0aW9uU2NoZW1lPSJ1cm46dXVpZDoyYzZiOGNiNy04YjJhLTQwNTEtYjI5MS1iMWFlNmE1NzVlZjQiIGlkPSIiPjxuczI6U2xvdCBuYW1lPSJjb2RpbmdTY2hlbWUiPjxuczI6VmFsdWVMaXN0PjxuczI6VmFsdWU+dGVzdDwvbnMyOlZhbHVlPjwvbnMyOlZhbHVlTGlzdD48L25zMjpTbG90PjxuczI6TmFtZT48bnMyOkxvY2FsaXplZFN0cmluZyB2YWx1ZT0idGVzdCIvPjwvbnMyOk5hbWU+PC9uczI6Q2xhc3NpZmljYXRpb24+PG5zMjpDbGFzc2lmaWNhdGlvbiBub2RlUmVwcmVzZW50YXRpb249ImNvZGVfdmFsdWUiIGNsYXNzaWZpZWRPYmplY3Q9InVybjp1dWlkOmM5MWFjMGUyLWI1MzctNDNmZS1iNWExLWU5NGRiMDc5YWNmMiIgY2xhc3NpZmljYXRpb25TY2hlbWU9InVybjp1dWlkOjJjNmI4Y2I3LThiMmEtNDA1MS1iMjkxLWIxYWU2YTU3NWVmNCIgaWQ9IiI+PG5zMjpTbG90IG5hbWU9ImNvZGluZ1NjaGVtZSI+PG5zMjpWYWx1ZUxpc3Q+PG5zMjpWYWx1ZT5jb2RlU2NoZW1hX3ZhbHVlPC9uczI6VmFsdWU+PC9uczI6VmFsdWVMaXN0PjwvbnMyOlNsb3Q+PG5zMjpOYW1lPjxuczI6TG9jYWxpemVkU3RyaW5nIHZhbHVlPSJjb2RlRGlzcGxheU5hbWVfdmFsdWUiLz48L25zMjpOYW1lPjwvbnMyOkNsYXNzaWZpY2F0aW9uPjxuczI6Q2xhc3NpZmljYXRpb24gbm9kZVJlcHJlc2VudGF0aW9uPSJjb2RlX3ZhbHVlIiBjbGFzc2lmaWVkT2JqZWN0PSJ1cm46dXVpZDpjOTFhYzBlMi1iNTM3LTQzZmUtYjVhMS1lOTRkYjA3OWFjZjIiIGNsYXNzaWZpY2F0aW9uU2NoZW1lPSJ1cm46dXVpZDoyYzZiOGNiNy04YjJhLTQwNTEtYjI5MS1iMWFlNmE1NzVlZjQiIGlkPSIiPjxuczI6U2xvdCBuYW1lPSJjb2RpbmdTY2hlbWUiPjxuczI6VmFsdWVMaXN0PjxuczI6VmFsdWU+Y29kZVNjaGVtYV92YWx1ZTwvbnMyOlZhbHVlPjwvbnMyOlZhbHVlTGlzdD48L25zMjpTbG90PjxuczI6TmFtZT48bnMyOkxvY2FsaXplZFN0cmluZyB2YWx1ZT0iY29kZURpc3BsYXlOYW1lX3ZhbHVlIi8+PC9uczI6TmFtZT48L25zMjpDbGFzc2lmaWNhdGlvbj48bnMyOkNsYXNzaWZpY2F0aW9uIG5vZGVSZXByZXNlbnRhdGlvbj0iY29kZV92YWx1ZSIgY2xhc3NpZmllZE9iamVjdD0idXJuOnV1aWQ6YzkxYWMwZTItYjUzNy00M2ZlLWI1YTEtZTk0ZGIwNzlhY2YyIiBjbGFzc2lmaWNhdGlvblNjaGVtZT0idXJuOnV1aWQ6MmM2YjhjYjctOGIyYS00MDUxLWIyOTEtYjFhZTZhNTc1ZWY0IiBpZD0iIj48bnMyOlNsb3QgbmFtZT0iY29kaW5nU2NoZW1lIj48bnMyOlZhbHVlTGlzdD48bnMyOlZhbHVlPmNvZGVTY2hlbWFfdmFsdWU8L25zMjpWYWx1ZT48L25zMjpWYWx1ZUxpc3Q+PC9uczI6U2xvdD48bnMyOk5hbWU+PG5zMjpMb2NhbGl6ZWRTdHJpbmcgdmFsdWU9ImNvZGVEaXNwbGF5TmFtZV92YWx1ZSIvPjwvbnMyOk5hbWU+PC9uczI6Q2xhc3NpZmljYXRpb24+PG5zMjpDbGFzc2lmaWNhdGlvbiBub2RlUmVwcmVzZW50YXRpb249ImZvcm1hdENvZGVfdmFsdWUiIGNsYXNzaWZpZWRPYmplY3Q9InVybjp1dWlkOmM5MWFjMGUyLWI1MzctNDNmZS1iNWExLWU5NGRiMDc5YWNmMiIgY2xhc3NpZmljYXRpb25TY2hlbWU9InVybjp1dWlkOmEwOWQ1ODQwLTM4NmMtNDZmMi1iNWFkLTljMzY5OWE0MzA5ZCIgaWQ9IiI+PG5zMjpTbG90IG5hbWU9ImNvZGluZ1NjaGVtZSI+PG5zMjpWYWx1ZUxpc3Q+PG5zMjpWYWx1ZT5mb3JtYXRDb2RlU2NoZW1lX3ZhbHVlPC9uczI6VmFsdWU+PC9uczI6VmFsdWVMaXN0PjwvbnMyOlNsb3Q+PG5zMjpOYW1lPjxuczI6TG9jYWxpemVkU3RyaW5nIHZhbHVlPSJmb3JtYXRDb2RlRGlzcGxheU5hbWVfdmFsdWUiLz48L25zMjpOYW1lPjwvbnMyOkNsYXNzaWZpY2F0aW9uPjxuczI6Q2xhc3NpZmljYXRpb24gbm9kZVJlcHJlc2VudGF0aW9uPSJmYWNpbGl0eUNvZGVfdmFsdWUiIGNsYXNzaWZpZWRPYmplY3Q9InVybjp1dWlkOmM5MWFjMGUyLWI1MzctNDNmZS1iNWExLWU5NGRiMDc5YWNmMiIgY2xhc3NpZmljYXRpb25TY2hlbWU9InVybjp1dWlkOmYzM2ZiOGFjLTE4YWYtNDJjYy1hZTBlLWVkMGIwYmRiOTFlMSIgaWQ9IiI+PG5zMjpTbG90IG5hbWU9ImNvZGluZ1NjaGVtZSI+PG5zMjpWYWx1ZUxpc3Q+PG5zMjpWYWx1ZT5mYWNpbGl0eUNvZGVTY2hlbWVfdmFsdWU8L25zMjpWYWx1ZT48L25zMjpWYWx1ZUxpc3Q+PC9uczI6U2xvdD48bnMyOk5hbWU+PG5zMjpMb2NhbGl6ZWRTdHJpbmcgdmFsdWU9ImZhY2lsaXR5Q29kZURpc3BsYXlOYW1lX3ZhbHVlIi8+PC9uczI6TmFtZT48L25zMjpDbGFzc2lmaWNhdGlvbj48bnMyOkNsYXNzaWZpY2F0aW9uIG5vZGVSZXByZXNlbnRhdGlvbj0icHJhY3RpY2VTZXR0aW5nX3ZhbHVlIiBjbGFzc2lmaWVkT2JqZWN0PSJ1cm46dXVpZDpjOTFhYzBlMi1iNTM3LTQzZmUtYjVhMS1lOTRkYjA3OWFjZjIiIGNsYXNzaWZpY2F0aW9uU2NoZW1lPSJ1cm46dXVpZDpjY2NmNTU5OC04YjA3LTRiNzctYTA1ZS1hZTk1MmM3ODVlYWQiIGlkPSIiPjxuczI6U2xvdCBuYW1lPSJjb2RpbmdTY2hlbWUiPjxuczI6VmFsdWVMaXN0PjxuczI6VmFsdWU+cHJhY3RpY2VTZXR0aW5nU2NoZW1lX3ZhbHVlPC9uczI6VmFsdWU+PC9uczI6VmFsdWVMaXN0PjwvbnMyOlNsb3Q+PG5zMjpOYW1lPjxuczI6TG9jYWxpemVkU3RyaW5nIHZhbHVlPSJwcmFjdGljZVNldHRpbmdEaXNwbGF5TmFtZV92YWx1ZSIvPjwvbnMyOk5hbWU+PC9uczI6Q2xhc3NpZmljYXRpb24+PG5zMjpDbGFzc2lmaWNhdGlvbiBub2RlUmVwcmVzZW50YXRpb249InR5cGVDb2RlX3ZhbHVlIiBjbGFzc2lmaWVkT2JqZWN0PSJ1cm46dXVpZDpjOTFhYzBlMi1iNTM3LTQzZmUtYjVhMS1lOTRkYjA3OWFjZjIiIGNsYXNzaWZpY2F0aW9uU2NoZW1lPSJ1cm46dXVpZDpmMDMwNmY1MS05NzVmLTQzNGUtYTYxYy1jNTk2NTFkMzM5ODMiIGlkPSIiPjxuczI6U2xvdCBuYW1lPSJjb2RpbmdTY2hlbWUiPjxuczI6VmFsdWVMaXN0PjxuczI6VmFsdWU+dHlwZUNvZGVTY2hlbWVfdmFsdWU8L25zMjpWYWx1ZT48L25zMjpWYWx1ZUxpc3Q+PC9uczI6U2xvdD48bnMyOk5hbWU+PG5zMjpMb2NhbGl6ZWRTdHJpbmcgdmFsdWU9InR5cGVDb2RlRGlzcGxheU5hbWVfdmFsdWUiLz48L25zMjpOYW1lPjwvbnMyOkNsYXNzaWZpY2F0aW9uPjxuczI6RXh0ZXJuYWxJZGVudGlmaWVyIHZhbHVlPSInMTIzNF5eXiZhbXA7MS4xJmFtcDtJU08nIiBpZGVudGlmaWNhdGlvblNjaGVtZT0idXJuOnV1aWQ6NThhNmY4NDEtODdiMy00YTNlLTkyZmQtYThmZmVmZjk4NDI3IiByZWdpc3RyeU9iamVjdD0idXJuOnV1aWQ6YzkxYWMwZTItYjUzNy00M2ZlLWI1YTEtZTk0ZGIwNzlhY2YyIiBpZD0iIj48bnMyOk5hbWU+PG5zMjpMb2NhbGl6ZWRTdHJpbmcgdmFsdWU9IlhEU0RvY3VtZW50RW50cnkucGF0aWVudElkIi8+PC9uczI6TmFtZT48L25zMjpFeHRlcm5hbElkZW50aWZpZXI+PG5zMjpFeHRlcm5hbElkZW50aWZpZXIgdmFsdWU9IjExMTExMTExMSIgaWRlbnRpZmljYXRpb25TY2hlbWU9InVybjp1dWlkOjJlODJjMWY2LWEwODUtNGM3Mi05ZGEzLTg2NDBhMzJlNDJhYiIgcmVnaXN0cnlPYmplY3Q9InVybjp1dWlkOmM5MWFjMGUyLWI1MzctNDNmZS1iNWExLWU5NGRiMDc5YWNmMiIgaWQ9IiI+PG5zMjpOYW1lPjxuczI6TG9jYWxpemVkU3RyaW5nIHZhbHVlPSJYRFNEb2N1bWVudEVudHJ5LnVuaXF1ZUlkIi8+PC9uczI6TmFtZT48L25zMjpFeHRlcm5hbElkZW50aWZpZXI+PC9uczI6RXh0cmluc2ljT2JqZWN0PjwvbnMyOlJlZ2lzdHJ5T2JqZWN0TGlzdD48L0FkaG9jUXVlcnlSZXNwb25zZT4=</ParticipantObjectQuery></ParticipantObjectIdentification></AuditMessage>'),(3,'2009-02-20 13:20:05',0,'Alexandra Rodriquez',1,1,'2','65456^^^&2.16.840.1.113883.3.192&ISO',NULL,'2.16.840.1.113883.3.192','logAdhocQueryRequest','<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?><AuditMessage xmlns=\"http://nhinc.services.com/schema/auditmessage\"><EventIdentification EventOutcomeIndicator=\"0\" EventDateTime=\"2009-02-20T18:20:05.000Z\" EventActionCode=\"E\"><EventID codeSystemName=\"DCM\" codeSystem=\"Query\" displayName=\"Query\" code=\"DCM\"/></EventIdentification><ActiveParticipant NetworkAccessPointTypeCode=\"2\" NetworkAccessPointID=\"192.168.101.137\" UserIsRequestor=\"true\" UserName=\"Alexandra Rodriquez\" UserID=\"Alexandra Rodriquez\"/><AuditSourceIdentification AuditSourceID=\"2.16.840.1.113883.3.192\" AuditEnterpriseSiteID=\"Cleveland Clinic\"/><ParticipantObjectIdentification ParticipantObjectTypeCodeRole=\"1\" ParticipantObjectTypeCode=\"1\" ParticipantObjectID=\"65456\"><ParticipantObjectIDTypeCode code=\"2\"/><ParticipantObjectQuery>PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiIHN0YW5kYWxvbmU9InllcyI/PjxBZGhvY1F1ZXJ5UmVxdWVzdCB4bWxucz0idXJuOm9hc2lzOm5hbWVzOnRjOmVieG1sLXJlZ3JlcDp4c2Q6cXVlcnk6My4wIiB4bWxuczpuczI9InVybjpvYXNpczpuYW1lczp0YzplYnhtbC1yZWdyZXA6eHNkOnJpbTozLjAiIHhtbG5zOm5zMz0idXJuOm9hc2lzOm5hbWVzOnRjOmVieG1sLXJlZ3JlcDp4c2Q6cnM6My4wIiB4bWxuczpuczQ9InVybjpvYXNpczpuYW1lczp0YzplYnhtbC1yZWdyZXA6eHNkOmxjbTozLjAiIG1heFJlc3VsdHM9Ii0xIiBzdGFydEluZGV4PSIwIiBmZWRlcmF0aW9uPSI/IiBmZWRlcmF0ZWQ9ImZhbHNlIiBjb21tZW50PSI/IiBpZD0iPyI+PFJlc3BvbnNlT3B0aW9uIHJldHVybkNvbXBvc2VkT2JqZWN0cz0iZmFsc2UiIHJldHVyblR5cGU9IlJlZ2lzdHJ5T2JqZWN0Ii8+PG5zMjpBZGhvY1F1ZXJ5IHN0YXR1cz0iPyIgb2JqZWN0VHlwZT0iPyIgbGlkPSI/IiBob21lPSI/IiBpZD0iPyIvPjwvQWRob2NRdWVyeVJlcXVlc3Q+</ParticipantObjectQuery></ParticipantObjectIdentification></AuditMessage>'),(4,'2009-02-22 12:44:52',0,'mfranklin',1,1,'2','1000000008^^^&2.16.840.1.113883.3.198&ISO',NULL,'2.16.840.1.113883.3.198','logRetrieveDocumentSetRequest','<?xml version=\"1.0\" encoding=\"UTF-8\" standalone=\"yes\"?><AuditMessage xmlns=\"http://nhinc.services.com/schema/auditmessage\"><EventIdentification EventOutcomeIndicator=\"0\" EventDateTime=\"2009-02-22T17:44:52.593Z\" EventActionCode=\"E\"><EventID codeSystemName=\"DCM\" codeSystem=\"Retrieve\" displayName=\"Retrieve\" code=\"DCM\"/></EventIdentification><ActiveParticipant NetworkAccessPointTypeCode=\"2\" NetworkAccessPointID=\"172.16.100.12\" UserIsRequestor=\"true\" UserName=\"MARK FRANKLIN\" UserID=\"mfranklin\"/><AuditSourceIdentification AuditSourceID=\"2.16.840.1.113883.3.198\" AuditEnterpriseSiteID=\"Federal - DoD\"/><ParticipantObjectIdentification ParticipantObjectTypeCodeRole=\"1\" ParticipantObjectTypeCode=\"1\" ParticipantObjectID=\"1000000008^^^&2.16.840.1.113883.3.198&ISO\"><ParticipantObjectIDTypeCode code=\"2\"/><ParticipantObjectQuery>PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiIHN0YW5kYWxvbmU9InllcyI/PjxuczQ6UmV0cmlldmVEb2N1bWVudFNldFJlcXVlc3QgeG1sbnM9InVybjpvYXNpczpuYW1lczp0YzplYnhtbC1yZWdyZXA6eHNkOnJpbTozLjAiIHhtbG5zOm5zMj0idXJuOm9hc2lzOm5hbWVzOnRjOmVieG1sLXJlZ3JlcDp4c2Q6cnM6My4wIiB4bWxuczpuczM9InVybjpvYXNpczpuYW1lczp0YzplYnhtbC1yZWdyZXA6eHNkOmxjbTozLjAiIHhtbG5zOm5zND0idXJuOmloZTppdGk6eGRzLWI6MjAwNyIgeG1sbnM6bnM1PSJ1cm46b2FzaXM6bmFtZXM6dGM6ZWJ4bWwtcmVncmVwOnhzZDpxdWVyeTozLjAiPjxuczQ6RG9jdW1lbnRSZXF1ZXN0PjxuczQ6SG9tZUNvbW11bml0eUlkPnVybjpvaWQ6MS4xPC9uczQ6SG9tZUNvbW11bml0eUlkPjxuczQ6UmVwb3NpdG9yeVVuaXF1ZUlkPjE8L25zNDpSZXBvc2l0b3J5VW5pcXVlSWQ+PG5zNDpEb2N1bWVudFVuaXF1ZUlkPjEyMzQ8L25zNDpEb2N1bWVudFVuaXF1ZUlkPjwvbnM0OkRvY3VtZW50UmVxdWVzdD48L25zNDpSZXRyaWV2ZURvY3VtZW50U2V0UmVxdWVzdD4=</ParticipantObjectQuery></ParticipantObjectIdentification></AuditMessage>');
|
---|
| 151 | /*!40000 ALTER TABLE `auditrepository` ENABLE KEYS */;
|
---|
| 152 | UNLOCK TABLES;
|
---|
| 153 |
|
---|
| 154 | --
|
---|
| 155 | -- Current Database: `docrepository`
|
---|
| 156 | --
|
---|
| 157 |
|
---|
| 158 | CREATE DATABASE /*!32312 IF NOT EXISTS*/ `docrepository` /*!40100 DEFAULT CHARACTER SET latin1 */;
|
---|
| 159 |
|
---|
| 160 | USE `docrepository`;
|
---|
| 161 |
|
---|
| 162 | --
|
---|
| 163 | -- Table structure for table `document`
|
---|
| 164 | --
|
---|
| 165 |
|
---|
| 166 | DROP TABLE IF EXISTS `document`;
|
---|
| 167 | SET @saved_cs_client = @@character_set_client;
|
---|
| 168 | SET character_set_client = utf8;
|
---|
| 169 | CREATE TABLE `document` (
|
---|
| 170 | `documentid` int(11) NOT NULL,
|
---|
| 171 | `DocumentUniqueId` varchar(64) NOT NULL,
|
---|
| 172 | `DocumentTitle` varchar(128) default NULL,
|
---|
| 173 | `authorPerson` varchar(64) default NULL,
|
---|
| 174 | `authorInstitution` varchar(64) default NULL,
|
---|
| 175 | `authorRole` varchar(64) default NULL,
|
---|
| 176 | `authorSpecialty` varchar(64) default NULL,
|
---|
| 177 | `AvailabilityStatus` varchar(64) default NULL,
|
---|
| 178 | `ClassCode` varchar(64) default NULL,
|
---|
| 179 | `ClassCodeScheme` varchar(64) default NULL,
|
---|
| 180 | `ClassCodeDisplayName` varchar(64) default NULL,
|
---|
| 181 | `ConfidentialityCode` varchar(64) default NULL,
|
---|
| 182 | `ConfidentialityCodeScheme` varchar(64) default NULL,
|
---|
| 183 | `ConfidentialityCodeDisplayName` varchar(64) default NULL,
|
---|
| 184 | `CreationTime` datetime default NULL COMMENT 'Date format expected: MM/dd/yyyy.HH:mm:ss',
|
---|
| 185 | `FormatCode` varchar(64) default NULL,
|
---|
| 186 | `FormatCodeScheme` varchar(64) default NULL,
|
---|
| 187 | `FormatCodeDisplayName` varchar(64) default NULL,
|
---|
| 188 | `PatientId` varchar(64) default NULL COMMENT 'Format of HL7 2.x CX',
|
---|
| 189 | `ServiceStartTime` datetime default NULL COMMENT 'Format of YYYYMMDDHHMMSS',
|
---|
| 190 | `ServiceStopTime` datetime default NULL COMMENT 'Format of YYYYMMDDHHMMSS',
|
---|
| 191 | `Status` varchar(64) default NULL,
|
---|
| 192 | `Comments` varchar(256) default NULL,
|
---|
| 193 | `Hash` varchar(1028) default NULL COMMENT 'Might be better to derive',
|
---|
| 194 | `FacilityCode` varchar(64) default NULL,
|
---|
| 195 | `FacilityCodeScheme` varchar(64) default NULL,
|
---|
| 196 | `FacilityCodeDisplayName` varchar(64) default NULL,
|
---|
| 197 | `IntendedRecipientPerson` varchar(128) default NULL COMMENT 'Format of HL7 2.x XCN',
|
---|
| 198 | `IntendedRecipientOrganization` varchar(128) default NULL COMMENT 'Format of HL7 2.x XON',
|
---|
| 199 | `LanguageCode` varchar(64) default NULL,
|
---|
| 200 | `LegalAuthenticator` varchar(128) default NULL COMMENT 'Format of HL7 2.x XCN',
|
---|
| 201 | `MimeType` varchar(32) default NULL,
|
---|
| 202 | `ParentDocumentId` varchar(64) default NULL,
|
---|
| 203 | `ParentDocumentRelationship` varchar(64) default NULL,
|
---|
| 204 | `PracticeSetting` varchar(64) default NULL,
|
---|
| 205 | `PracticeSettingScheme` varchar(64) default NULL,
|
---|
| 206 | `PracticeSettingDisplayName` varchar(64) default NULL,
|
---|
| 207 | `Size` int(11) default NULL,
|
---|
| 208 | `SourcePatientId` varchar(128) default NULL COMMENT 'Format of HL7 2.x CX',
|
---|
| 209 | `Pid3` varchar(128) default NULL,
|
---|
| 210 | `Pid5` varchar(128) default NULL,
|
---|
| 211 | `Pid7` varchar(128) default NULL,
|
---|
| 212 | `Pid8` varchar(128) default NULL,
|
---|
| 213 | `Pid11` varchar(128) default NULL,
|
---|
| 214 | `TypeCode` varchar(64) default NULL,
|
---|
| 215 | `TypeCodeScheme` varchar(64) default NULL,
|
---|
| 216 | `TypeCodeDisplayName` varchar(64) default NULL,
|
---|
| 217 | `DocumentUri` varchar(128) default NULL COMMENT 'May derive this value',
|
---|
| 218 | `RawData` blob,
|
---|
| 219 | `Persistent` int(11) NOT NULL,
|
---|
| 220 | PRIMARY KEY (`documentid`)
|
---|
| 221 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
---|
| 222 | SET character_set_client = @saved_cs_client;
|
---|
| 223 |
|
---|
| 224 | --
|
---|
| 225 | -- Dumping data for table `document`
|
---|
| 226 | --
|
---|
| 227 |
|
---|
| 228 | LOCK TABLES `document` WRITE;
|
---|
| 229 | /*!40000 ALTER TABLE `document` DISABLE KEYS */;
|
---|
| 230 | /*!40000 ALTER TABLE `document` ENABLE KEYS */;
|
---|
| 231 | UNLOCK TABLES;
|
---|
| 232 |
|
---|
| 233 | --
|
---|
| 234 | -- Table structure for table `eventcode`
|
---|
| 235 | --
|
---|
| 236 |
|
---|
| 237 | DROP TABLE IF EXISTS `eventcode`;
|
---|
| 238 | SET @saved_cs_client = @@character_set_client;
|
---|
| 239 | SET character_set_client = utf8;
|
---|
| 240 | CREATE TABLE `eventcode` (
|
---|
| 241 | `eventcodeid` int(11) NOT NULL,
|
---|
| 242 | `documentid` int(11) NOT NULL COMMENT 'Foriegn key to document table',
|
---|
| 243 | `EventCode` varchar(64) default NULL,
|
---|
| 244 | `EventCodeScheme` varchar(64) default NULL,
|
---|
| 245 | `EventCodeDisplayName` varchar(64) default NULL,
|
---|
| 246 | PRIMARY KEY (`eventcodeid`)
|
---|
| 247 | ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
|
---|
| 248 | SET character_set_client = @saved_cs_client;
|
---|
| 249 |
|
---|
| 250 | --
|
---|
| 251 | -- Dumping data for table `eventcode`
|
---|
| 252 | --
|
---|
| 253 |
|
---|
| 254 | LOCK TABLES `eventcode` WRITE;
|
---|
| 255 | /*!40000 ALTER TABLE `eventcode` DISABLE KEYS */;
|
---|
| 256 | /*!40000 ALTER TABLE `eventcode` ENABLE KEYS */;
|
---|
| 257 | UNLOCK TABLES;
|
---|
| 258 |
|
---|
| 259 | --
|
---|
| 260 | -- Current Database: `patientcorrelationdb`
|
---|
| 261 | --
|
---|
| 262 |
|
---|
| 263 | CREATE DATABASE /*!32312 IF NOT EXISTS*/ `patientcorrelationdb` /*!40100 DEFAULT CHARACTER SET latin1 */;
|
---|
| 264 |
|
---|
| 265 | USE `patientcorrelationdb`;
|
---|
| 266 |
|
---|
| 267 | --
|
---|
| 268 | -- Table structure for table `correlatedidentifiers`
|
---|
| 269 | --
|
---|
| 270 |
|
---|
| 271 | DROP TABLE IF EXISTS `correlatedidentifiers`;
|
---|
| 272 | SET @saved_cs_client = @@character_set_client;
|
---|
| 273 | SET character_set_client = utf8;
|
---|
| 274 | CREATE TABLE `correlatedidentifiers` (
|
---|
| 275 | `correlationId` int(10) unsigned NOT NULL auto_increment,
|
---|
| 276 | `PatientAssigningAuthorityId` varchar(45) NOT NULL,
|
---|
| 277 | `PatientId` varchar(45) NOT NULL,
|
---|
| 278 | `CorrelatedPatientAssigningAuthorityId` varchar(45) NOT NULL,
|
---|
| 279 | `CorrelatedPatientId` varchar(45) NOT NULL,
|
---|
| 280 | PRIMARY KEY (`correlationId`)
|
---|
| 281 | ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
|
---|
| 282 | SET character_set_client = @saved_cs_client;
|
---|
| 283 |
|
---|
| 284 | --
|
---|
| 285 | -- Dumping data for table `correlatedidentifiers`
|
---|
| 286 | --
|
---|
| 287 |
|
---|
| 288 | LOCK TABLES `correlatedidentifiers` WRITE;
|
---|
| 289 | /*!40000 ALTER TABLE `correlatedidentifiers` DISABLE KEYS */;
|
---|
| 290 | INSERT INTO `correlatedidentifiers` VALUES (1,'AA1','MRN-1','AA2','MRN-2'),(2,'2.16.840.1.113883.4.1','123456789','2.16.840.1.113883.3.198','D123401'),(3,'2.16.840.1.113883.3.200','500000000','2.16.840.1.113883.3.192','1018'),(4,'2.16.840.1.113883.3.200','500000000','2.16.840.1.113883.4.1','123456789');
|
---|
| 291 | /*!40000 ALTER TABLE `correlatedidentifiers` ENABLE KEYS */;
|
---|
| 292 | UNLOCK TABLES;
|
---|
| 293 | /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
|
---|
| 294 |
|
---|
| 295 | /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
|
---|
| 296 | /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
|
---|
| 297 | /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
|
---|
| 298 | /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
|
---|
| 299 | /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
|
---|
| 300 | /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
|
---|
| 301 | /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
|
---|
| 302 |
|
---|
| 303 | -- Dump completed on 2009-02-22 21:44:12
|
---|