Footprints Data Model |
Table |
Name | :item_shortname_transn |
Comment |
A dimension table that records the details of a state transition, including the from and to state names, and the number of hops that are taken in the transition. This allows the precalculation of transitive states, so the transition from A to D via the path A>b>c>D would be recorded with a hopCt of 3. |
Column |
Name | Datatype | Comment | Is PK | Is FK |
item_transn_id | bigint | The automatically generated primary key of the :item_shortname_transn table. | Yes | No |
from_item_status_id | bigint | A Foreign Key to the :item_shortname Status table. | No | Yes |
to_item_status_id | bigint | A Foreign Key to the :item_shortname Status table. | No | Yes |
from_item_status_name | varchar(255) | The name of the :item_shortname Status. | No | Yes |
to_item_status_name | varchar(255) | The name of the :item_shortname Status. | No | Yes |
hop_ct | int |
The number of transitions. Open to Active to Closed will be stored additionally as Open to Closed with a hop count of 2. |
No | No |
is_longest_hop | bit |
Indicates that this transition is a 'longest hop' transition. Many reports will want to find the longest transition between two states, and ignore cycles within the two. |
No | No |