Field Name

Data type

Field Length

FK Relationship

Allow Null?

Short description

(Default value if applicable)

Field

Table

ID

INTEGER

4

N

Unique identifier

EXECUTIONID

INTEGER

4

Y

Id that maps SWExecution table, which has the workflow design information

VARIABLENAME

NVARCHAR

100

Y

Name of the variable which is initialized in the workflow

VARIABLEVALUE

IMAGE

16

Y

Default value of the variable

VARIABLETYPE

NVARCHAR

30

Y

Data type of the variable

LASTUPDATEDDATETIME

DATETIME

8

Y

Last updated time of the variable