| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier | |
| jobs_id |
Job Id |
globally unique identifier | |
| user_id |
User Id |
globally unique identifier | |
| date_create |
Date+Time in UTC when the row has been created |
date | |
| date_proceeded |
Date+Time in UTC when the Dispatch goes to PLanned or Rejected |
date | |
| is_accepted |
Case the technician accept it. |
boolean | |
| is_rejected |
Case the technician reject it |
boolean | |
| rejected_reason |
In case the technician reject it, what is the reason |
string | |
| sys_logical_delete |
Boolean used to logically delete the record. This is to optimize the synchronization. sys_logical_delete doesn't need to be proceeded offline (record can be physically deleted offline) |
boolean | |
| is_workshop |
Using to distinguish between dispatch and workshop |
boolean | |
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date | |
| sequence |
sequence |
integer | |
| assigned_user_ids |
The list of user_id that assigned to the job, separate by commas. It's not a real column |
string |