Checking Datamodel Integrity

When you import data into your Zingoolarity instance, it might happen that you import data, which has relations to other data objects, which are not present in your Zingoolarity instance.

For example you may have imported some topics which use a custom state (e.g. in decision with the ID decision), which is not available in your Zingoolarity instance.

The database of Zingoolarity does not directly enforce these foreign key relationships for flexibility reasons; instead the Zingoolarity application assures the proper checking of relations during (for example) a delete operation.

You can use the Integrity function to verify all relations in the entire database (for example after an import), to make sure everything is in place.

Select the Integrity function from the main menu or the home screen:

(Integrity screen of Zingoolarity)

Zingoolarity will list all data objects and their primary ID foreign key relations.

Whenever something is encountered, which has a missing key, the concreted key ID is dumped in RED to the screen.

This gives you a chance to manually add the missing record and thereby fix the situation.

What will happen if foreign keys are missing?

In nearly all the cases, the related record will simply not show up in the frontend of Zingoolarity.

If you for example imported a topic with a state, which does not exist in your instance, the topic will simply not show up in the lists or the search and the record cannot be edited.

As soon as you add the missing state, the topic will automatically appear again.