bib_source

-1 rows


Description

This is table is used to set up the relative “quality” of each MARC source, such as OCLC. Also identifies “transcendant” sources, i.e., sources of bib records that should display in the OPAC even if no copies or located URIs are attached. Also indicates if the source is allowed to have actual copies on its bibs. Volumes for targeted URIs are unaffected by this setting.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('config.bib_source_id_seq'::regclass)
badge.src_filter badge_src_filter_fkey N
queued_bib_record.bib_source queued_bib_record_bib_source_fkey R
quality int4 10 √ null
source text 2147483647 null
transcendant bool 1 false
can_have_copies bool 1 true

Indexes

Constraint Name Type Sort Column(s)
bib_source_pkey Primary key Asc id
bib_source_source_key Must be unique Asc source

Check Constraints

Constraint Name Constraint
bib_source_quality_check (((quality >= 0) AND (quality <= 100)))

Relationships

Close relationships within degrees of separation