| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary key |
globally unique identifier |
Required |
| jobs_id |
FK to jobs.id |
globally unique identifier | |
| job_name |
jobs.name |
string | |
| date_from |
Date from |
date | |
| date_to |
Date to |
date | |
| job_status_id |
FK to job_status.id |
globally unique identifier | |
| sys_logical_delete | boolean | ||
| field_accept_date_max_timeout |
Date max time out for field accept |
date | |
| dateutc_in_progress |
Date utc when job is put in progress |
date | |
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date | |
| user_id | globally unique identifier | ||
| travel_to |
travel_to |
integer | |
| travel_back |
travel_back |
integer |