| 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. Defaults to when absent from the request body. |
date | |
| date_to |
Date to. Defaults to when absent from the request body. |
date | |
| job_status_id |
FK to job_status.id |
globally unique identifier | |
| sys_logical_delete |
Soft-delete flag: when true, this planning slot is considered deleted, optimizing synchronization (can be physically deleted offline). |
boolean | |
| field_accept_date_max_timeout |
Date max time out for field accept. Defaults to when absent from the request body. |
date | |
| dateutc_in_progress |
Date utc when job is put in progress. Defaults to when absent from the request body. |
date | |
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating. Defaults to , which the repositories read as "never modified" (they compare against year 1980). |
date | |
| user_id |
Foreign key of the user (technician) this planning slot is assigned to. |
globally unique identifier | |
| travel_to |
Estimated travel time to reach the job's location, in minutes. |
integer | |
| travel_back |
Estimated travel time to return from the job's location, in minutes. |
integer |