Active Storage Attachments

The active_storage_attachments table contains data about upload files (active storage attachments).

This table can be used to determine which files were uploaded when an upload was created, as well as metadata about the files such as when it was created.

Columns

Column Name Description Type Nullable
id The numerical identifier of the object. INT8 No
name The file name of the file. One of csv_file or csv_errors_file. VARCHAR No
record_type Always Import VARCHAR No
record_id The numerical identifier of the upload connected to this file. Relates to the id column in the imports table. INT8 No
blob_id The numerical identifier of the file blob connected to this file. Relates to the id column in the active_storage_blobs table. INT8 No
created_at The UTC timestamp when this object was created. TIMESTAMP No