exc_mapping_rule


Columns

Column Type Size Nulls Auto Default Children Parents Comments
identifier VARCHAR 191 null
doc_unit_field VARCHAR 255 √ NULL
bib_record_field VARCHAR 255 √ NULL
property VARCHAR 191 √ NULL
doc_property_type.identifier fk_exc_mapping_rule_property R
expression TEXT 65535 √ NULL
expression_conf TEXT 65535 √ NULL
apply_if TEXT 65535 √ NULL
apply_if_conf TEXT 65535 √ NULL
mapping VARCHAR 191 null
exc_mapping.identifier fk_exc_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()
position INT 10 √ NULL
default_rule BIT 1 b'0'

Indexes

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

Relationships

Close relationships within degrees of separation