Tables [dbo].[Doc_Header]
Header information about document (Document type, number of pages, orientation etc..)
KeyNameData TypeMax Length (Bytes)NullabilityDescription
Cluster Primary Key PK_Doc_Header_DocumentID: DocumentIDDocumentIDbigint8NOT NULLKey to the Doc_Header table
Indexes NIX_Doc_Header_PatientIDPatientIDnumeric(16,0)9NOT NULLPatient. Link to Works.dbo.Patient_Member.ID
DocumentTypeDEnumeric(8,0)5NULL allowedDocument Type. Link to Works.dbo.Document_Type_DE.ID
Foreign Keys FK_Doc_Header_FileType: [dbo].[FileTypes].FileTypeFileTypesmallint2NOT NULLFile Type ( .pdf, .tif etc..). Link to FileTypes.ID
DocumentDatedatetime8NOT NULLDate given to the document (User can fill in from application)
AcquireDatedatetime8NOT NULLDate document was sorted in new scan
LastChangedatetime8NOT NULLDate document was last edited.
PageCountsmallint2NOT NULLNumber of pages of this document.