permission.group_mfa_factor_map

Cascading Deletes: Deleting rows from this table will cascade to: config.mfa_factor, permission.grp_tree.

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('permission.group_mfa_factor_map_id_seq'::regclass)
grp FK	`integer`	No		→ permission.grp_tree(id)
factor FK	`text`	No		→ config.mfa_factor(name)

id PK

integer

nextval('permission.group_mfa_factor_map_id_seq'::regclass)

grp FK

integer

→ permission.grp_tree(id)

factor FK

text

→ config.mfa_factor(name)

Primary Key

(id)

Foreign Keys

Column(s) References On Delete On Update Deferrable Constraint

Column(s)	References	On Delete	On Update	Deferrable	Constraint
`factor`	config.mfa_factor(name)	CASCADE	NO ACTION	DEFERRED	`group_mfa_factor_map_factor_fkey`
`grp`	permission.grp_tree(id)	CASCADE	NO ACTION	DEFERRED	`group_mfa_factor_map_grp_fkey`

factor

config.mfa_factor(name)

CASCADE

NO ACTION

DEFERRED

group_mfa_factor_map_factor_fkey

grp

permission.grp_tree(id)

CASCADE

NO ACTION

DEFERRED

group_mfa_factor_map_grp_fkey

Indexes

Index Method Definition

Index	Method	Definition
`group_mfa_factor_map_pkey` PK	btree	`CREATE UNIQUE INDEX group_mfa_factor_map_pkey ON permission.group_mfa_factor_map USING btree (id)`

group_mfa_factor_map_pkey PK

btree

CREATE UNIQUE INDEX group_mfa_factor_map_pkey ON permission.group_mfa_factor_map USING btree (id)