Database – File attachment entity (file_attachment_entity)
Holds information for files attached to various entities
Column | Data Type | Column Info | Value Notes | Other |
id | int(11) | The id of the entity | ||
parent_type | char(100) | Type of parent | ||
parent_id | int(11) | ID of parent category | ||
file_name | varchar(255) | Name of the file being imported | ||
file_original_name | varchar(255) | original file name | ||
file_size | int(11) | The size of the generated file | ||
file_mime | varchar(255) | file MIME | ||
deleted | tinyint(4) | Whether or not the entity was deleted | 1 - yes, 0 - no | |
active | tinyint(4) | Whether or not the entity is active | 1 - yes, 0 - no | |
created | timestamp | Timestamp of when the entity was created | ||
lastUpdated | timestamp | Timestamp of when the entity was last updated |