Document
Contains documents that are attached to software items and other entities.
erDiagram
Document ||--o{ ObjectDocument : "DocumentID"
Document ||--o{ SoftwareItemDocument : "DocumentID"
Fields
| Field |
Type |
Description |
| Blob |
varbinary |
The document content as binary data |
| Created |
datetime |
Date/Time this document was created in the database |
| CreatedBy |
string |
User that created this document in the database |
| Description |
string |
Description of the document |
| DocumentHash |
string |
SHA1 hash of the document content. Used to detect duplicate documents. Currently not used. |
| ExternalDocumentLink |
string |
URL to an external document. This is used to link to documents that are not stored in the OctoSAM database. |
| ExtraData |
string |
Extra JSON data for this document. This is used to store additional information that is not part of the standard document schema. |
| Filename |
string |
File name of the document. This is used to display the document in the UI and to download it. |
| Guid |
guid |
Unique identifier for this document. This is used to reference the document in the OctoSAM application. |
| ID |
numeric |
Internal ID for the Document entity (Primary Key) |
| LastModification |
datetime |
Date/Time this document was last modified in the database |
| LastModifiedBy |
string |
User that last modified this document in the database |
| Preview |
varbinary |
Reserved for future use. Currently not used. |
| Size |
numeric |
Size of the document in bytes. This is used to display the size of the document in the UI. |
Referenced by
| Table |
Column Name |
Description |
| ObjectDocument |
DocumentID |
Relation between OctoSAM objects and assigned documents |
| SoftwareItemDocument |
DocumentID |
Relation between SoftwareItem and Document entities |