Document¶
Contains documents that are attached to software items and other entities.
Fields¶
| Field | Type | Description |
|---|---|---|
| Blob | varbinary | The document content as binary data |
| Created | datetime2 | Date/Time this document was created in the database |
| CreatedBy | nvarchar | User that created this document in the database |
| Description | nvarchar | Description of the document |
| DocumentHash | nvarchar | SHA1 hash of the document content. Used to detect duplicate documents. Currently not used. |
| ExternalDocumentLink | nvarchar | Url to an external document. This is used to link to documents that are not stored in the OctoSAM database. |
| ExtraData | nvarchar | Extra JSON data for this document. This is used to store additional information that is not part of the standard document schema. |
| Filename | nvarchar | File name of the document. This is used to display the document in the UI and to download it. |
| Guid | uniqueidentifier | Unique identifier for this document. This is used to reference the document in the OctoSAM application. |
| ID | bigint | Internal ID for the Document entity (Primary Key) |
| LastModification | datetime2 | Date/Time this document was last modified in the database |
| LastModifiedBy | nvarchar | User that last modified this document in the database |
| Preview | varbinary | Reserverd for future use. Currently not used. |
| Size | bigint | Size of the document in bytes. This is used to display the size of the document in the UI. |