๐๐๐๐๐๐๐
The following post is based on a linkedin post and is shared here for visibility. Credit goes to author @Nicola Attico
๐๐๐๐๐๐๐
While many of us are acquainted with the main elements of FD, its data model remains slightly hidden. Recognizing this data model can be invaluable, whether creating apps, crafting reports or merely trying to grasp the system's internals.
Here are its main layers and tables' names that you can use to explore quickly.
๐ด ๐๐
๐ฒ๐ฐ๐๐๐ถ๐ผ๐ป ๐น๐ฎ๐๐ฒ๐ฟ: This layer primarily handles the runtime data, managing the progression and results of flows and their steps.
- Flow engine context (sys_flow_context)
- Flow engine context report (sys_flow_report)
- Flow statistics (sys_flow_stats)
- Flow engine log entry (sys_flow_logNNNN)
๐ต ๐ง๐ฟ๐ถ๐ด๐ด๐ฒ๐ฟ๐ ๐น๐ฎ๐๐ฒ๐ฟ: Acting as the initiation point, this layer defines what events or conditions will initiate the flow processes.
- Trigger (sys_flow_trigger)
- Trigger instance (sys_hub_trigger_instance)
- Trigger Definition (sys_hub_trigger_definition)
- Trigger category (sys_hub_trigger_category)
- Trigger flow connector (sys_hub_trigger_input|output)
โซ๏ธ ๐๐น๐ผ๐๐ & ๐๐๐ฏ๐ณ๐น๐ผ๐๐ ๐น๐ฎ๐๐ฒ๐ฟ: Core to the design, this layer encompasses the main processes and any subsidiary workflows, ensuring logical sequencing.
- Flow base (sys_hub_flow_base)
- Flow (sys_hub_flow)
- Flow snapshot (sys_hub_flow_snapshot)
๐ก ๐๐ผ๐บ๐ฝ๐ผ๐ป๐ฒ๐ป๐๐ ๐น๐ฎ๐๐ฒ๐ฟ: A modular layer containing reusable elements and logic sequences that can be integrated into various flows.
- Component (sys_hub_flow_component)
- Flow logic instance (sys_hub_flow_logic)
- Action instance (sys_hub_action_instance)
- Subflow instance (sys_hub_subflow_instane)
๐ค ๐๐น๐ผ๐ ๐น๐ผ๐ด๐ถ๐ฐ ๐น๐ฎ๐๐ฒ๐ฟ: The brain behind the operations defines the conditions, decisions, and logical pathways the flow should adhere to.
- Flow logic instance (sys_hub_flow_logic)
- Flow logic definition (sys_hub_flow_logic_definition)
- Flow logic variable|input (sys_hub_flow_logic_variable|input)
๐ฃ ๐๐ฐ๐๐ถ๐ผ๐ป๐ ๐น๐ฎ๐๐ฒ๐ฟ: Acting as the doers, this segment encompasses the specific tasks, outputs, and operations the flow should execute.
- Action type base (sys_hub_action_type_base)
- Action type snapshot (sys_hub_action_type)
- Action input|output (sys_hub_action_input|output)
- Action plan (sys_hub_action_plan)
๐ ๐ฆ๐๐ฒ๐ฝ๐ ๐น๐ฎ๐๐ฒ๐ฟ: Breaking down the process, this layer itemizes each step, its definitions, and the input or output specifications.
- Step instance (sys_flow_step_instance)
- Step definition (sys_flow_step_definition)
- Step input|output (sys_hub_flow_step_definition_input|output)
