MARIProject Database Structure

View Name:MARISupportWorkflowTransition
Based on table:MPHotlineWorkFlowTransition
Group:Group: SupportWorkflow
Description:Support Module: Workflow definition for the status transition

Field Table(Germ.field)/Type Description Related
WorkFlowTransitionID WorkFlowTransitionID

INT Primary

WorkFlowID WorkFlowID

INT Index

MARISupportWorkflow.WorkFlowID
SourceStatus SourceStatus

INT Index

Link to the Status MARISupportSettings.SourceStatus
DestinationStatus DestinationStatus

INT Index

Link to the Status MARISupportSettings.DestinationStatus
TransitionMode TransitionMode

INT

TransitionName TransitionName

NVARCHAR (100)

TransitionInfo TransitionInfo

NTEXT

TransitionOder TransitionOder

INT

RightsLAN RightsLAN

BIGINT

MARIUserGroups.RightsLAN (WHERE BenutzerTyp=1)
RightsWAN RightsWAN

BIGINT

MARIUserGroups.RightsWAN (WHERE BenutzerTyp=1)
RightsPortal RightsPortal

BIGINT

MARIUserGroups.RightsPortal (WHERE BenutzerTyp=2)
UpdateStamp UpdateStamp

INT




Back to table description

Database Version 80
© by MARINGO Computers GmbH, Cologne Germany