| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary key |
globally unique identifier | |
| db_table_id |
Table.id of the linked entity |
globally unique identifier | |
| db_table_name |
Table.name of the linked entity |
string | |
| id_in_table |
Id of the linked entity |
globally unique identifier | |
| name |
Name of the file |
string | |
| description |
Description of the file |
string | |
| file_name |
File_name of the file |
string | |
| file_content |
Content of the file as Byte Array. |
Collection of byte | |
| image_width |
In case of picture, the original width |
integer | |
| image_height |
In case of picture, the original height |
integer | |
| date_update |
Update date, auto filled by Now if no value received |
date | |
| mime_type |
Mime-type of the file.Used when redirect user to the data, like application/pdf or image/jpeg |
string | |
| file_type_name |
Constant in case of specific file. Can be JOB_APPROVAL, ORDERPDF, PURCHASE_ORDERPDF |
string | |
| file_size |
Size in bytes of the file_content |
integer | |
| date_add |
Date when file has been added |
date | |
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date |
