The DB flow will be changed at version X.X.X. at this doc, we'll cover the current, and the new DB flows.
There are 2 data sources that can act as input to the system:
- Email collectors
- Questionnaire
- import_emails API action is triggered by the collector, creating RawDataEntries
- when the create_snapshot / create_snapshot_for_e2e rake tasks are triggered, it calls the CreateSnapshotHelper.create_company_snapshot
- Snapshot find or create by date
- Emails Snapshot Data (at old version was name NetworkSnapshotsNodes) are created
- Snapshot Data is generated for 'communication flow' network
- run precalculate_pins task to update EmployeePin table
- run precalculate_metric_scores to generate MetricScores
- when csv is loaded into the system from the back-end
- Snapshot find or create
- find or create FriendshipsSnapshot for each pair of employees
- find or create AdvicesSnapshot for each pair of employees
- find or create TrustsSnapshot for each pair of employees
- run precalculate_pins task to update EmployeePin table
- run precalculate_metric_scores to generate MetricScores
- when csv is loaded into the system from the back-end, or data is loaded by an API action - QuestionnireRawDataEntry are created
- when the create_snapshot/create_snapshot_for_e2e rake tasks are trigged, it calls the CreateSnapshotHelper.create_company_snapshot, which triggers
- Snapshot find or create by date
- NestworkSnapshotsNodes are created
- SnapshotData are created according to network type
- run precalculate_pins task to update EmployeePin table
- run precalculate_metric_scores to generate MetricScores