actor.usr_mfa_factor_map

↑ actor schema

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

Columns

Column Type Nullable Default Notes

Column	Type	Nullable	Default	Notes
id PK	`integer`	No	nextval('actor.usr_mfa_factor_map_id_seq'::regclass)
usr FK	`bigint`	No		→ actor.usr(id)
factor FK	`text`	No		→ config.mfa_factor(name)
purpose	`text`	No	'mfa'::text
add_time	`timestamp with time zone`	No	now()

id PK

integer

nextval('actor.usr_mfa_factor_map_id_seq'::regclass)

usr FK

bigint

→ actor.usr(id)

factor FK

text

→ config.mfa_factor(name)

purpose

text

'mfa'::text

add_time

timestamp with time zone

now()

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)	NO ACTION	NO ACTION	DEFERRED	`usr_mfa_factor_map_factor_fkey`
`usr`	actor.usr(id)	NO ACTION	NO ACTION	DEFERRED	`usr_mfa_factor_map_usr_fkey`

factor

config.mfa_factor(name)

NO ACTION

DEFERRED

usr_mfa_factor_map_factor_fkey

usr

actor.usr(id)

NO ACTION

DEFERRED

usr_mfa_factor_map_usr_fkey

Indexes

Index Method Definition

Index	Method	Definition
`usr_mfa_factor_map_pkey` PK	btree	`CREATE UNIQUE INDEX usr_mfa_factor_map_pkey ON actor.usr_mfa_factor_map USING btree (id)`
`factor_purpose_usr_once` UNIQUE	btree	`CREATE UNIQUE INDEX factor_purpose_usr_once ON actor.usr_mfa_factor_map USING btree (usr, purpose, factor)`

usr_mfa_factor_map_pkey PK

btree

CREATE UNIQUE INDEX usr_mfa_factor_map_pkey ON actor.usr_mfa_factor_map USING btree (id)

factor_purpose_usr_once UNIQUE

btree

CREATE UNIQUE INDEX factor_purpose_usr_once ON actor.usr_mfa_factor_map USING btree (usr, purpose, factor)