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 |
|---|
| None | Not applicable |