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 10 null
usermodified bigint 10 null
timecreated bigint 10 null
timemodified bigint 10 null
sourcefileid bigint 10 null
files.id fileconv_sou2_fk R
targetformat varchar 100
status bigint 10 0
statusmessage longtext 2147483647 null
converter varchar 255 null
destfileid bigint 10 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