Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

ColumnTypeReferencesComments
idInteger Primary key
vdb_idInteger  
guidString  
nameString Short name
state_idIntegerdb_state.idState ID
next_state_typeInteger Next state type: 1 = same, 2 = specific, 3 = previousnext_state_idIntegerdb_state.idNext state ID (in case next state type is specific)
next_assignee_typeInteger Next assignee type: 0 = unassigned, 1 = same, 2 = state manager, 3 = prompt user in role, 4 = last assigned for this state, 5 = reporter
next_assignee_idIntegerdb_person.idNext assignee ID (in case next assignee type is 3 i.e. prompt user in role)
positionInteger Order in its siblings