fileToken

nvarchar (50), not null

Unique token (a GUID).

fileTokenUserID

int, not null

ID of the principal that is transferring the file.

fileTokenChannelID

GUID, not null

GUID of the chat room node.

fileTokenExpireDate

datetime, not null

Expiration time. (Tokens expire after 30 minutes, unless pinned (see the following descriptions in this column).

fileTokenComplianceFileUrl

nvarchar(256)

URL of the transferred file (for Compliance service use).

fileTokenComplianceThumbnailUrl

nvarchar(256)

URL of the thumbnail for the transferred file (for Compliance service use).

fileTokenComplianceTime

datetime2

Timestamp for the actual file transfer operation (for Compliance service use).

fileTokenComplianceIsUpload

bit

True if upload; False if download (for Compliance service use).

fileTokenCompliancePinned

bit, not null

True if token is pinned. It’s used to keep the token in the table until Compliance service has a chance to retrieve the relevant fields from it.

fileToken

Primary key.

fileTokenChannelID

Foreign key with lookup in tblNode.nodeGuid table.