File Requests Schema

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

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()