| Database Table Document |
[This is preliminary documentation and is subject to change.]
The Document table holds data about uploaded documents. Each row represents one uploaded document and some metadata about it.
FieldsField name | Type | Note | Description |
|---|---|---|---|
Id | int | Primary key | Internal unique id. |
CreatedDateTime | DateTime | Date and time for uploading the document. | |
CreatedBy | int | Reference to Employee: id of user who uploaded the document. | |
UpdatedDateTime | DateTime | Date and time for latest updates to the document metadata. | |
UpdatedBy | int | Employee who made latest upload or updated to document | |
DeletedDateTime | int | Date and time the document was deleted | |
DeletedBy | int | Employee who deleted the document | |
DateFrom | DateTime | Date from which the document is valid. | |
DateTo | DateTime | Date after which the document is no longer valid | |
Title | varchar(2000) | Title of document | |
Description | varchar(max) | Description of document | |
DocumentFileName | varchar(2000) | Filename of the uploaded document | |
DocumentFileData | varbinary(max) | Binary content of the uploaded document |