Skip to content

E-Signatures Schema

Document signature requests between users.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
document_idtextNO—
requester_iduuidNO—
signer_iduuidNO—
statustextNO'pending'
messagetextYES—
expires_attimestamptzYES—
created_attimestamptzNOnow()
updated_attimestamptzNOnow()

Completed signature records with image path and IP.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
request_iduuidNO—
signer_iduuidNO—
signature_image_pathtextNO—
signed_attimestamptzNOnow()
ip_addresstextYES—

Final signed document artifacts.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
request_iduuidNO—
document_idtextNO—
storage_pathtextNO—
created_attimestamptzNOnow()