Table that stores device-related conflicts
Data model
Fields
| Field | Type | Description |
|---|---|---|
| conflict_action_id* | INT | Identifier of the action to be taken to resolve the conflict |
| conflict_cause_id* | INT | Identifier of the cause of the conflict |
| conflict_type_id* | INT | Conflict type identifier |
| date* | DATETIME | Date the conflict is created |
| device_id* | INT | Device Identifier |
| id* | INT | Unique identifier of the conflict |
| status_id* | INT | Conflict status identifier |
Primary Key
| PK_AAM_DEVICE_CONFLICT |
|---|
| id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| conflict_action_id* | Bod. AAM_DEVICE_CONFLICT_ACT | id | FK02_AAM_DEVICE_CONFLICT |
| conflict_cause_id* | Bod. AAM_DEVICE_CONFLICT_CAUSE | id | FK03_AAM_DEVICE_CONFLICT |
| conflict_type_id* | Bod. AAM_DEVICE_CONFLICT_TYPE | id | FK04_AAM_DEVICE_CONFLICT |
| device_id* | dbo.AAM_DEVICE | id | FK01_AAM_DEVICE_CONFLICT |
| status_id* | Bod. AAM_DEVICE_CONFLICT_STATU | id | FK05_AAM_DEVICE_CONFLICT |