Key | Name | Data Type | Max Length (Bytes) | Nullability | Description |
---|
 | DocumentID | bigint | 8 | NOT NULL | Key to the Doc_Header table |
 | PatientID | numeric(16,0) | 9 | NOT NULL | Patient. Link to Works.dbo.Patient_Member.ID |
| DocumentTypeDE | numeric(8,0) | 5 | NULL allowed | Document Type. Link to Works.dbo.Document_Type_DE.ID |
![Foreign Keys FK_Doc_Header_FileType: [dbo].[FileTypes].FileType Foreign Keys FK_Doc_Header_FileType: [dbo].[FileTypes].FileType](../../../../Images/fk.png) | FileType | smallint | 2 | NOT NULL | File Type ( .pdf, .tif etc..). Link to FileTypes.ID |
| DocumentDate | datetime | 8 | NOT NULL | Date given to the document (User can fill in from application) |
| AcquireDate | datetime | 8 | NOT NULL | Date document was sorted in new scan |
| LastChange | datetime | 8 | NOT NULL | Date document was last edited. |
| PageCount | smallint | 2 | NOT NULL | Number of pages of this document. |