The table inventory_devices stores the device mappings of all items known to the inventory database.
| Field | null | Description |
|---|---|---|
| device_id | no | A unique ID of this record (auto generated). |
| item_no | yes | The ID of the item this device is mapped to |
| mnc_name | yes | The M&C name |
| device_name | yes | The device name |
| state | no | The administrative state of the device |
| online | yes | Boolean flag indicating if the device is online |
| modified | no | automatically created timestamp of last change |