Store distribution project executions by device
Data model
Fields
| Field | Type | Description |
|---|---|---|
| device_id* | INT | Device Identifier |
| execution_id* | INT | Execution ID |
| executionfinish | DATETIME | Execution end date |
| executionstart | DATETIME | Execution start date |
| id* | INT | Device execution ID |
| status* | INT | Device Execution Status |
| update_date | DATETIME | Execution Update Date |
Primary Key
| PK_ASD_EXECUTION_DEVICE |
|---|
| id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| device_id* | dbo.AAM_DEVICE | id | FK02_ASD_EXECUTION_DEVICE |
| execution_id* | Bod. ASD_EXECUTION | id | FK01_ASD_EXECUTION_DEVICE |