config.floating_group_member

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('config.floating_group_member_id_seq'::regclass)
floating_group FK	`integer`	No		→ config.floating_group(id)
org_unit FK	`integer`	No		→ actor.org_unit(id)
stop_depth	`integer`	No	0
max_depth	`integer`	Yes
exclude	`boolean`	No	false

id PK

integer

No

nextval('config.floating_group_member_id_seq'::regclass)

floating_group FK

integer

No

org_unit FK

integer

No

stop_depth

integer

No

0

max_depth

integer

Yes

exclude

boolean

No

false

(id)

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`floating_group`	config.floating_group(id)	NO ACTION	NO ACTION	No	`floating_group_member_floating_group_fkey`
`org_unit`	actor.org_unit(id)	NO ACTION	NO ACTION	No	`floating_group_member_org_unit_fkey`

floating_group

NO ACTION

No

floating_group_member_floating_group_fkey

org_unit

NO ACTION

No

floating_group_member_org_unit_fkey

Index Method Definition

Index	Method	Definition
`floating_group_member_pkey` PK	btree	`CREATE UNIQUE INDEX floating_group_member_pkey ON config.floating_group_member USING btree (id)`

floating_group_member_pkey PK

btree

CREATE UNIQUE INDEX floating_group_member_pkey ON config.floating_group_member USING btree (id)