WF_APP_LABEL

Stores release information for a process model.

Columns

Column Name Definition

LABEL_ID

Function:
The unique ID for the process model.
Data Type:
varchar
Size:
32
Can Be Null:
No
Primary Key:
Yes
Foreign Key:
No

APP_ID

Function:
The ID (GUID) for the app.
Data Type:
varchar
Size:
32
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
  • WF_ENABLED_APPS - n:1

CREATED_BY

Function:
The user who created the process model.
Data Type:
nvarchar
Size:
256
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
  • WF_APP_DEPENDENCY_TRACKINGS_Q - 1:n
  • WF_APP_DEPENDENCY_USAGE - 1:n

CREATED_DATE

Function:
The date the process model was created.
Data Type:
datetime
Size:
8
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

DESCRIPTION

Function:
A free text description for the process model.
Data Type:
nvarchar
Size:
2048
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

LABEL_NAME

Function:
The label name for the process model.
Data Type:
nvarchar
Size:
1024
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

PRE_VERSION

Function:
The previous version of the process model.
Data Type:
nvarchar
Size:
16
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

STATUS

Function:
The status of the process model.
Values:
This column has one value::
  • Released
Data Type:
nvarchar
Size:
64
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

VERSION

Function:
The latest version of the process model.
Data Type:
nvarchar
Size:
16
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

Relationships

Table Name Relationship
WF_ENABLED_APPSn:1
WF_PROC_DEFS1:n