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 |