qif_import_metadata


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id TEXT 2000000000 null
import_directory_file_qif_import.qif_import_id C
qif_entity_source.qif_import_id R
qif_import_application.qif_import_id N
qif_import_error.qif_import_id C
qif_record.import_id C
original_file_name TEXT 2000000000 null
import_timestamp INTEGER 2000000000 null
record_count INTEGER 2000000000 null
unsupported_count INTEGER 2000000000 null
account_type TEXT 2000000000 null
device_id INTEGER 2000000000 null
device.id R
file_checksum TEXT 2000000000 null
file_last_modified INTEGER 2000000000 null
ignored INTEGER 2000000000 0

Indexes

Constraint Name Type Sort Column(s)
qif_import_metadata_s_pk Primary key Asc id
idx_qif_import_checksum Must be unique Asc file_checksum
idx_qif_import_device Performance Asc device_id
sqlite_autoindex_qif_import_metadata_1 Must be unique Asc id

Relationships

Close relationships within degrees of separation