Database Diagram

An overview of the data structure.

A database diagram for the validation pipeline.

This project does not require all that much data for its core functionality: the main items here are the ActionUnit Report (containing the data generated by the OpenFace analysis) and the Analysis Report (generated by the other analysis module).

ActionUnit reports contain the OpenFace data of a specific image or video. This data is stored in separate Data Entry objects, which are linked using a Foreign Key. ActionUnit reports are linked to an Analysis Report once the secondary analysis is complete. This secondary analysis consists of comparing the contents of an ActionUnit report to a specific set of user-defined parameters. These parameters are stored as ParameterSets, which are a collection of Parameters. Parameters point to a specific Action Unit, with an associated upper and lower bound. Finally, AnalysisResults contain the final result from the analysis module.

One item not mentioned here is the storage of logs: these will be stored using Azure Monitor.