| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier |
Required |
| job_measurement_id |
FK to job_measurement |
globally unique identifier | |
| measure_code |
Code identifying which measurement type was measured (denormalized copy of ). |
string |
Max length: 50 |
| measure_name |
Display name of the measurement type (denormalized copy of ). |
string |
Max length: 50 |
| measure_unit_code |
Code of the unit of measure the value is expressed in. |
string |
Max length: 50 |
| measure_unit_name |
Display name of the unit of measure the value is expressed in. |
string |
Max length: 50 |
| measured_value |
Raw measured value, as text. |
string |
Max length: 255 |
| display_measured_value |
Formatted/display representation of (e.g. including unit), shown to end users. |
string |
Max length: 255 |
| sys_logical_delete |
Soft-delete flag: when true, this measurement detail 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 |