csv_import_strategy


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id TEXT 2000000000 null
account_mapping.strategy_id C
csv_import_application.strategy_id C
qif_import_application.strategy_id N
xlsx_import_strategy.csv_import_strategy_id C
revision_id INTEGER 2000000000 1
name TEXT 2000000000 null
identification_columns_json TEXT 2000000000 null
field_mappings_json TEXT 2000000000 null
attribute_mappings_json TEXT 2000000000 null
row_rules_json TEXT 2000000000 '[]'
companion_rules_json TEXT 2000000000 '[]'
content_match_rules_json TEXT 2000000000 '[]'
file_name_pattern TEXT 2000000000 √ null
cross_source_reconcile_window_seconds INTEGER 2000000000 √ null
conversion_config_json TEXT 2000000000 √ null
funding_attribute_match_json TEXT 2000000000 √ null
created_at INTEGER 2000000000 CAST(strftime('%s', 'now') AS INTEGER) * 1000
updated_at INTEGER 2000000000 CAST(strftime('%s', 'now') AS INTEGER) * 1000

Indexes

Constraint Name Type Sort Column(s)
csv_import_strategy_s_pk Primary key Asc id
idx_csv_import_strategy_name Performance Asc name
sqlite_autoindex_csv_import_strategy_1 Must be unique Asc id
sqlite_autoindex_csv_import_strategy_2 Must be unique Asc name

Relationships

Close relationships within degrees of separation