Connecting sTypes
In a project, items (ie. files, assets) may be related to each other. For example, a car is built with various parts that can be identified separately but are all related to the same car. Another example can be found cinematic film production. The cinematic footage of one movie is commonly broken down into sequences and shots.
How do these relationships work in TACTIC? - Each sType is represented as a table in the database and each entry in the table represents an sObject. The relationships are created when storing matching data "properties" in each of the tables. In the example tables below there are "Sequence" and "Shot" sTypes. The "code" column matches the "sequence_code" column which illustrates which shot is related to which sequence.
| code | description |
|---|---|
SEQ001 |
The first sequence |
SEQ002 |
The first sequence |
| sequence_code | code | description |
|---|---|---|
SEQ001 |
SEQ001_001 |
Sequence one shot one |
SEQ001 |
SEQ001_002 |
Sequence one shot two |
SEQ002 |
SEQ002_001 |
Sequence two shot one |
In the Schema Editor, relationships are represented by lines connecting the nodes. When these connections are made, the columns used to relate the sTypes can be chosen in the Connection Editor.
To create a new connection, hover over a node and click-drag a connection to the desired node (sType).
Note
The direction of the arrow in the connection indicates from child to parent.
After a connection is made, the Connection Attributes editor will open to enable the choice of column relationships. It is also possible to create new columns from this editor.
Note
The yellow Switch button
in the middle of the tool toggles which node is the child and which one is the parent.