source: ccr/trunk/nhin-vista/projects/NHINC/Current/ThirdParty/DatabaseSchemaDump/auditlog.dump@ 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: 16.2 KB
Line 
1-- MySQL dump 10.11
2--
3-- Host: localhost Database: auditlog
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-- Table structure for table `eventlog`
20--
21
22DROP TABLE IF EXISTS `eventlog`;
23SET @saved_cs_client = @@character_set_client;
24SET character_set_client = utf8;
25CREATE TABLE `eventlog` (
26 `id` bigint(20) unsigned NOT NULL auto_increment,
27 `timeStamp` datetime default NULL,
28 `userId` varchar(100) default NULL,
29 `participationTypeCode` smallint(5) unsigned default NULL,
30 `participationTypeCodeRole` smallint(5) unsigned default NULL,
31 `participationIDTypeCode` varchar(100) default NULL,
32 `patientId` varchar(100) default NULL,
33 `message` blob,
34 `communityId` varchar(255) default NULL,
35 PRIMARY KEY USING BTREE (`id`),
36 KEY `userId_index` USING BTREE (`userId`),
37 KEY `communityId_index` (`communityId`)
38) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=latin1;
39SET character_set_client = @saved_cs_client;
40
41--
42-- Dumping data for table `eventlog`
43--
44
45LOCK TABLES `eventlog` WRITE;
46/*!40000 ALTER TABLE `eventlog` DISABLE KEYS */;
47INSERT INTO `eventlog` VALUES (1,NULL,'uId999',7,7,'IDTypeCd999','PID999',NULL,'CommId999'),(2,'2008-07-18 13:40:46','',5,6,'webId123','web123',NULL,'WebComm123'),(3,NULL,'',7,8,'SOAPId123','soap123',NULL,'SOAPComm123'),(4,NULL,'',9,10,'SOAPId456','soap123',NULL,'SOAPComm456'),(5,NULL,'valluripallis',9,10,'SOAPId456','soap123',NULL,'SOAPComm456'),(6,'2008-07-18 00:30:47','valluripallis',9,10,'SOAPId456','soap123',NULL,'SOAPComm456'),(7,'2008-07-21 21:56:11','valluripallis',7,8,'webId456','web456',NULL,'WebComm456'),(8,'2008-07-23 14:27:41','valluripallis',9,1,'webId789','web789','<!-- edited with XMLSPY v2004 rel. 3 U (http://www.xmlspy.com) by Glen F. Marshall (HL7 Technical Steering Committee) -->\n<xs:schema xmlns:xs=\"http://www.w3.org/2001/XMLSchema\" elementFormDefault=\"qualified\" attributeFormDefault=\"unqualified\">\n <xs:element name=\"AuditMessage\">\n <xs:complexType>\n <xs:sequence>\n <xs:element name=\"EventIdentification\" type=\"EventIdentificationType\"/>\n <xs:element name=\"ActiveParticipant\" maxOccurs=\"unbounded\">\n <xs:complexType>\n <xs:complexContent>\n <xs:extension base=\"ActiveParticipantType\"/>\n </xs:complexContent>\n </xs:complexType>\n </xs:element>\n <xs:element name=\"AuditSourceIdentification\" type=\"AuditSourceIdentificationType\" maxOccurs=\"unbounded\"/>\n <xs:element name=\"ParticipantObjectIdentification\" type=\"ParticipantObjectIdentificationType\" minOccurs=\"0\" maxOccurs=\"unbounded\"/>\n </xs:sequence>\n </xs:complexType>\n </xs:element>\n <xs:complexType name=\"EventIdentificationType\">\n <xs:sequence>\n <xs:element name=\"EventID\" type=\"CodedValueType\"/>\n <xs:element name=\"EventTypeCode\" type=\"CodedValueType\" minOccurs=\"0\" maxOccurs=\"unbounded\"/>\n </xs:sequence>\n <xs:attribute name=\"EventActionCode\" use=\"optional\">\n <xs:simpleType>\n <xs:restriction base=\"xs:string\">\n <xs:enumeration value=\"C\">\n <xs:annotation>\n <xs:appinfo>Create</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"R\">\n <xs:annotation>\n <xs:appinfo>Read</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"U\">\n <xs:annotation>\n <xs:appinfo>Update</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"D\">\n <xs:annotation>\n <xs:appinfo>Delete</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"E\">\n <xs:annotation>\n <xs:documentation>Execute</xs:documentation>\n </xs:annotation>\n </xs:enumeration>\n </xs:restriction>\n </xs:simpleType>\n </xs:attribute>\n <xs:attribute name=\"EventDateTime\" type=\"xs:dateTime\" use=\"required\"/>\n <xs:attribute name=\"EventOutcomeIndicator\" use=\"required\">\n <xs:simpleType>\n <xs:restriction base=\"xs:integer\">\n <xs:enumeration value=\"0\">\n <xs:annotation>\n <xs:appinfo>Success</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"4\">\n <xs:annotation>\n <xs:appinfo>Minor failure</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"8\">\n <xs:annotation>\n <xs:appinfo>Serious failure</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"12\">\n <xs:annotation>\n <xs:appinfo>Major failure; action made unavailable \n </xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n </xs:restriction>\n </xs:simpleType>\n </xs:attribute>\n </xs:complexType>\n <xs:complexType name=\"AuditSourceIdentificationType\">\n <xs:sequence>\n <xs:element name=\"AuditSourceTypeCode\" type=\"CodedValueType\" minOccurs=\"0\" maxOccurs=\"unbounded\"/>\n </xs:sequence>\n <xs:attribute name=\"AuditEnterpriseSiteID\" type=\"xs:string\" use=\"optional\"/>\n <xs:attribute name=\"AuditSourceID\" type=\"xs:string\" use=\"required\"/>\n </xs:complexType>\n <xs:complexType name=\"ActiveParticipantType\">\n <xs:sequence minOccurs=\"0\">\n <xs:element name=\"RoleIDCode\" type=\"CodedValueType\" minOccurs=\"0\" maxOccurs=\"unbounded\"/>\n </xs:sequence>\n <xs:attribute name=\"UserID\" type=\"xs:string\" use=\"required\"/>\n <xs:attribute name=\"AlternativeUserID\" type=\"xs:string\" use=\"optional\"/>\n <xs:attribute name=\"UserName\" type=\"xs:string\" use=\"optional\"/>\n <xs:attribute name=\"UserIsRequestor\" type=\"xs:boolean\" use=\"optional\" default=\"true\"/>\n <xs:attribute name=\"NetworkAccessPointID\" type=\"xs:string\" use=\"optional\"/>\n <xs:attribute name=\"NetworkAccessPointTypeCode\" use=\"optional\">\n <xs:simpleType>\n <xs:restriction base=\"xs:unsignedByte\">\n <xs:enumeration value=\"1\">\n <xs:annotation>\n <xs:appinfo>Machine Name, including DNS name</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"2\">\n <xs:annotation>\n <xs:appinfo>IP Address</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"3\">\n <xs:annotation>\n <xs:appinfo>Telephone Number</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n </xs:restriction>\n </xs:simpleType>\n </xs:attribute>\n </xs:complexType>\n <xs:complexType name=\"ParticipantObjectIdentificationType\">\n <xs:sequence>\n <xs:element name=\"ParticipantObjectIDTypeCode\" type=\"CodedValueType\"/>\n <xs:choice minOccurs=\"0\">\n <xs:element name=\"ParticipantObjectName\" type=\"xs:string\" minOccurs=\"0\"/>\n <xs:element name=\"ParticipantObjectQuery\" type=\"xs:base64Binary\" minOccurs=\"0\"/>\n </xs:choice>\n <xs:element name=\"ParticipantObjectDetail\" type=\"TypeValuePairType\" minOccurs=\"0\" maxOccurs=\"unbounded\"/>\n </xs:sequence>\n <xs:attribute name=\"ParticipantObjectID\" type=\"xs:string\" use=\"required\"/>\n <xs:attribute name=\"ParticipantObjectTypeCode\" use=\"optional\">\n <xs:simpleType>\n <xs:restriction base=\"xs:unsignedByte\">\n <xs:enumeration value=\"1\">\n <xs:annotation>\n <xs:appinfo>Person</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"2\">\n <xs:annotation>\n <xs:appinfo>System object</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"3\">\n <xs:annotation>\n <xs:appinfo>Organization</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"4\">\n <xs:annotation>\n <xs:appinfo>Other</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n </xs:restriction>\n </xs:simpleType>\n </xs:attribute>\n <xs:attribute name=\"ParticipantObjectTypeCodeRole\" use=\"optional\">\n <xs:simpleType>\n <xs:restriction base=\"xs:unsignedByte\">\n <xs:enumeration value=\"1\">\n <xs:annotation>\n <xs:appinfo>Patient</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"2\">\n <xs:annotation>\n <xs:appinfo>Location</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"3\">\n <xs:annotation>\n <xs:appinfo> Report</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"4\">\n <xs:annotation>\n <xs:appinfo>Resource</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"5\">\n <xs:annotation>\n <xs:appinfo>Master file</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"6\">\n <xs:annotation>\n <xs:appinfo>User</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"7\">\n <xs:annotation>\n <xs:appinfo>List</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"8\">\n <xs:annotation>\n <xs:appinfo>Doctor</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"9\">\n <xs:annotation>\n <xs:appinfo>Subscriber</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"10\">\n <xs:annotation>\n <xs:appinfo>Guarantor</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"11\">\n <xs:annotation>\n <xs:appinfo>Security User Entity</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"12\">\n <xs:annotation>\n <xs:appinfo>Security User Group</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"13\">\n <xs:annotation>\n <xs:appinfo>Security Resource</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"14\">\n <xs:annotation>\n <xs:appinfo>Security Granualarity Definition</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"15\">\n <xs:annotation>\n <xs:appinfo>Provider</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"16\">\n <xs:annotation>\n <xs:appinfo>Report Destination</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"17\">\n <xs:annotation>\n <xs:appinfo>Report Library</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"18\">\n <xs:annotation>\n <xs:appinfo>Schedule</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"19\">\n <xs:annotation>\n <xs:appinfo>Customer</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"20\">\n <xs:annotation>\n <xs:appinfo>Job</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"21\">\n <xs:annotation>\n <xs:appinfo>Job Stream</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"22\">\n <xs:annotation>\n <xs:appinfo>Table</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"23\">\n <xs:annotation>\n <xs:appinfo>Routing Criteria</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"24\">\n <xs:annotation>\n <xs:appinfo>Query</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n </xs:restriction>\n </xs:simpleType>\n </xs:attribute>\n <xs:attribute name=\"ParticipantObjectDataLifeCycle\" use=\"optional\">\n <xs:simpleType>\n <xs:restriction base=\"xs:unsignedByte\">\n <xs:enumeration value=\"1\">\n <xs:annotation>\n <xs:appinfo>Origination / Creation</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"2\">\n <xs:annotation>\n <xs:appinfo>Import / Copy from original </xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"3\">\n <xs:annotation>\n <xs:appinfo>Amendment</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"4\">\n <xs:annotation>\n <xs:appinfo>Verification</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"5\">\n <xs:annotation>\n <xs:appinfo>Translation</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"6\">\n <xs:annotation>\n <xs:appinfo>Access / Use</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"7\">\n <xs:annotation>\n <xs:appinfo>De-identification</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"8\">\n <xs:annotation>\n <xs:appinfo>Aggregation, summarization, derivation</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"9\">\n <xs:annotation>\n <xs:appinfo>Report</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"10\">\n <xs:annotation>\n <xs:appinfo>Export / Copy to target</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"11\">\n <xs:annotation>\n <xs:appinfo>Disclosure</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"12\">\n <xs:annotation>\n <xs:appinfo>Receipt of disclosure</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"13\">\n <xs:annotation>\n <xs:appinfo>Archiving</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"14\">\n <xs:annotation>\n <xs:appinfo>Logical deletion</xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n <xs:enumeration value=\"15\">\n <xs:annotation>\n <xs:appinfo>Permanent erasure / Physical destruction </xs:appinfo>\n </xs:annotation>\n </xs:enumeration>\n </xs:restriction>\n </xs:simpleType>\n </xs:attribute>\n <xs:attribute name=\"ParticipantObjectSensitivity\" type=\"xs:string\" use=\"optional\"/>\n </xs:complexType>\n <xs:complexType name=\"CodedValueType\">\n <xs:attribute name=\"code\" type=\"xs:string\" use=\"required\"/>\n <xs:attributeGroup ref=\"CodeSystem\"/>\n <xs:attribute name=\"displayName\" type=\"xs:string\" use=\"optional\"/>\n <xs:attribute name=\"originalText\" type=\"xs:string\" use=\"optional\"/>\n </xs:complexType>\n <xs:complexType name=\"TypeValuePairType\">\n <xs:attribute name=\"type\" type=\"xs:string\" use=\"required\"/>\n <xs:attribute name=\"value\" type=\"xs:base64Binary\" use=\"required\"/>\n </xs:complexType>\n <xs:attributeGroup name=\"CodeSystem\">\n <xs:attribute name=\"codeSystem\" type=\"OID\" use=\"optional\"/>\n <xs:attribute name=\"codeSystemName\" type=\"xs:string\" use=\"optional\"/>\n </xs:attributeGroup>\n <xs:simpleType name=\"OID\">\n <xs:restriction base=\"xs:string\">\n <xs:whiteSpace value=\"collapse\"/>\n </xs:restriction>\n </xs:simpleType>\n</xs:schema>\n','WebComm789');
48/*!40000 ALTER TABLE `eventlog` ENABLE KEYS */;
49UNLOCK TABLES;
50/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
51
52/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
53/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
54/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
55/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
56/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
57/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
58/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
59
60-- Dump completed on 2008-07-28 18:45:53
Note: See TracBrowser for help on using the repository browser.