config.bib_source

↑ config schema

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 Nullable Default Notes

Column	Type	Nullable	Default
id PK	`integer`	No	nextval('config.bib_source_id_seq'::regclass)
quality	`integer`	Yes
source	`text`	No
transcendant	`boolean`	No	false
can_have_copies	`boolean`	No	true

id PK

integer

nextval('config.bib_source_id_seq'::regclass)

quality

integer

Yes

source

text

transcendant

boolean

false

can_have_copies

boolean

true

Primary Key

(id)

Unique Constraints

bib_source_source_key: (source)

Check Constraints

bib_source_quality_check: CHECK

Indexes

Index Method Definition

Index	Method	Definition
`bib_source_pkey` PK	btree	`CREATE UNIQUE INDEX bib_source_pkey ON config.bib_source USING btree (id)`
`bib_source_source_key` UNIQUE	btree	`CREATE UNIQUE INDEX bib_source_source_key ON config.bib_source USING btree (source)`

bib_source_pkey PK

btree

CREATE UNIQUE INDEX bib_source_pkey ON config.bib_source USING btree (id)

bib_source_source_key UNIQUE

btree

CREATE UNIQUE INDEX bib_source_source_key ON config.bib_source USING btree (source)

Referenced By

The following tables have foreign keys pointing to config.bib_source (2 referencing table(s)):

Table Referencing Column(s) Referenced Column(s) Constraint

Table	Referencing Column(s)	Referenced Column(s)	Constraint
rating.badge	`src_filter`	`id`	`badge_src_filter_fkey`
vandelay.queued_bib_record	`bib_source`	`id`	`queued_bib_record_bib_source_fkey`

rating.badge

src_filter

id

badge_src_filter_fkey

vandelay.queued_bib_record

bib_source

id

queued_bib_record_bib_source_fkey