| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier |
Required |
| job_measurement_id |
FK to job_measurement |
globally unique identifier | |
| measure_code | string |
Max length: 50 |
|
| measure_name | string |
Max length: 50 |
|
| measure_unit_code | string |
Max length: 50 |
|
| measure_unit_name | string |
Max length: 50 |
|
| measured_value | string |
Max length: 255 |
|
| display_measured_value | string |
Max length: 255 |
|
| sys_logical_delete | boolean | ||
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date |