file_conversion

0 rows


Description

Table to track file conversions.

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_fkR
targetformat VARCHAR 100
status BIGINT 19 √ 0
statusmessage LONGTEXT 2147483647 √ null
converter VARCHAR 255 √ null
destfileid BIGINT 19 √ null
files.id fileconv_des2_fkR
data LONGTEXT 2147483647 √ null

Indexes

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

Relationships

Close relationships within degrees of separation