E-Signatures Schema
signature_requests
Section titled “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
Section titled “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
Section titled “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() |