| 1 | /*
|
|---|
| 2 | Table creation script for the BHIE Facade Stop-Gap document repository.
|
|---|
| 3 |
|
|---|
| 4 | This script was intended to be run on MySQL.
|
|---|
| 5 |
|
|---|
| 6 | Please see the DatabaseInstructions.txt file for database creation and configuration instructions.
|
|---|
| 7 | */
|
|---|
| 8 |
|
|---|
| 9 | DROP TABLE IF EXISTS document CASCADE;
|
|---|
| 10 | CREATE TABLE document (
|
|---|
| 11 | documentid INTEGER NOT NULL,
|
|---|
| 12 | DocumentUniqueId VARCHAR(64) NOT NULL,
|
|---|
| 13 | DocumentTitle VARCHAR(128),
|
|---|
| 14 | authorPerson VARCHAR(64),
|
|---|
| 15 | authorInstitution VARCHAR(64),
|
|---|
| 16 | authorRole VARCHAR(64),
|
|---|
| 17 | authorSpecialty VARCHAR(64),
|
|---|
| 18 | AvailabilityStatus VARCHAR(64),
|
|---|
| 19 | ClassCode VARCHAR(64),
|
|---|
| 20 | ClassCodeScheme VARCHAR(64),
|
|---|
| 21 | ClassCodeDisplayName VARCHAR(64),
|
|---|
| 22 | ConfidentialityCode VARCHAR(64),
|
|---|
| 23 | ConfidentialityCodeScheme VARCHAR(64),
|
|---|
| 24 | ConfidentialityCodeDisplayName VARCHAR(64),
|
|---|
| 25 | CreationTime DATETIME COMMENT 'Date format expected: MM/dd/yyyy.HH:mm:ss',
|
|---|
| 26 | FormatCode VARCHAR(64),
|
|---|
| 27 | FormatCodeScheme VARCHAR(64),
|
|---|
| 28 | FormatCodeDisplayName VARCHAR(64),
|
|---|
| 29 | PatientId VARCHAR(64) COMMENT 'Format of HL7 2.x CX',
|
|---|
| 30 | ServiceStartTime DATETIME COMMENT 'Format of YYYYMMDDHHMMSS',
|
|---|
| 31 | ServiceStopTime DATETIME COMMENT 'Format of YYYYMMDDHHMMSS',
|
|---|
| 32 | Status VARCHAR(64),
|
|---|
| 33 | Comments VARCHAR(256),
|
|---|
| 34 | Hash VARCHAR(1028) COMMENT 'Might be better to derive',
|
|---|
| 35 | FacilityCode VARCHAR(64),
|
|---|
| 36 | FacilityCodeScheme VARCHAR(64),
|
|---|
| 37 | FacilityCodeDisplayName VARCHAR(64),
|
|---|
| 38 | IntendedRecipientPerson VARCHAR(128) COMMENT 'Format of HL7 2.x XCN',
|
|---|
| 39 | IntendedRecipientOrganization VARCHAR(128) COMMENT 'Format of HL7 2.x XON',
|
|---|
| 40 | LanguageCode VARCHAR(64),
|
|---|
| 41 | LegalAuthenticator VARCHAR(128) COMMENT 'Format of HL7 2.x XCN',
|
|---|
| 42 | MimeType VARCHAR(32),
|
|---|
| 43 | ParentDocumentId VARCHAR(64),
|
|---|
| 44 | ParentDocumentRelationship VARCHAR(64),
|
|---|
| 45 | PracticeSetting VARCHAR(64),
|
|---|
| 46 | PracticeSettingScheme VARCHAR(64),
|
|---|
| 47 | PracticeSettingDisplayName VARCHAR(64),
|
|---|
| 48 | Size Integer,
|
|---|
| 49 | SourcePatientId VARCHAR(128) COMMENT 'Format of HL7 2.x CX',
|
|---|
| 50 | Pid3 VARCHAR(128),
|
|---|
| 51 | Pid5 VARCHAR(128),
|
|---|
| 52 | Pid7 VARCHAR(128),
|
|---|
| 53 | Pid8 VARCHAR(128),
|
|---|
| 54 | Pid11 VARCHAR(128),
|
|---|
| 55 | TypeCode VARCHAR(64),
|
|---|
| 56 | TypeCodeScheme VARCHAR(64),
|
|---|
| 57 | TypeCodeDisplayName VARCHAR(64),
|
|---|
| 58 | DocumentUri VARCHAR(128) COMMENT 'May derive this value',
|
|---|
| 59 | RawData BLOB,
|
|---|
| 60 | Persistent Integer NOT NULL
|
|---|
| 61 | );
|
|---|
| 62 |
|
|---|
| 63 | ALTER TABLE document
|
|---|
| 64 | ADD CONSTRAINT document_pk PRIMARY KEY(documentid);
|
|---|
| 65 |
|
|---|
| 66 | DROP TABLE IF EXISTS eventcode CASCADE;
|
|---|
| 67 | CREATE TABLE eventcode (
|
|---|
| 68 | eventcodeid INTEGER NOT NULL,
|
|---|
| 69 | documentid INTEGER NOT NULL COMMENT 'Foriegn key to document table',
|
|---|
| 70 | EventCode VARCHAR(64),
|
|---|
| 71 | EventCodeScheme VARCHAR(64),
|
|---|
| 72 | EventCodeDisplayName VARCHAR(64)
|
|---|
| 73 | );
|
|---|
| 74 |
|
|---|
| 75 | ALTER TABLE eventcode
|
|---|
| 76 | ADD CONSTRAINT eventcode_pk PRIMARY KEY (eventcodeid);
|
|---|
