exc_csv_mapping_rule


Columns

Column Type Size Nulls Auto Default Children Parents Comments
identifier VARCHAR 191 null
doc_unit_field VARCHAR 255 NULL
csv_field VARCHAR 255 NULL
mapping VARCHAR 191 null
exc_csv_mapping.identifier fk_exc_csv_mapping_rule_mapping R
version BIGINT 19 null
created_by VARCHAR 255 'system'
last_modified_by VARCHAR 255 'system'
created_date TIMESTAMP 19 current_timestamp()
last_modified_date TIMESTAMP 19 current_timestamp()
cond_report VARCHAR 255 NULL
metadata VARCHAR 255 NULL
bib_record_field VARCHAR 255 NULL
property VARCHAR 191 NULL
doc_property_type.identifier fk_exc_csv_mapping_rule_property R
rank INT 10 0

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc identifier
fk_exc_csv_mapping_rule_property Performance Asc property
idx_exc_csv_mapping_rule_mapping Performance Asc mapping

Relationships