| Name | Description | Type | Additional information |
|---|---|---|---|
| id |
Primary Key |
globally unique identifier | |
| jobs_id |
FK of a jobs |
globally unique identifier | |
| work_instruction_details_id |
Work instruction details id |
globally unique identifier | |
| user_id |
Filled with the person that update it |
globally unique identifier | |
| work_instruction_action_type_id | globally unique identifier | ||
| work_instruction_action_type |
What is the action type (like repair, change) |
string | |
| name |
Name |
string | |
| status |
One of the constant value, can be Ok,NotOk,Replaced,NotApplicable |
string | |
| date_done |
When going to a status (like ok, not ok, replace , notapplicable) this date is set |
date | |
| remark |
Additional info |
string | |
| advise |
In case of a problem, an advice can be asked |
string | |
| sequence |
Order field, sequence asc (0 is first) |
integer | |
| work_instruction_id |
FK of the "header" |
globally unique identifier | |
| job_work_instruction_details_id |
For later |
globally unique identifier | |
| modified_dateutc |
Readonly system field managed by database, filled with GetUtcDate when adding,updating |
date | |
| db_file_ids |
db_file_ids |
string | |
| db_report_id |
db_report_id |
globally unique identifier | |
| parent_id |
parent_id |
globally unique identifier | |
| is_group |
is_group |
boolean | |
| type |
Type |
string | |
| db_report_type_id |
db_report_type_id |
globally unique identifier | |
| instruction_document_count |
instruction_document_count |
integer | |
| show_ok |
show_ok flag |
boolean | |
| show_nok |
show_nok flag |
boolean | |
| show_replaced |
show_replaced flag |
boolean | |
| show_na |
show_na flag |
boolean | |
| db_file_id |
db_file_id |
globally unique identifier | |
| work_instruction_type_id | globally unique identifier | ||
| show_options | string | ||
| is_customized | boolean |