csv_import_metadata


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id TEXT 2000000000 null
csv_column_metadata.import_id C
csv_entity_source.csv_import_id R
csv_import_application.csv_import_id C
csv_import_error.csv_import_id C
import_directory_file_csv_import.csv_import_id R
xlsx_import_blob.csv_import_id C
table_name TEXT 2000000000 null
original_file_name TEXT 2000000000 null
import_timestamp INTEGER 2000000000 null
row_count INTEGER 2000000000 null
column_count INTEGER 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)
csv_import_metadata_s_pk Primary key Asc id
idx_csv_import_checksum Must be unique Asc file_checksum
idx_csv_import_device Performance Asc device_id
sqlite_autoindex_csv_import_metadata_1 Must be unique Asc id
sqlite_autoindex_csv_import_metadata_2 Must be unique Asc table_name

Relationships

Close relationships within degrees of separation