WF_APPLICATION_FOLDER

FOLDER_ID

Function:

The unique ID for the folder.

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 folder.

Data Type:

varchar

Size:

32

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

• WF_ENABLED_APPS - n:1

CONTENT_TYPE

Function:

The content type for the folder.

Values:

• Application\applicationresources - The folder to store app resources.
• Application\processgroup - The parent folder that stores all the process-related resources except shared resources.
• Application\datamodel - The folder that stores the data source and schema.xsd files.
• Application\notification - The parent folder to store notification files.
• Application\email - The folder to store email notifications.
• Application\yammer - The folder to store Yammer notifications.
• Application\microsoftteams - The folder to store Microsoft Teams notifications.
• Application\sms - The SMS folder to store SMS notifications.
• Application\chatter - The folder to store Chatter notifications.
• Application\taskformlibrary - The folder to store a form library.
• Application\formsgroup - The parent folder that stores task forms.
• Application\taskforms - The folder to store forms created within apps.
• Application\listforms - The folder to store list forms.
• Application\newforms - The folder to store Create forms in form-based apps.
• Application\updateforms - The folder to store Update forms in form-based apps.
• Application\widgets - The folder to store widget forms in form-based apps.
• Application\views - The folder to store View forms in form-based apps.
• Application\processmodel - The folder that stores the process models.
• Application\apptoken - The folder to store the app level access tokens.
• Application\datasources - The folder to store the data source-related files.
• Application\CSS - The folder to save the app level CSS files.
• Application\image - The folder to store the images used in an app.
• Application\documentrepository - The folder to store the document repository files.
• Application\js - The folder to store the app level JavaScript files.
• Application\lookup - The folder to store the lookup files.
• Application\translation - The folder that stores the translation files.

Data Type:

nvarchar

Size:

128

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No

CREATED_BY

Function:

The user who created the folder.

Data Type:

nvarchar

Size:

256

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No

CREATED_DATE

Function:

The date the folder was created.

Data Type:

datetime

Size:

8

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No

DESCRIPTION

Function:

A free text description for the folder.

Data Type:

nvarchar

Size:

2048

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No

DISPLAY_NAME

Function:

The display name for the folder.

Data Type:

nvarchar

Size:

128

Can Be Null:

No

Primary Key:

No

Foreign Key:

No

FOLDER_NAME

Function:

The file name for the folder.

Data Type:

nvarchar

Size:

128

Can Be Null:

No

Primary Key:

No

Foreign Key:

No

LAST_MODIFIED_BY

Function:

The user who last updated, or modified, the folder.

Data Type:

nvarchar

Size:

256

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No

LAST_MODIFIED_DATE

Function:

The date the folder was last modified.

Data Type:

datetime

Size:

8

Can Be Null:

Yes

Primary Key:

No

Foreign Key:

No

PROC_GROUP_ID

Function:

The ID (GUID) for the subprocess associated with the folder.

Data Type:

varchar

Size:

32

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