Frakture Timeline is an entry based sequence of events, coded by event type, and person.
Timeline Tables:
timeline_v3 - The main data table, populated from various sources, including original transaction and person tables at the end of those standard dataflows. This is independent of our previous v1 origin data — it does not use nor rely on that branch.
timeline_v3_summary which is a more human consumable view of the above.
Person and Transaction Models:
Person and Transaction Models use the Timeline data to calculate a series of statistics per model. An example model is “first_touch” or “crm_origin”, and there can be custom models per group. This is independent of our previous v1 origin data — it does not use nor rely on that model — mostly because our v1 origin calculation wasn’t very smart.
Person and Transaction Model Tables
person_model_source_code — stores a source code per person — similar to the v1 origin source code, but specified per model. One person will have one source code per model.
transaction_model_source_code — Contains one source code per transaction per model- often derived from the person model source, but could potentially be different down the road with overrides, etc.
transaction_model_* — Contains calculations for different models, including a pivot table to join against for source code summaries
Deployment