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	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	Reserverd 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.