App's ESignature recipients

Show:

ESIGNATURE_ID

Int(11)

Recipient esignature id

ID_ESIGNATURE_RECIPIENT

Int(11)

Unique identifier.

PARENT_ID

Int(11)

Recipient parent id

PARENT_TYPE

Enum('candidate','resource','contact')

Recipient esignature recipient type


Default: 'candidate'

RECIPIENT_COMMENT

Text

Recipient comment

RECIPIENT_DATE

DATETIME

Recipient date

RECIPIENT_EMAIL

Varchar(100)

Recipient email


Default: ''

RECIPIENT_EXTERNAL_ID

Varchar(100)

Recipient external id (stored at the service provider)

RECIPIENT_PHONE

Char(20)

Recipient phone


Default: ''

RECIPIENT_RANK

Tinyint(1)

Recipient rank

RECIPIENT_STATE

Enum('waiting', 'signed', 'refused', 'cancelled', 'expired')

Recipient status


Default: 'waiting'