Active Storage Blobs
The active_storage_blobs table contains data about upload file contents (active storage blobs).
This table can be used to determine which file contents are associated with which files that were uploaded for import, 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 |
| key | A unique internal key for the file contents. | VARCHAR | No |
| filename | The original file name of the uploaded file. | VARCHAR | No |
| content_type | The MIME type of the file. Always text/csv. |
VARCHAR | Yes |
| metadata | A JSON representation of internal metadata about the file contents. | TEXT | Yes |
| byte_size | The size in bytes of the file content. | INT8 | No |
| checksum | The checksum of the file contents. | VARCHAR | Yes |
| created_at | The UTC timestamp when this object was created. | TIMESTAMP | No |
| service_name | Where the file contents were uploaded. Always amazon. |
VARCHAR | No |