WF_APPLICATION_FILE

Description

Contains information about the files associated with an application.

Columns

For the descriptions in this table, the term item refers to a file associated with an application.

Column Name Data Type Size Description
FILE_IDvarchar32(Primary key) The unique item ID.
FILE_NAMEnvarchar256 The file name associated with the item.
BASE_FILE_IDvarchar32The ID (GUID) associated with the item.
PREV_VER_FILE_IDvarchar32The ID (GUID) of the last released version.
APP_IDvarchar32(Foreign key to WF_ENABLED_APPS table) The ID (GUID) associated with the item.
PARENT_FOLDER_IDvarchar32(Foreign key to WF_APPLICATION_FOLDER table) The ID (GUID) of an item.
PROC_GROUP_IDvarchar32The ID (GUID) of the item.
DESCRIPTIONnvarchar 2048 A free text description of the item.
VERSION nvarchar 16 The current version of the item.
STATUSnvarchar 16 The status of the item.
CONTENT_TYPEnvarchar256 The content type of the item.
CHECKED_OUT_BYnvarchar64 The user who checked out the item.
CHECKED_OUT_DATEdatetime8 The user who checked out the item.
CREATED_DATEdatetime8 The date the item was created.
CREATED_BYnvarchar64 The user who created the item.
LAST_MODIFIED_DATE datetime8 The date the item was last modified.
LAST_MODIFIED_BY nvarchar64 The user who last updated, or modified, the item.
THEME_IDvarchar32The ID (GUID) used for an application.
EXTRA_INFOntext 16 Extra information for the item.
DISPLAY_NAMEnvarchar256 The display name of the item.

Relationships

Table Name Relationship
WF_ENABLED_APPS1 – n
WF_APPLICATION_FOLDER1 – n
WF_LABEL_FILE_REL1 – n