| 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 |
Foreign key of the user who collected this measurement. |
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 |
Name/model of the measuring device used to collect this measurement (when is true). |
string |
Max length: 50 |
| device_serial_number |
Serial number of the measuring device used to collect this measurement. |
string |
Max length: 50 |
| device_firmware_version |
Firmware version of the measuring device used to collect this measurement. |
string |
Max length: 50 |
| device_firmware_date |
Release date of the device firmware identified by . |
date | |
| sys_logical_delete |
Soft-delete flag: when true, this measurement is considered deleted, optimizing synchronization (can be physically deleted offline). |
boolean | |
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date |