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