Tables [dbo].[ECR_Document_Mapping]
ECR Request and Response Document IDs
KeyNameData TypeMax Length (Bytes)NullabilityIdentityDefaultDescription
Cluster Primary Key PK_dbo.ECR_Document_Mapping: IDIDbigint8NOT NULL1 - 1Key to the ECR_Document_Mapping Table
Indexes NIX_ECR_Document_Mapping_MessageIDMessageIDuniqueidentifier16NOT NULLGUID received from the PHR Connect Message
Indexes NIX_ECR_Document_Mapping_MessageIDForeign Keys FK_ECR_Document_Mapping_RequestDocumentID: [dbo].[Document].RequestDocumentIDRequestDocumentID[dbo].[uniqueid]9NULL allowedDocument ID of the ECR Request document imported into dbo.Document table
Indexes NIX_ECR_Document_Mapping_MessageIDForeign Keys FK_ECR_Document_Mapping_ResponseDocumentID: [dbo].[Document].ResponseDocumentIDResponseDocumentID[dbo].[uniqueid]9NULL allowedDocument ID of the ECR Response document imported into dbo.Document table
CreatedDTTMdatetime8NOT NULL(getdate())Created Date time
LastUpdatedDTTMdatetime8NOT NULL(getdate())Last Updated Date time