doc_property_type


Columns

Column Type Size Nulls Auto Default Children Parents Comments
identifier VARCHAR 191 null
doc_export_property.type fk_doc_export_property_type R
doc_property.type fk_doc_property_type R
exc_csv_mapping_rule.property fk_exc_csv_mapping_rule_property R
exc_mapping_rule.property fk_exc_mapping_rule_property R
label VARCHAR 255 √ NULL
supertype VARCHAR 255 √ NULL
rank INT 10 √ NULL
version BIGINT 19 null
created_by VARCHAR 191 'system'
last_modified_by VARCHAR 191 'system'
created_date TIMESTAMP 19 current_timestamp()
last_modified_date TIMESTAMP 19 current_timestamp()

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc identifier

Relationships

Close relationships within degrees of separation