publication_formats


Description

Publication formats are representations of a publication in a particular format, e.g. PDF, hardcover, etc. Each publication format may contain many chapters.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
publication_format_id BIGINT 19 √ null
identification_codes.publication_format_id identification_codes_publication_format_idC
markets.publication_format_id markets_publication_format_idC
metrics_submission.representation_id metrics_submission_representation_id_foreignC
publication_dates.publication_format_id publication_dates_publication_format_idC
publication_format_settings.publication_format_id publication_format_settings_publication_format_idC
sales_rights.publication_format_id sales_rights_publication_format_idC
usage_stats_total_temporary_records.representation_id ust_representation_id_foreignC
usage_stats_unique_item_investigations_temporary_records.representation_id usii_representation_id_foreignC
usage_stats_unique_item_requests_temporary_records.representation_id usir_representation_id_foreignC
usage_stats_unique_title_investigations_temporary_records.representation_id usti_representation_id_foreignC
usage_stats_unique_title_requests_temporary_records.representation_id ustr_representation_id_foreignC
publication_id BIGINT 19 null
publications.publication_id publication_formats_publication_idC
physical_format SMALLINT 5 √ 1
entry_key VARCHAR 64 √ NULL
seq DOUBLE 8,2 0.00
file_size VARCHAR 255 √ NULL
front_matter VARCHAR 255 √ NULL
back_matter VARCHAR 255 √ NULL
height VARCHAR 255 √ NULL
height_unit_code VARCHAR 255 √ NULL
width VARCHAR 255 √ NULL
width_unit_code VARCHAR 255 √ NULL
thickness VARCHAR 255 √ NULL
thickness_unit_code VARCHAR 255 √ NULL
weight VARCHAR 255 √ NULL
weight_unit_code VARCHAR 255 √ NULL
product_composition_code VARCHAR 255 √ NULL
product_form_detail_code VARCHAR 255 √ NULL
country_manufacture_code VARCHAR 255 √ NULL
imprint VARCHAR 255 √ NULL
product_availability_code VARCHAR 255 √ NULL
technical_protection_code VARCHAR 255 √ NULL
returnable_indicator_code VARCHAR 255 √ NULL
remote_url VARCHAR 2047 √ NULL
url_path VARCHAR 64 √ NULL
is_approved SMALLINT 5 0
is_available SMALLINT 5 0
doi_id BIGINT 19 √ NULL
dois.doi_id publication_formats_doi_id_foreignN

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc publication_format_id
publication_formats_doi_id Performance Asc doi_id
publication_formats_publication_id Performance Asc publication_id

Relationships

Close relationships within degrees of separation