bibliographic_record

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
obj_oid int8 19 null
holding.bibliographic_record_oid fkholding_bibliographic_recordC
identifier varchar 2147483647 null
title wcof_collated_string 2147483647 √ null
format varchar 2147483647 √ null
author wcof_collated_string_list 2147483647 √ null
contributor wcof_collated_string_list 2147483647 √ null
subject _varchar 2147483647 ARRAY[]::character varying[]
description varchar 2147483647 √ null
isbn wcof_isbn_number 2147483647 √ null
loc_control_number varchar 2147483647 √ null
publisher varchar 2147483647 √ null
publication_year int8 19 √ null
era varchar 2147483647 'AD'::character varying
edition varchar 2147483647 √ null
course varchar 2147483647 √ null
language varchar 2147483647 √ null
source varchar 2147483647 √ null
program_type varchar 2147483647 √ null
series_title wcof_collated_string 2147483647 √ null
country varchar 2147483647 √ null
alternative_title wcof_collated_string 2147483647 √ null
genre varchar 2147483647 √ null
captions wcof_tag 2147483647 √ null
series_volume_number varchar 2147483647 √ null
producer wcof_collated_string 2147483647 √ null
director wcof_collated_string 2147483647 √ null
performers wcof_collated_string_list 2147483647 √ null
run_time int8 19 √ null
color varchar 2147483647 √ null
sound varchar 2147483647 √ null
more_info varchar 2147483647 √ null
system wcof_tag 2147483647 √ null
zone int4 10 √ null
supporting_documentation bool 1 √ null
digitized bool 1 √ null
digital_catalog_number varchar 2147483647 √ null
archive_date timestamptz 35,6 √ null
archive_catalog_number varchar 2147483647 √ null
origin varchar 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
bibliographic_record_pkey Primary key Asc obj_oid
bibliographic_record_identifier_key Must be unique Asc identifier

Relationships

Close relationships within degrees of separation