import_directory_file


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INTEGER 2000000000 √ √ null
import_directory_file_csv_import.file_id R
import_directory_file_qif_import.file_id C
directory_id TEXT 2000000000 null
import_directory.id C
file_ref TEXT 2000000000 null
file_name TEXT 2000000000 null
last_modified INTEGER 2000000000 null
checksum TEXT 2000000000 √ null
remote_content_hash TEXT 2000000000 √ null
imported_at INTEGER 2000000000 √ null

Indexes

Constraint Name Type Sort Column(s)
import_directory_file_s_pk Primary key Asc id
idx_import_directory_file_directory Performance Asc directory_id
sqlite_autoindex_import_directory_file_1 Must be unique Asc/Asc directory_id + file_ref

Relationships

Close relationships within degrees of separation