Attachments
The attachments table contains data about files attached to fields on entities.
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. | VARCHAR | No |
| attachable_type | Always TaggableLogbook |
VARCHAR | Yes |
| attachable_id | The numerical identifier of the field on an entity connected to this file. Relates to the id column in the taggable_logbooks table. |
INT8 | Yes |
| artifact | Always original |
VARCHAR | No |
| mime_type | The MIME type of this file. | VARCHAR | No |
| size | The size in bytes of this file. | INT4 | No |
| created_by_id | The numerical identifier of the user that uploaded this attachment. Relates to the id column in the users table. |
INT8 | No |
| created_at | The UTC timestamp when this object was created. | TIMESTAMP | No |
| updated_at | The UTC timestamp when this object was updated. | TIMESTAMP | No |