Data model
The insights that were identified through the discovery phase and with the help of the data
flow for this project were translated into the queries that the database is able to answer;
then we listed the information needed to respond them and draft how to organize it,
according to information buckets (types of entities described in the database, called
templates in Uwazi), establishing relationships between them, and defining the possible
description values (called thesauri in Uwazi).
Almost every process stage in the workflow constitutes a new entity in the database: complaint
submission, complaint registration, initial investigation, second investigation, call for conciliation,
closure, etc. However, all these elements, except complaint submission and complaint
registration, are gathered within the same type of element called complaint stage:
Diagram 2. Data structure with each complaint stage represented as a property
8