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

1. import_emails API action is triggered by the collector, creating RawDataEntries
2. when the create_snapshot / create_snapshot_for_e2e rake tasks are triggered, it calls the CreateSnapshotHelper.create_company_snapshot
   1. Snapshot find or create by date
   2. Emails Snapshot Data (at old version was name NetworkSnapshotsNodes) are created
   3. Snapshot Data is generated for 'communication flow' network
3. run precalculate_pins task to update EmployeePin table
4. run precalculate_metric_scores to generate MetricScores

1. when csv is loaded into the system from the back-end
1. Snapshot find or create
2. find or create FriendshipsSnapshot for each pair of employees
3. find or create AdvicesSnapshot for each pair of employees
4. find or create TrustsSnapshot for each pair of employees
2. run precalculate_pins task to update EmployeePin table
3. run precalculate_metric_scores to generate MetricScores

1. when csv is loaded into the system from the back-end, or data is loaded by an API action - QuestionnireRawDataEntry are created
2. when the create_snapshot/create_snapshot_for_e2e rake tasks are trigged, it calls the CreateSnapshotHelper.create_company_snapshot, which triggers
   1. Snapshot find or create by date
   2. NestworkSnapshotsNodes are created
   3. SnapshotData are created according to network type
3. run precalculate_pins task to update EmployeePin table
4. run precalculate_metric_scores to generate MetricScores