conf_omeka


Columns

Column Type Size Nulls Auto Default Children Parents Comments
identifier VARCHAR 191 null
conf_lists_omeka.conf_omeka fk_conf_lists_omeka R
lot_lot.omeka_configuration fk_lot_omeka_conf R
proj_project.omeka_configuration fk_proj_omeka_conf R
label VARCHAR 255 null
library VARCHAR 191 null
lib_library.identifier fk_conf_omeka_library R
storage_server VARCHAR 255 null
active BIT 1 b'1'
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()
address VARCHAR 255 √ NULL
login VARCHAR 255 √ NULL
password VARCHAR 255 √ NULL
export_mets BIT 1 √ b'0'
export_master BIT 1 √ b'0'
export_view BIT 1 √ b'0'
export_thumb BIT 1 √ b'0'
export_pdf BIT 1 √ b'0'
port VARCHAR 255 √ NULL
access_url VARCHAR 255 √ NULL
mail_csv VARCHAR 255 √ NULL
omekas BIT 1 √ b'0'
sftp BIT 1 √ b'1'

Indexes

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

Relationships

Close relationships within degrees of separation