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_ID | varchar | 32 | (Primary key) The unique item ID. |
| FILE_NAME | nvarchar | 256 | The file name associated with the item. |
| BASE_FILE_ID | varchar | 32 | The ID (GUID) associated with the item. |
| PREV_VER_FILE_ID | varchar | 32 | The ID (GUID) of the last released version. |
| APP_ID | varchar | 32 | (Foreign key to WF_ENABLED_APPS table) The ID (GUID) associated with the item. |
| PARENT_FOLDER_ID | varchar | 32 | (Foreign key to WF_APPLICATION_FOLDER table) The ID (GUID) of an item. |
| PROC_GROUP_ID | varchar | 32 | The ID (GUID) of the item. |
| DESCRIPTION | nvarchar | 2048 | A free text description of the item. |
| VERSION | nvarchar | 16 | The current version of the item. |
| STATUS | nvarchar | 16 | The status of the item. |
| CONTENT_TYPE | nvarchar | 256 | The content type of the item. |
| CHECKED_OUT_BY | nvarchar | 64 | The user who checked out the item. |
| CHECKED_OUT_DATE | datetime | 8 | The user who checked out the item. |
| CREATED_DATE | datetime | 8 | The date the item was created. |
| CREATED_BY | nvarchar | 64 | The user who created the item. |
| LAST_MODIFIED_DATE | datetime | 8 | The date the item was last modified. |
| LAST_MODIFIED_BY | nvarchar | 64 | The user who last updated, or modified, the item. |
| THEME_ID | varchar | 32 | The ID (GUID) used for an application. |
| EXTRA_INFO | ntext | 16 | Extra information for the item. |
| DISPLAY_NAME | nvarchar | 256 | The display name of the item. |
Relationships
| Table Name | Relationship |
|---|---|
| WF_ENABLED_APPS | 1 – n |
| WF_APPLICATION_FOLDER | 1 – n |
| WF_LABEL_FILE_REL | 1 – n |