Genealogy Links (Event_Components)
Genealogy links are stored as branches of a family tree. At a minimum, there will be a record for every link between a parent event and child event. For example, if a parent event is linked to 3 child events, there will be 3 records in the Event_Components table. Alternatively, if there are 2 parent events each linked to 3 child events, there will be 6 records in the Event_Components table.
Genealogy records can be created either by a genealogy model, based on the configuration and use of the Raw Material inputs, or they can simply be created on their own.
| Table Name | Description |
|---|---|
| Event_Components | Genealogy links |
| PrdExec_Input_Event | Current state of the Raw Material Inputs (for example, what production event is in the Running or Staged position). |
| PrdExec_Input_Event_History | Historical and current state of the Raw Material Inputs (for example, what production event is in the Running or Staged position). |
The main configuration tables for genealogy are:
| Table Name | Description |
|---|---|
| PrdExec_Inputs | Primary Raw Material Input configuration. |
The logical unique key for the Event_Components table is:
| Field | Description |
|---|---|
| Event_Id | Event_Id of the child event. |
| Source_Event_Id | Event_Id of the parent event. |