serial.subscription

↑ serial schema

Deferrable Constraints: The following FK constraints are deferrable — they are checked at transaction end, not statement end: subscription_owning_lib_fkey, subscription_record_entry_fkey.

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('serial.subscription_id_seq'::regclass)
owning_lib FK	`integer`	No	1	→ actor.org_unit(id)
start_date	`timestamp with time zone`	No
end_date	`timestamp with time zone`	Yes
record_entry FK	`bigint`	Yes		→ biblio.record_entry(id)
expected_date_offset	`interval`	Yes

id PK

integer

nextval('serial.subscription_id_seq'::regclass)

owning_lib FK

integer

→ actor.org_unit(id)

start_date

timestamp with time zone

end_date

timestamp with time zone

Yes

record_entry FK

bigint

Yes

→ biblio.record_entry(id)

expected_date_offset

interval

Yes

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`owning_lib`	actor.org_unit(id)	SET NULL	NO ACTION	DEFERRED	`subscription_owning_lib_fkey`
`record_entry`	biblio.record_entry(id)	SET NULL	NO ACTION	DEFERRED	`subscription_record_entry_fkey`

owning_lib

actor.org_unit(id)

SET NULL

NO ACTION

DEFERRED

subscription_owning_lib_fkey

record_entry

biblio.record_entry(id)

SET NULL

NO ACTION

DEFERRED

subscription_record_entry_fkey

Indexes

Index Method Definition

Index	Method	Definition
`subscription_pkey` PK	btree	`CREATE UNIQUE INDEX subscription_pkey ON serial.subscription USING btree (id)`
`serial_subscription_owner_idx`	btree	`CREATE INDEX serial_subscription_owner_idx ON serial.subscription USING btree (owning_lib)`
`serial_subscription_record_idx`	btree	`CREATE INDEX serial_subscription_record_idx ON serial.subscription USING btree (record_entry)`

subscription_pkey PK

btree

CREATE UNIQUE INDEX subscription_pkey ON serial.subscription USING btree (id)

serial_subscription_owner_idx

btree

CREATE INDEX serial_subscription_owner_idx ON serial.subscription USING btree (owning_lib)

serial_subscription_record_idx

btree

CREATE INDEX serial_subscription_record_idx ON serial.subscription USING btree (record_entry)

Referenced By

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

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

Table	Referencing Column(s)	Referenced Column(s)	Constraint
serial.caption_and_pattern	`subscription`	`id`	`caption_and_pattern_subscription_fkey`
serial.distribution	`subscription`	`id`	`distribution_subscription_fkey`
serial.issuance	`subscription`	`id`	`issuance_subscription_fkey`
serial.subscription_note	`subscription`	`id`	`subscription_note_subscription_fkey`