Information for the SignatureDocument
Columns
Id
(datatype: int) Required Primary Key
SignatureDocumentTemplateId
(datatype: int) Required Primary Key
Name
(datatype: nvarchar(250)) Required Primary Key
DocumentKey
(datatype: nvarchar(200)) Required Primary Key
AppliesToPersonAliasId
(datatype: int) Required Primary Key
AssignedToPersonAliasId
(datatype: int) Required Primary Key
Status
(datatype: int) Required Primary Key
LastStatusDate
(datatype: datetime) Required Primary Key
BinaryFileId
(datatype: int) Required Primary Key
SignedByPersonAliasId
(datatype: int) Required Primary Key
CreatedDateTime
(datatype: datetime) Required Primary Key
ModifiedDateTime
(datatype: datetime) Required Primary Key
CreatedByPersonAliasId
(datatype: int) Required Primary Key
ModifiedByPersonAliasId
(datatype: int) Required Primary Key
Guid
(datatype: uniqueidentifier) Required Primary Key
ForeignId
(datatype: int) Required Primary Key
ForeignGuid
(datatype: uniqueidentifier) Required Primary Key
ForeignKey
(datatype: nvarchar(100)) Required Primary Key
LastInviteDate
(datatype: datetime) Required Primary Key
InviteCount
(datatype: int) Required Primary Key
SignedDocumentText
(datatype: nvarchar(max)) Required Primary Key
SignedName
(datatype: nvarchar(250)) Required Primary Key
SignedClientIp
(datatype: nvarchar(128)) Required Primary Key
SignedClientUserAgent
(datatype: nvarchar(max)) Required Primary Key
SignedDateTime
(datatype: datetime) Required Primary Key
SignedByEmail
(datatype: nvarchar(75)) Required Primary Key
CompletionEmailSentDateTime
(datatype: datetime) Required Primary Key
EntityTypeId
(datatype: int) Required Primary Key
EntityId
(datatype: int) Required Primary Key
SignatureVerificationHash
(datatype: nvarchar(40)) Required Primary Key
SignatureDataEncrypted
(datatype: nvarchar(max)) Required Primary Key