Table: File attachment entity

Table: File attachment entity

Holds information for files attached to various entities

Column Data Type Column Info Value Notes Other
idint(11)The id of the entity
parent_typechar(100)Type of parent
parent_idint(11)ID of parent category
file_namevarchar(255)Name of the file being imported
file_original_namevarchar(255)original file name
file_sizeint(11)The size of the generated file
file_mimevarchar(255)file MIME
deletedtinyint(4)Whether or not the entity was deleted1 - yes, 0 - no
activetinyint(4)Whether or not the entity is active1 - yes, 0 - no
createdtimestampTimestamp of when the entity was created
lastUpdatedtimestampTimestamp of when the entity was last updated

< Back to List