asset.copy_location_order

Cascading Deletes: Deleting rows from this table will cascade to: asset.copy_location, actor.org_unit.

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('asset.copy_location_order_id_seq'::regclass)
location FK	`integer`	No		→ asset.copy_location(id)
org FK	`integer`	No		→ actor.org_unit(id)
position	`integer`	No	0

id PK

integer

nextval('asset.copy_location_order_id_seq'::regclass)

location FK

integer

→ asset.copy_location(id)

org FK

integer

→ actor.org_unit(id)

position

integer

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`location`	asset.copy_location(id)	CASCADE	NO ACTION	DEFERRED	`copy_location_order_location_fkey`
`org`	actor.org_unit(id)	CASCADE	NO ACTION	DEFERRED	`copy_location_order_org_fkey`

location

asset.copy_location(id)

CASCADE

NO ACTION

DEFERRED

copy_location_order_location_fkey

org

actor.org_unit(id)

CASCADE

NO ACTION

DEFERRED

copy_location_order_org_fkey

Unique Constraints

acplo_once_per_org: (location, org)

Indexes

Index Method Definition

Index	Method	Definition
`copy_location_order_pkey` PK	btree	`CREATE UNIQUE INDEX copy_location_order_pkey ON asset.copy_location_order USING btree (id)`
`acplo_once_per_org` UNIQUE	btree	`CREATE UNIQUE INDEX acplo_once_per_org ON asset.copy_location_order USING btree (location, org)`

copy_location_order_pkey PK

btree

CREATE UNIQUE INDEX copy_location_order_pkey ON asset.copy_location_order USING btree (id)

acplo_once_per_org UNIQUE

btree

CREATE UNIQUE INDEX acplo_once_per_org ON asset.copy_location_order USING btree (location, org)