source: ccr/trunk/nhin-vista/projects/NHINC/Current/Product/DBScripts/nhincdb/nhincdb.sql@ 507

Last change on this file since 507 was 507, checked in by George Lilly, 15 years ago

NHIN gateway and adaptor for use on linux with VistA EHR and RPMS
File size: 29.3 KB
Line 
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
22CREATE DATABASE /*!32312 IF NOT EXISTS*/ `aggregator` /*!40100 DEFAULT CHARACTER SET latin1 */;
23
24USE `aggregator`;
25
26--
27-- Table structure for table `agg_message_results`
28--
29
30DROP TABLE IF EXISTS `agg_message_results`;
31SET @saved_cs_client = @@character_set_client;
32SET character_set_client = utf8;
33CREATE 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;
43SET character_set_client = @saved_cs_client;
44
45--
46-- Dumping data for table `agg_message_results`
47--
48
49LOCK TABLES `agg_message_results` WRITE;
50/*!40000 ALTER TABLE `agg_message_results` DISABLE KEYS */;
51/*!40000 ALTER TABLE `agg_message_results` ENABLE KEYS */;
52UNLOCK TABLES;
53
54--
55-- Table structure for table `agg_transaction`
56--
57
58DROP TABLE IF EXISTS `agg_transaction`;
59SET @saved_cs_client = @@character_set_client;
60SET character_set_client = utf8;
61CREATE 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;
67SET character_set_client = @saved_cs_client;
68
69--
70-- Dumping data for table `agg_transaction`
71--
72
73LOCK TABLES `agg_transaction` WRITE;
74/*!40000 ALTER TABLE `agg_transaction` DISABLE KEYS */;
75/*!40000 ALTER TABLE `agg_transaction` ENABLE KEYS */;
76UNLOCK TABLES;
77
78--
79-- Current Database: `assigningauthoritydb`
80--
81
82CREATE DATABASE /*!32312 IF NOT EXISTS*/ `assigningauthoritydb` /*!40100 DEFAULT CHARACTER SET latin1 */;
83
84USE `assigningauthoritydb`;
85
86--
87-- Table structure for table `assigningauthoritytohomecommunitymapping`
88--
89
90DROP TABLE IF EXISTS `assigningauthoritytohomecommunitymapping`;
91SET @saved_cs_client = @@character_set_client;
92SET character_set_client = utf8;
93CREATE 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;
99SET character_set_client = @saved_cs_client;
100
101--
102-- Dumping data for table `assigningauthoritytohomecommunitymapping`
103--
104
105LOCK TABLES `assigningauthoritytohomecommunitymapping` WRITE;
106/*!40000 ALTER TABLE `assigningauthoritytohomecommunitymapping` DISABLE KEYS */;
107INSERT 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 */;
109UNLOCK TABLES;
110
111--
112-- Current Database: `auditrepo`
113--
114
115CREATE DATABASE /*!32312 IF NOT EXISTS*/ `auditrepo` /*!40100 DEFAULT CHARACTER SET latin1 */;
116
117USE `auditrepo`;
118
119--
120-- Table structure for table `auditrepository`
121--
122
123DROP TABLE IF EXISTS `auditrepository`;
124SET @saved_cs_client = @@character_set_client;
125SET character_set_client = utf8;
126CREATE 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;
142SET character_set_client = @saved_cs_client;
143
144--
145-- Dumping data for table `auditrepository`
146--
147
148LOCK TABLES `auditrepository` WRITE;
149/*!40000 ALTER TABLE `auditrepository` DISABLE KEYS */;
150INSERT 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^^^&amp;2.16.840.1.113883.3.198&amp;ISO\"><ParticipantObjectIDTypeCode code=\"2\"/><ParticipantObjectQuery>PD94bWwgdmVyc2lvbj0iMS4wIiBlbmNvZGluZz0iVVRGLTgiIHN0YW5kYWxvbmU9InllcyI/PjxuczQ6UmV0cmlldmVEb2N1bWVudFNldFJlcXVlc3QgeG1sbnM9InVybjpvYXNpczpuYW1lczp0YzplYnhtbC1yZWdyZXA6eHNkOnJpbTozLjAiIHhtbG5zOm5zMj0idXJuOm9hc2lzOm5hbWVzOnRjOmVieG1sLXJlZ3JlcDp4c2Q6cnM6My4wIiB4bWxuczpuczM9InVybjpvYXNpczpuYW1lczp0YzplYnhtbC1yZWdyZXA6eHNkOmxjbTozLjAiIHhtbG5zOm5zND0idXJuOmloZTppdGk6eGRzLWI6MjAwNyIgeG1sbnM6bnM1PSJ1cm46b2FzaXM6bmFtZXM6dGM6ZWJ4bWwtcmVncmVwOnhzZDpxdWVyeTozLjAiPjxuczQ6RG9jdW1lbnRSZXF1ZXN0PjxuczQ6SG9tZUNvbW11bml0eUlkPnVybjpvaWQ6MS4xPC9uczQ6SG9tZUNvbW11bml0eUlkPjxuczQ6UmVwb3NpdG9yeVVuaXF1ZUlkPjE8L25zNDpSZXBvc2l0b3J5VW5pcXVlSWQ+PG5zNDpEb2N1bWVudFVuaXF1ZUlkPjEyMzQ8L25zNDpEb2N1bWVudFVuaXF1ZUlkPjwvbnM0OkRvY3VtZW50UmVxdWVzdD48L25zNDpSZXRyaWV2ZURvY3VtZW50U2V0UmVxdWVzdD4=</ParticipantObjectQuery></ParticipantObjectIdentification></AuditMessage>');
151/*!40000 ALTER TABLE `auditrepository` ENABLE KEYS */;
152UNLOCK TABLES;
153
154--
155-- Current Database: `docrepository`
156--
157
158CREATE DATABASE /*!32312 IF NOT EXISTS*/ `docrepository` /*!40100 DEFAULT CHARACTER SET latin1 */;
159
160USE `docrepository`;
161
162--
163-- Table structure for table `document`
164--
165
166DROP TABLE IF EXISTS `document`;
167SET @saved_cs_client = @@character_set_client;
168SET character_set_client = utf8;
169CREATE 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;
222SET character_set_client = @saved_cs_client;
223
224--
225-- Dumping data for table `document`
226--
227
228LOCK TABLES `document` WRITE;
229/*!40000 ALTER TABLE `document` DISABLE KEYS */;
230/*!40000 ALTER TABLE `document` ENABLE KEYS */;
231UNLOCK TABLES;
232
233--
234-- Table structure for table `eventcode`
235--
236
237DROP TABLE IF EXISTS `eventcode`;
238SET @saved_cs_client = @@character_set_client;
239SET character_set_client = utf8;
240CREATE 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;
248SET character_set_client = @saved_cs_client;
249
250--
251-- Dumping data for table `eventcode`
252--
253
254LOCK TABLES `eventcode` WRITE;
255/*!40000 ALTER TABLE `eventcode` DISABLE KEYS */;
256/*!40000 ALTER TABLE `eventcode` ENABLE KEYS */;
257UNLOCK TABLES;
258
259--
260-- Current Database: `patientcorrelationdb`
261--
262
263CREATE DATABASE /*!32312 IF NOT EXISTS*/ `patientcorrelationdb` /*!40100 DEFAULT CHARACTER SET latin1 */;
264
265USE `patientcorrelationdb`;
266
267--
268-- Table structure for table `correlatedidentifiers`
269--
270
271DROP TABLE IF EXISTS `correlatedidentifiers`;
272SET @saved_cs_client = @@character_set_client;
273SET character_set_client = utf8;
274CREATE 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;
282SET character_set_client = @saved_cs_client;
283
284--
285-- Dumping data for table `correlatedidentifiers`
286--
287
288LOCK TABLES `correlatedidentifiers` WRITE;
289/*!40000 ALTER TABLE `correlatedidentifiers` DISABLE KEYS */;
290INSERT 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 */;
292UNLOCK 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
Note: See TracBrowser for help on using the repository browser.