Export (0) Print
Expand All

tblFileToken

 

Topic Last Modified: 2012-09-12

tblFileToken contains temporary tokens for file transfer purposes.

Columns

Column Type Description

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.

Keys

Column Description

fileToken

Primary key.

fileTokenChannelID

Foreign key with lookup in tblNode.nodeGuid table.

 
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft