doc_condreport_property_config


Columns

Column Type Size Nulls Auto Default Children Parents Comments
identifier VARCHAR 191 null
doc_condreport_property_config_type.conf fk_prop_conf_type_conf R
required BIT 1 b'0'
allow_comment BIT 1 b'0'
library VARCHAR 191 null
lib_library.identifier fk_report_prop_conf_lib R
desc_property VARCHAR 191 NULL
doc_condreport_desc_property.identifier fk_report_prop_conf_bind R
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()
show_on_creation BIT 1 b'1'
internal_prop VARCHAR 255 NULL

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc identifier
idx_report_prop_conf_bind Performance Asc desc_property
idx_report_prop_conf_lib Performance Asc library

Relationships