The table inventory_items stores the properties of all items known to the inventory database.
| Field | null | Description |
|---|---|---|
| item_id | no | A unique ID of this record (auto generated). |
| serial_no | yes | The serial number of the item / device |
| vendor | yes | The vendor name (for search filters) |
| model | yes | The model name (for search filters) |
| state | no | The administrative state of the device |
| comment | yes | free text |
| modified | no | automatically created timestamp of last change |