conf_views_format_configuration


Columns

Column Type Size Nulls Auto Default Children Parents Comments
identifier VARCHAR 191 null
lot_lot.active_format_configuration fk_lot_configuration_viewsformat R
proj_project.active_format_configuration fk_project_configuration_viewsformat R
sto_stored_file.format_configuration fk_sto_stored_file_format_config R
label VARCHAR 255 √ NULL
thumb_height BIGINT 19 √ NULL
thumb_width BIGINT 19 √ NULL
view_height BIGINT 19 √ NULL
view_width BIGINT 19 √ NULL
print_height BIGINT 19 √ NULL
print_width BIGINT 19 √ NULL
active BIT 1 b'1'
library VARCHAR 191 √ NULL
lib_library.identifier fk_configuration_viewsformat_library 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()

Indexes

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

Relationships

Close relationships within degrees of separation