actor.org_lasso_map

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

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('actor.org_lasso_map_id_seq'::regclass)
lasso FK	`integer`	No		→ actor.org_lasso(id)
org_unit FK	`integer`	No		→ actor.org_unit(id)

id PK

integer

nextval('actor.org_lasso_map_id_seq'::regclass)

lasso FK

integer

→ actor.org_lasso(id)

org_unit FK

integer

→ actor.org_unit(id)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`lasso`	actor.org_lasso(id)	CASCADE	NO ACTION	DEFERRED	`org_lasso_map_lasso_fkey`
`org_unit`	actor.org_unit(id)	CASCADE	NO ACTION	DEFERRED	`org_lasso_map_org_unit_fkey`

lasso

actor.org_lasso(id)

CASCADE

NO ACTION

DEFERRED

org_lasso_map_lasso_fkey

org_unit

actor.org_unit(id)

CASCADE

NO ACTION

DEFERRED

org_lasso_map_org_unit_fkey

Indexes

Index Method Definition

Index	Method	Definition
`org_lasso_map_pkey` PK	btree	`CREATE UNIQUE INDEX org_lasso_map_pkey ON actor.org_lasso_map USING btree (id)`
`ou_lasso_lasso_ou_idx` UNIQUE	btree	`CREATE UNIQUE INDEX ou_lasso_lasso_ou_idx ON actor.org_lasso_map USING btree (lasso, org_unit)`
`ou_lasso_org_unit_idx`	btree	`CREATE INDEX ou_lasso_org_unit_idx ON actor.org_lasso_map USING btree (org_unit)`

org_lasso_map_pkey PK

btree

CREATE UNIQUE INDEX org_lasso_map_pkey ON actor.org_lasso_map USING btree (id)

ou_lasso_lasso_ou_idx UNIQUE

btree

CREATE UNIQUE INDEX ou_lasso_lasso_ou_idx ON actor.org_lasso_map USING btree (lasso, org_unit)

ou_lasso_org_unit_idx

btree

CREATE INDEX ou_lasso_org_unit_idx ON actor.org_lasso_map USING btree (org_unit)