uploaded_file

Information about uploaded files

Primary Key:

• id

Foreign Keys:

• created_by => login.login_id

Indexes:

• uploaded_file_bucket_storage_path_idx - bucket, storage_path
• uploaded_file_created_by_idx - created_by

Column	Data Type	Nullable	Indexed	Description
id	bigint	No	Yes	Snowflake ID of the uploaded file
bucket	text	No	Yes	Bucket in which the file was stored
name	text	No	No	Original client name of the file
storage_path	text	No	Yes	Bucket-relative storage path of the file, with snowflake ID incorporated into the filename
size	bigint	No	No	Size of the file in bytes
content_type	text	No	No	Content type of the file
created_at	timestamp with time zone	No	No	When the file was created
created_by	bigint	No	Yes	ID of the user who uploaded the file