WF_LARGE_DATA

Stores large blocks of data, such as images or uploaded files.

Columns

Column Name Definition

ELEMENT_ID
Function:
The unique ID for the block of data.
Data Type:
varchar
Size:
32
Can Be Null:
No
Primary Key:
Yes
Foreign Key:
No

BINARY_DATA
Function:
The large binary that contains additional binary information, such as an image attachment.
Data Type:
image
Size:
16
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

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

CREATED_DATE
Function:
The date the block of data was created.
Data Type:
datetime
Size:
8
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

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

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

SECONDARY_REFERENCE_
Function:
The secondary key, or other key additional to the primary key, associated with the block of data. In some cases, the primary key is not sufficient to manage the data. In these cases, when you query the data, you can use both the primary key and secondary key together and retrieve the data.
Data Type:
nvarchar
Size:
1024
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

TERNARY_REFERENCE
Function:
Stores information related to ternary references.
Data Type:
nvarchar
Size:
1024
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

TEXT_DATA
Function:
The large text that contains additional information, such as error messages or email templates.
Data Type:
ntext
Size:
16
Can Be Null:
Yes
Primary Key:
No
Foreign Key:
No

Relationships

Table Name Relationship
WF_PROC_BASE_ELEMENTS1:n