This should be an implementation of the feature request from @jdswinbank described [here](https://github.com/transientskp/tkp/issues/597#issuecomment-1580845052). Any code change which affects the database schema should be reflected by an updated ER diagram as part of the documentation.