asset.copy_location_group

↑ asset schema

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

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('asset.copy_location_group_id_seq'::regclass)

name

text

No

owner FK

integer

No

→ actor.org_unit(id)

pos

integer

No

0

top

boolean

No

false

opac_visible

boolean

No

true

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

owner

actor.org_unit(id)

CASCADE

NO ACTION

DEFERRED

copy_location_group_owner_fkey

Unique Constraints

  • lgroup_once_per_owner: (owner, name)

Indexes

Index Method Definition

copy_location_group_pkey PK

btree

CREATE UNIQUE INDEX copy_location_group_pkey ON asset.copy_location_group USING btree (id)

lgroup_once_per_owner UNIQUE

btree

CREATE UNIQUE INDEX lgroup_once_per_owner ON asset.copy_location_group USING btree (owner, name)

Referenced By

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

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

asset.copy_location_group_map

lgroup

id

copy_location_group_map_lgroup_fkey

rating.badge

loc_grp_filter

id

badge_loc_grp_filter_fkey
Previous
Next