Stores device binary information flags
Data model
Fields
| Field | Type | Description |
|---|---|---|
| device_id* | INT | Device identifier. Reference to the AMDM_DEVICE.id table |
| flag_id* | INT | Binary information flag identifier. Reference to the AMDM_FLAGDEVICE.id table |
| id* | INT | (Obsolete) Unique identifier of the device’s binary information flag |
| value | NVARCHAR (100) | Flag value on the device |
Primary Key
| PK_AMDM_DEVICEFLAGS |
|---|
| device_id, flag_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| device_id* | dbo.AMDM_DEVICE | id | FK_AMDM_DEVICEFLAGS_001 |
| flag_id* | Bod. AMDM_FLAGDEVICE | id | FK_AMDM_DEVICEFLAGS_002 |