Footprints Data Model

Table
Table Name :item_shortname Transition
Table Definition 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.

Attribute
Attribute Name Attribute Definition Logical Datatype Is Required
Item Transition Id The automatically generated primary key of the :item_shortname_transn table. LONG Yes
From Item Status Id A Foreign Key to the :item_shortname Status table. LONG Yes
To Item Status Id A Foreign Key to the :item_shortname Status table. LONG Yes
From Item Status Name The name of the From Status. VARCHAR(255) Yes
To Item Status Name The name of the To Status. VARCHAR(255) Yes
Hop Count The number of transitions. Open to Active to Closed will be stored additionally as Open to Closed with a hop count of 2. INTEGER Yes
Is Longest Hop 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. BOOLEAN Yes