Table that stores the error log of the work order assignment
Data model
Fields
| Field | Type | Description |
|---|---|---|
| error_id* | SMALLINT | Error message ID |
| last_error* | BIT | Indicates if it is the last error generated |
| log_date* | DATETIME | Record creation date |
| log_error_attempts* | INT | Work order assignment attempt number |
| log_id* | INT | Unique identifier of the table |
| work_id* | INT | Work Order Identifier |
Primary Key
| PK_AFLS_WORKORDER_ASSIGN_LOGS |
|---|
| log_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| error_id* | dbo.AFLS_ERROR_MESSAGES | error_id | FK02_AFLS_WORKORDER_ASSIGN_LOGS |
| work_id* | dbo.AFLS_WORKORDERS | work_id | FK01_AFLS_WORKORDER_ASSIGN_LOGS |