DocumentExport


Columns

Column Type Size Nulls Auto Default Children Parents Comments
ID int identity 4 √ null
ReferralID int 4 null
RecordID varchar 255 null
ReferralType int 4 null
DocumentExportReferralType.ID FK_DocumentExport_DocumentExportReferralTypeR
Type int 4 null
DocumentExportType.ID FK_DocumentExport_DocumentExportTypeR
DateSent datetime2 54 null
Payload varchar 2147483647 √ null
DateProcessed datetime2 54 √ null
Message varchar 2147483647 √ null
Response varchar 2147483647 √ null
Status int 4 null
DocumentExportMessageStatus.ID FK_DocumentExport_DocumentExportMessageStatusR
Username nvarchar 512 null
EventDate datetime2 54 √ null
ClinicCode varchar 50 √ null
DocumentID uniqueidentifier 16 √ null

Indexes

Constraint Name Type Sort Column(s)
PK_DocumentExport Primary key Asc ID

Relationships

Close relationships within degrees of separation