serial.distribution

Cascading Deletes: Deleting rows from this table will cascade to: serial.subscription.

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: distribution_bind_call_number_fkey, distribution_bind_unit_template_fkey, distribution_holding_lib_fkey, distribution_receive_call_number_fkey, distribution_receive_unit_template_fkey, distribution_record_entry_fkey, distribution_subscription_fkey.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('serial.distribution_id_seq'::regclass)
record_entry FK	`bigint`	Yes		→ serial.record_entry(id)
summary_method	`text`	Yes
subscription FK	`integer`	No		→ serial.subscription(id)
holding_lib FK	`integer`	No		→ actor.org_unit(id)
label	`text`	No
display_grouping	`text`	No	'chron'::text
receive_call_number FK	`bigint`	Yes		→ asset.call_number(id)
receive_unit_template FK	`integer`	Yes		→ asset.copy_template(id)
bind_call_number FK	`bigint`	Yes		→ asset.call_number(id)
bind_unit_template FK	`integer`	Yes		→ asset.copy_template(id)
unit_label_prefix	`text`	Yes
unit_label_suffix	`text`	Yes

id PK

integer

nextval('serial.distribution_id_seq'::regclass)

record_entry FK

bigint

Yes

→ serial.record_entry(id)

summary_method

text

Yes

subscription FK

integer

→ serial.subscription(id)

holding_lib FK

integer

→ actor.org_unit(id)

label

text

display_grouping

text

'chron'::text

receive_call_number FK

bigint

Yes

→ asset.call_number(id)

receive_unit_template FK

integer

Yes

→ asset.copy_template(id)

bind_call_number FK

bigint

Yes

→ asset.call_number(id)

bind_unit_template FK

integer

Yes

→ asset.copy_template(id)

unit_label_prefix

text

Yes

unit_label_suffix

text

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`bind_call_number`	asset.call_number(id)	NO ACTION	NO ACTION	DEFERRED	`distribution_bind_call_number_fkey`
`bind_unit_template`	asset.copy_template(id)	NO ACTION	NO ACTION	DEFERRED	`distribution_bind_unit_template_fkey`
`holding_lib`	actor.org_unit(id)	NO ACTION	NO ACTION	DEFERRED	`distribution_holding_lib_fkey`
`receive_call_number`	asset.call_number(id)	NO ACTION	NO ACTION	DEFERRED	`distribution_receive_call_number_fkey`
`receive_unit_template`	asset.copy_template(id)	NO ACTION	NO ACTION	DEFERRED	`distribution_receive_unit_template_fkey`
`record_entry`	serial.record_entry(id)	SET NULL	NO ACTION	DEFERRED	`distribution_record_entry_fkey`
`subscription`	serial.subscription(id)	CASCADE	NO ACTION	DEFERRED	`distribution_subscription_fkey`

bind_call_number

asset.call_number(id)

NO ACTION

DEFERRED

distribution_bind_call_number_fkey

bind_unit_template

asset.copy_template(id)

NO ACTION

DEFERRED

distribution_bind_unit_template_fkey

holding_lib

actor.org_unit(id)

NO ACTION

DEFERRED

distribution_holding_lib_fkey

receive_call_number

asset.call_number(id)

NO ACTION

DEFERRED

distribution_receive_call_number_fkey

receive_unit_template

asset.copy_template(id)

NO ACTION

DEFERRED

distribution_receive_unit_template_fkey

record_entry

serial.record_entry(id)

SET NULL

NO ACTION

DEFERRED

distribution_record_entry_fkey

subscription

serial.subscription(id)

CASCADE

NO ACTION

DEFERRED

distribution_subscription_fkey

Check Constraints

distribution_display_grouping_check: CHECK display_grouping = ANY (ARRAY['enum'::text, 'chron'::text])
sdist_summary_method_check: CHECK

Indexes

Index Method Definition

Index	Method	Definition
`distribution_pkey` PK	btree	`CREATE UNIQUE INDEX distribution_pkey ON serial.distribution USING btree (id)`
`one_dist_per_sre_idx` UNIQUE	btree	`CREATE UNIQUE INDEX one_dist_per_sre_idx ON serial.distribution USING btree (record_entry)`
`serial_distribution_holding_lib_idx`	btree	`CREATE INDEX serial_distribution_holding_lib_idx ON serial.distribution USING btree (holding_lib)`
`serial_distribution_sub_idx`	btree	`CREATE INDEX serial_distribution_sub_idx ON serial.distribution USING btree (subscription)`

distribution_pkey PK

btree

CREATE UNIQUE INDEX distribution_pkey ON serial.distribution USING btree (id)

one_dist_per_sre_idx UNIQUE

btree

CREATE UNIQUE INDEX one_dist_per_sre_idx ON serial.distribution USING btree (record_entry)

serial_distribution_holding_lib_idx

btree

CREATE INDEX serial_distribution_holding_lib_idx ON serial.distribution USING btree (holding_lib)

serial_distribution_sub_idx

btree

CREATE INDEX serial_distribution_sub_idx ON serial.distribution USING btree (subscription)

Referenced By

The following tables have foreign keys pointing to serial.distribution (5 referencing table(s)):

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

Table	Referencing Column(s)	Referenced Column(s)	Constraint
serial.basic_summary	`distribution`	`id`	`basic_summary_distribution_fkey`
serial.distribution_note	`distribution`	`id`	`distribution_note_distribution_fkey`
serial.index_summary	`distribution`	`id`	`index_summary_distribution_fkey`
serial.stream	`distribution`	`id`	`stream_distribution_fkey`
serial.supplement_summary	`distribution`	`id`	`supplement_summary_distribution_fkey`