Analytics Used Files Table Schema (analytics_used_files)


Description

Files that have already been used for training and prediction.

analytics_used_files table columns

Column Type Size Nulls Auto Default Children Parents Comments
id BIGINT 19 √ null
modelid BIGINT 19 0
analytics_models.id analusedfile_mod2_fk R
fileid BIGINT 19 0
files.id analusedfile_fil2_fk R
action VARCHAR 50
time BIGINT 19 0

Table contained -1 rows

analytics_used_files table indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
analusedfile_fil_ix Performance Asc fileid
analusedfile_mod_ix Performance Asc modelid
analusedfile_modactfil_ix Performance Asc/Asc/Asc modelid + action + fileid

analytics_used_files table relationships

Close relationships within degrees of separation