WF_APPLICATION_FILE

Stores information about the files associated with an app.

Columns

Column Name Definition

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

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

BASE_FILE_ID
Function:
The ID (GUID) for the base file.
Data Type:
varchar
Size:
32
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

CHECKED_OUT_BY
Function:
The user who checked out the file.
Data Type:
nvarchar
Size:
256
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

CHECKED_OUT_DATE
Function:
The date the file was checked out.
Data Type:
datetime
Size:
8
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

CONTENT_TYPE
Function:
The content type for the file.
Values:
  • User\infopathdatamodel - An InfoPath data model file.
  • User\sharepointdatamodel - A SharePoint data model file.
  • User\salesforcedatamodel - A Salesforce data model file.
  • User\apdataentitydatamodel - An AgilePoint Data Entities data model file.
  • User\databasedatamodel - A database data model file.
  • User\exceltabledatamodel - A Microsoft Excel data model file.
  • User\datamodel - A schema.xsd file.
  • User\email - An email notification file.
  • User\yammer - A Yammer notification file.
  • User\microsoftteams - A Microsoft Teams notification file.
  • User\sms - An SMS notification file.
  • User\chatter - A Chatter notification file.
  • User\taskformlibrary - Task form library files.
  • User\taskforms - Task form files.
  • User\listforms - List form files.
  • User\newforms - Form-based app New or Create forms.
  • User\updateforms - Form-based app Update forms.
  • User\widgets - Form-based app widgets.
  • User\views - Form-based app View forms.
  • User\processmodel - A process model file.
  • User\apptoken - An app level access token file.
  • User\css - A CSS file.
  • User\image - An image file.
  • User\documentrepository - Files created for document storage.
  • User\js - A JavaScript file.
  • User\lookupnamevalue - A lookup with name/value selection.
  • User\translation - Translation files for the particular app.
  • User\lookupmulticolumn - A lookup with multiple columns.
  • User\SharePointDataSource - A SharePoint data source file.
  • User\InfoPathDataSource - An InfoPath data source file.
  • User\SalesforceDataSource - A Salesforce data source file.
  • User\APDataEntityDataSource - An AgilePoint Data Entities data source file.
  • User\DatabaseDataSource - A database data source file.
  • User\ExcelTableDataSource - A Microsoft Excel data source file.
Data Type:
nvarchar
Size:
256
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

CREATED_BY
Function:
The user who created the file.
Data Type:
nvarchar
Size:
256
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

CREATED_DATE
Function:
The date the file 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 file.
Data Type:
nvarchar
Size:
2048
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

DISPLAY_NAME
Function:
The display name for the file.
Data Type:
nvarchar
Size:
256
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

EXTRA_INFO
Function:
Additional information for a schema.xsd file.
Values:
A JSON string in this format:
  • [{"Name" : "NamespaceUpdated" , "Value" : "True"}]
Data Type:
ntext
Size:
16
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

FILE_NAME
Function:
The file name associated with the file.
Data Type:
nvarchar
Size:
256
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

LAST_MODIFIED_BY
Function:
The user who last updated, or modified, the file.
Data Type:
nvarchar
Size:
256
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

LAST_MODIFIED_DATE
Function:
The date the file was last modified.
Data Type:
datetime
Size:
8
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

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

PREV_VER_FILE_ID
Function:
The ID (GUID) for the last released version of the file.
Data Type:
varchar
Size:
32
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

PROC_GROUP_ID
Function:
The ID (GUID) for the subprocess associated with the file.
Data Type:
varchar
Size:
32
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

STATUS
Function:
The status of the file.
Values:
  • DRAFT - The file is checked in.
  • CHECKEDOUT_DRAFT - The file is checked out for editing.
  • PSEUDO_CHECKEDOUT_DRAFT - A copy of the checked out file.
  • RELEASED - The file is published.
  • RETIRED - Previous versions of the file.
Data Type:
nvarchar
Size:
32
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

THEME_ID
Function:
The ID (GUID) used for an app.
Data Type:
varchar
Size:
32
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

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

Relationships

Table Name Relationship
WF_ENABLED_APPS1:n
WF_APPLICATION_FOLDER1:n
WF_LABEL_FILE_REL1:n