E-Signatures Schema

signature_requests

Document signature requests between users.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
document_id	text	NO	—
requester_id	uuid	NO	—
signer_id	uuid	NO	—
status	text	NO	'pending'
message	text	YES	—
expires_at	timestamptz	YES	—
created_at	timestamptz	NO	now()
updated_at	timestamptz	NO	now()

signatures

Completed signature records with image path and IP.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
request_id	uuid	NO	—
signer_id	uuid	NO	—
signature_image_path	text	NO	—
signed_at	timestamptz	NO	now()
ip_address	text	YES	—

signed_documents

Final signed document artifacts.

Column	Type	Nullable	Default
id	uuid	NO	gen_random_uuid()
request_id	uuid	NO	—
document_id	text	NO	—
storage_path	text	NO	—
created_at	timestamptz	NO	now()