Key | Name | Data Type | Max Length (Bytes) | Nullability | Description |
---|
| PatientID | numeric(16,0) | 9 | NOT NULL | Patient. Link to Works.dbo.Patient_Member.ID |
| SubFolder | varchar(130) | 130 | NOT NULL | Folder Name |
| FileName | varchar(256) | 256 | NOT NULL | Name of the File |
 | DocumentID | bigint | 8 | NOT NULL | Unique Identifier used for document on patients chart |
| Page | smallint | 2 | NOT NULL | Page number |
![Check Constraints CK_Doc_Detail_Orientation : ([Orientation]=(4) OR [Orientation]=(3) OR [Orientation]=(2) OR [Orientation]=(1) OR [Orientation]=(0)) Check Constraints CK_Doc_Detail_Orientation : ([Orientation]=(4) OR [Orientation]=(3) OR [Orientation]=(2) OR [Orientation]=(1) OR [Orientation]=(0))](../../../../Images/c-constraint.png) | Orientation | tinyint | 1 | NOT NULL | 0-4, used to control orientation we display image to end user |
| LastChange | datetime | 8 | NOT NULL | Date image was last edited. |
| AcquireDate | datetime | 8 | NOT NULL | Date image was scanned into new scan |
| ObjectStorageID | bigint | 8 | NOT NULL | External Storage identifier. |