Table EcLINK

links to entities in Vault client, to files in shared folders

field

data type

description

id

bigint not null PK

record number

ent_id

bigint not null FK

link to EcENTITY.id

link_type

smallint not null

link type: see value list under this table

vault

nvarchar 20

Vault name (link to full Vault client only)

object_type

nvarchar 20

Vault entity type (link to full Vault client only)

object_name

nvarchar (max)

entity name OR http link OR full file name

link_type values: FullClientCompose = 1, FullClientAcrContents = 2, FullClientHttpRequest = 3, FullClientComposePublishedFile = 4, FullClientAcrContentsPublishedFile = 5, FullClientHttpRequestPublishedFile = 6,

ThinClientMaster = 10, ThinClientRev = 11, ThinClientMasterPublishedFile = 12, ThinClientRevPublishedFile = 13,

FfnNative = 20, FfnVisualization = 21, FfnThumbnail = 22, FfnPublished = 30, VaultFullName = 40,

Other = 0, PendingPublication = -2