signature_recipients


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id VARCHAR 36 null
signature_request_id VARCHAR 36 null
signature_requests.id fk_sig_rcpt_request C
name VARCHAR 255 √ null
shedlock.name Implied Constraint R
email VARCHAR 255 √ null
role VARCHAR 50 √ null
signing_order INT 10 0
status VARCHAR 20 PENDING
signed_at DATETIME 19 √ null
created_at DATETIME 19 CURRENT_TIMESTAMP
updated_at DATETIME 19 √ null
created_by VARCHAR 255 √ null
updated_by VARCHAR 255 √ null

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
idx_sig_rcpt_request Performance Asc signature_request_id

Relationships

Close relationships within degrees of separation