WF_ENABLED_APPS

Description

Contains information about the metadata for the AgilePoint NX applications.

Columns

For the descriptions in this table, the term item refers to an application.

Column Name Data Type Size Description
APP_IDvarchar32(Primary key) The unique item ID.
APP_NAME nvarchar 128 The name of the application associated with the item.
DESCRIPTIONnvarchar 2048 A free text description of the item.
STATUSnvarchar 16 The status of the item.
CREATED_DATEdatetime8 The date the item was created.
CREATED_BYnvarchar64 The user who created the item.
APP_TYPEnvarchar 128 The type of application.
VISIBILITYnvarchar 128 The visibility state of the item.
DISPLAY_NAMEnvarchar 128 The display name of the item.
APP_LOCALEvarchar 16 Indicates the locale of the item.
PARENT_APPLICATION_IDvarchar32The parent ID (GUID) of the parent process, if the item is a subprocess.

Relationships

Table Name Relationship
WF_APP_LABEL1 – n
WF_APPLICATION_FILE1 – n
WF_APPLICATION_FOLDER1 – n