extractor_input_csv_column

Maps input columns to output columns

Primary Key:

• extractor_input_version_id
• extractor_output_reference_id
• extractor_column_id

Foreign Keys:

• extractor_column_id => extractor_column.extractor_column_id
• extractor_input_version_id => extractor_input_version.extractor_input_version_id
• extractor_output_reference_id => extractor_output_reference.extractor_output_reference_id

Indexes:

• extractor_input_csv_column_extractor_column_id_idx - extractor_column_id
• extractor_input_csv_column_extractor_output_reference_id_idx - extractor_output_reference_id

Column	Data Type	Nullable	Indexed	Description
extractor_column_id	bigint	No	Yes	The output column the input CSV column is mapped to
column_regex	text	No	No	A regex used to help identify the column in the CSV which contains the desired data. Note that a regex is used since the format of a particular CSV may change slightly over time.
extractor_output_reference_id	bigint	No	Yes	The related output reference
optional	boolean	No	No	Whether this column mapping is optional. If true and the input column is missing from the source file, the column will be treated as empty rather than causing an error.
use_first_match	boolean	No	No	Whether to use the first matching column when the regex matches multiple headers. If this option is not set and the regex matches multiple headers, extractor will error by default.
extractor_input_version_id	bigint	No	Yes	The extractor input version the column mapping belongs to