acq.serial_claim

↑ acq schema

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('acq.serial_claim_id_seq'::regclass)
type FK	`integer`	No		→ acq.claim_type(id)
item FK	`bigint`	No		→ serial.item(id)

id PK

integer

nextval('acq.serial_claim_id_seq'::regclass)

type FK

integer

→ acq.claim_type(id)

item FK

bigint

→ serial.item(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`item`	serial.item(id)	NO ACTION	NO ACTION	DEFERRED	`serial_claim_item_fkey`
`type`	acq.claim_type(id)	NO ACTION	NO ACTION	DEFERRED	`serial_claim_type_fkey`

item

serial.item(id)

NO ACTION

DEFERRED

serial_claim_item_fkey

type

acq.claim_type(id)

NO ACTION

DEFERRED

serial_claim_type_fkey

Indexes

Index Method Definition

Index	Method	Definition
`serial_claim_pkey` PK	btree	`CREATE UNIQUE INDEX serial_claim_pkey ON acq.serial_claim USING btree (id)`
`serial_claim_lid_idx`	btree	`CREATE INDEX serial_claim_lid_idx ON acq.serial_claim USING btree (item)`

serial_claim_pkey PK

btree

CREATE UNIQUE INDEX serial_claim_pkey ON acq.serial_claim USING btree (id)

serial_claim_lid_idx

btree

CREATE INDEX serial_claim_lid_idx ON acq.serial_claim USING btree (item)

Referenced By

The following tables have foreign keys pointing to acq.serial_claim (1 referencing table(s)):

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

Table	Referencing Column(s)	Referenced Column(s)	Constraint
acq.serial_claim_event	`claim`	`id`	`serial_claim_event_claim_fkey`

acq.serial_claim_event

claim

id

serial_claim_event_claim_fkey