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