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

Close relationships within degrees of separation