WF_REPOSITIORY_ITEMS

Stores information about files in a document repository.

Columns

Column Name Definition

CATEGORY

Function:
The category, or type, of the stored file.
Values:
This column has one value:
  • WFMailTemplate - The global email templates created in Manage Center.
Data Type:
nvarchar
Size:
64
Can Be Null:
No
Primary Key:
No
Foreign Key:
No

CFG_XML

Function:
A user-defined configuration in XML format.
Data Type:
ntext
Size:
16
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

CREATED_BY

Function:
The user who created the file in a document repository.
Data Type:
nvarchar
Size:
256
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

CREATED_DATE

Function:
The date the file in a document repository was created.
Data Type:
datetime
Size:
8
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

ITEM_ID

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

LAST_MODIFIED_BY

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

LAST_MODIFIED_DATE

Function:
The date the relationship between a file and its label was last modified.
Data Type:
datetime
Size:
8
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

OWNER_ID

Function:
The GUID for the file owner — for example, the process ID.
Data Type:
varchar
Size:
32
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

Relationships

Table Name Relationship
NoneNot applicable