File Requests Schema
file_requests
Section titled “file_requests”File collection requests with constraints.
| Column | Type | Nullable | Default |
|---|---|---|---|
id | uuid | NO | gen_random_uuid() |
user_id | uuid | NO | — |
subject | text | NO | — |
description | text | YES | — |
password_hash | text | YES | — |
max_documents | integer | YES | — |
max_file_size_mb | integer | NO | 25 |
allowed_extensions | text[] | YES | — |
status | text | NO | 'active' |
expires_at | timestamptz | YES | — |
created_at | timestamptz | NO | now() |
updated_at | timestamptz | NO | now() |
file_request_submissions
Section titled “file_request_submissions”Files submitted against a request.
| Column | Type | Nullable | Default |
|---|---|---|---|
id | uuid | NO | gen_random_uuid() |
request_id | uuid | NO | — |
submitter_name | text | NO | — |
submitter_email | text | YES | — |
file_name | text | NO | — |
storage_path | text | NO | — |
file_size | bigint | NO | 0 |
file_type | text | NO | — |
status | text | NO | 'pending' |
reviewed_by | uuid | YES | — |
reviewed_at | timestamptz | YES | — |
rejection_reason | text | YES | — |
imported_document_id | uuid | YES | — |
created_at | timestamptz | NO | now() |