jimtng

Changes pushed. I'll mark the relevant comments as resolved to keep track of things. Feel free to add new code comments if needed.

> ideally, you could also include a table for tags listing each field, as you did for things and items. Working on it

rebased to main. @lolodomo, I've also added a table for tags and refined the text.

> Minor comment: you named the column "Configuration Key" while it is just "Key" in all other tables. Good catch! That was a recent change. Fixed now.

rebased, conflict resolved

ping @mherwege @rkoshak

> How does this interact with restoreOnStartup? If an item is restored and not changed does this return the restored time or null? It is not aware of persistence restoration,...

> Imho it should be possible to query these values from the db so restore on startup should work as expected. @spacemanspiff2007 would you mind elaborating this please? > Will...

> It's possible to query the last persisted state from persistence and subsequently restore this state as the current state on startup. Yes, isn't this what `restoreOnStartup` does? > It's...

@spacemanspiff2007 I've added it to the REST response ```json { "link": "http://192.168.1.10:8484/rest/items/TestSwitch1", "state": "ON", "previousState": "NULL", "lastUpdate": 1723872081231, "lastChange": 1723871965049, "editable": false, "type": "Switch", "name": "TestSwitch1", "tags": [], "groupNames": [...