JCM Table: dbo.PT Document
From Sherlock Software
TABLE NAME: dbo.PT_Document
| Col ID | Name | Data Type | Description |
|---|---|---|---|
| 1 | DocID | int | |
| 2 | CaseID | int | |
| 3 | DocTypeID | tinyint | |
| 4 | FileName | nvarchar(255) | |
| 5 | Extension | nvarchar(50) | |
| 6 | DocBody | varbinary | |
| 7 | Comments | ntext | |
| 8 | DocProperties | xml | |
| 9 | RowStatus | tinyint | |
| 10 | GUID | varchar(36) | |
| 11 | CreateBy | int | |
| 12 | DateCreated | datetime | |
| 13 | DateModified | datetime |
Back to JCM Database tables
