sto_stored_file


Columns

Column Type Size Nulls Auto Default Children Parents Comments
identifier VARCHAR 191 null
filename VARCHAR 255 √ NULL
length BIGINT 19 √ NULL
page_digest VARCHAR 255 √ NULL
mimetype VARCHAR 255 √ NULL
type VARCHAR 255 √ NULL
page VARCHAR 191 √ NULL
doc_page.identifier fk_sto_stored_file_page 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()
height BIGINT 19 √ NULL
width BIGINT 19 √ NULL
title_toc TEXT 65535 √ NULL
type_toc VARCHAR 255 √ NULL
order_toc VARCHAR 255 √ NULL
compression_type VARCHAR 255 √ NULL
colorspace VARCHAR 255 √ NULL
compression_rate INT 10 √ NULL
resolution INT 10 √ NULL
text_ocr TEXT 65535 √ NULL
file_format VARCHAR 255 √ NULL
format_configuration VARCHAR 191 √ NULL
conf_views_format_configuration.identifier fk_sto_stored_file_format_config R

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc identifier
fk_sto_stored_file_format_config Performance Asc format_configuration
fk_sto_stored_file_page Performance Asc page

Relationships

Close relationships within degrees of separation