Stores device binary information flags
Data model
Fields
| Field | Type | Description |
|---|---|---|
| device_id* | INT | Device Identifier |
| flag_id* | INT | Binary Information Flag Identifier |
| 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* | dbo.AMDM_FLAGDEVICE | id | FK_AMDM_DEVICEFLAGS_002 |