| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier | |
| company_id |
Foreign key of the company this file is attached to. |
globally unique identifier | |
| file_name |
Original file name, including extension. |
string | |
| name |
Display name of the file. |
string | |
| description |
Free-text description of the file. |
string | |
| file_type |
File type/category classification. |
string | |
| mime_type |
MIME type of the file (e.g. "application/pdf", "image/jpeg"). |
string | |
| image_width |
Width of the file, in pixels, when it is an image. |
integer | |
| image_heigth |
Height of the file, in pixels, when it is an image. |
integer | |
| file_size |
Size of the file, in bytes. |
integer | |
| date_update |
Local date and time the file was last updated. |
date | |
| date_add |
Local date and time the file was added. |
date | |
| dateutc_add |
UTC date and time the file was added. |
date | |
| user_id |
Foreign key of the user who added this file. |
globally unique identifier | |
| is_showonweb |
Indicates whether this file should be shown on the customer-facing web/e-Service portal. |
boolean | |
| file_content |
Raw binary content of the file. |
Collection of byte | |
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date |