tblFileToken
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. |