Skip to content

File Requests Schema

File collection requests with constraints.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
user_iduuidNO—
subjecttextNO—
descriptiontextYES—
password_hashtextYES—
max_documentsintegerYES—
max_file_size_mbintegerNO25
allowed_extensionstext[]YES—
statustextNO'active'
expires_attimestamptzYES—
created_attimestamptzNOnow()
updated_attimestamptzNOnow()

Files submitted against a request.

ColumnTypeNullableDefault
iduuidNOgen_random_uuid()
request_iduuidNO—
submitter_nametextNO—
submitter_emailtextYES—
file_nametextNO—
storage_pathtextNO—
file_sizebigintNO0
file_typetextNO—
statustextNO'pending'
reviewed_byuuidYES—
reviewed_attimestamptzYES—
rejection_reasontextYES—
imported_document_iduuidYES—
created_attimestamptzNOnow()