| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary key |
globally unique identifier |
Required |
| db_table_id |
Table.id of the linked entity |
globally unique identifier | |
| id_in_table |
Id of the linked entity |
globally unique identifier | |
| file_type |
Free-text classification of this file's type/purpose. |
string | |
| is_default |
Indicates this is the default/primary file for the linked entity. |
boolean | |
| file_name |
File_name of the file |
string | |
| mime_type |
MIME type of the file (e.g. "application/pdf", "image/jpeg"). |
string | |
| file_content |
Raw binary content of the file. |
Collection of byte | |
| image_width |
In case of picture, the original width |
integer | |
| image_heigth |
In case of picture, the original heigth |
integer | |
| user_id |
Foreign key of the user who uploaded this file. |
globally unique identifier | |
| description |
Free-text description of the file. |
string | |
| tags |
Free-text, comma-separated tags applied to this file (denormalized summary; see for the structured link). |
string | |
| date_update |
Local date and time this file was last updated. |
date | |
| date_add |
Local date and time this file was added. |
date | |
| dateutc_add |
UTC date and time this file was added. |
date | |
| name |
Display name of the file. |
string | |
| file_size |
Size of the file, in bytes. |
integer | |
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date | |
| is_showonweb |
Is available on ServiceDesk? |
boolean | |
| sys_logical_delete |
Soft-delete flag: when true, this file is considered deleted, optimizing synchronization (can be physically deleted offline). |
boolean |