| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier |
Required |
| db_report_id |
FK to db_report |
globally unique identifier | |
| db_info_field_id |
FK to db_info_field |
globally unique identifier | |
| user_id | globally unique identifier | ||
| dateutc_done |
Date+Time in UTC when it has been collected |
date | |
| date_done |
Local Date+Time when it has been collected |
date | |
| rawdata |
The rawdata that comes from the device |
string | |
| collected_with_device |
To know if it was collected via a device (like Testo) |
boolean | |
| device_name | string |
Max length: 50 |
|
| device_serial_number | string |
Max length: 50 |
|
| device_firmware_version | string |
Max length: 50 |
|
| device_firmware_date | date | ||
| sys_logical_delete | boolean | ||
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date |