asset.copy_location_group_map

↑ asset schema

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

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

Columns

Column Type Nullable Default Notes

id PK

integer

No

nextval('asset.copy_location_group_map_id_seq'::regclass)

location FK

integer

No

→ asset.copy_location(id)

lgroup FK

integer

No

→ asset.copy_location_group(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

lgroup

asset.copy_location_group(id)

CASCADE

NO ACTION

DEFERRED

copy_location_group_map_lgroup_fkey

location

asset.copy_location(id)

CASCADE

NO ACTION

DEFERRED

copy_location_group_map_location_fkey

Unique Constraints

  • lgroup_once_per_group: (lgroup, location)

Indexes

Index Method Definition

copy_location_group_map_pkey PK

btree

CREATE UNIQUE INDEX copy_location_group_map_pkey ON asset.copy_location_group_map USING btree (id)

lgroup_once_per_group UNIQUE

btree

CREATE UNIQUE INDEX lgroup_once_per_group ON asset.copy_location_group_map USING btree (lgroup, location)
Previous
Next