File Conversion Table Schema (file_conversion)


Description

Table to track file conversions.

file_conversion table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 null
usermodified BIGINT 19 null
timecreated BIGINT 19 null
timemodified BIGINT 19 null
sourcefileid BIGINT 19 null
files.id fileconv_sou2_fk R
targetformat VARCHAR 100
status BIGINT 19 0
statusmessage LONGTEXT 2147483647 null
converter VARCHAR 255 null
destfileid BIGINT 19 null
files.id fileconv_des2_fk R
data LONGTEXT 2147483647 null

Table contained -1 rows

file_conversion table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
fileconv_des_ix Performance Asc destfileid
fileconv_sou_ix Performance Asc sourcefileid

file_conversion table relationships