publication_formats

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
publication_format_id bigserial 19 nextval('publication_formats_publication_format_id_seq'::regclass)
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 int8 19 null
publications.publication_id publication_formats_publication_idC
submission_id int8 19 null
physical_format int2 5 '1'::smallint
entry_key varchar 64 null
seq float8 17,17 '0'::double precision
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 int2 5 '0'::smallint
is_available int2 5 '0'::smallint
doi_id int8 19 null
dois.doi_id publication_formats_doi_id_foreignN

Indexes

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

Relationships