auth.mfa_factors

#	Name	Type	Nullable	Default	PK
1	`id`	uuid	NO	—	PK
2	`user_id`	uuid	NO	—
3	`friendly_name`	text	YES	—
4	`factor_type`	USER-DEFINED	NO	—
5	`status`	USER-DEFINED	NO	—
6	`created_at`	timestamp with time zone	NO	—
7	`updated_at`	timestamp with time zone	NO	—
8	`secret`	text	YES	—

Name	Definition	Unique	Primary	Size
factor_id_created_at_idx	`CREATE INDEX factor_id_created_at_idx ON auth.mfa_factors USING btree (user_id, created_at)`			8192 bytes
mfa_factors_pkey	`CREATE UNIQUE INDEX mfa_factors_pkey ON auth.mfa_factors USING btree (id)`	✓	✓	8192 bytes
mfa_factors_user_friendly_name_unique	`CREATE UNIQUE INDEX mfa_factors_user_friendly_name_unique ON auth.mfa_factors USING btree (friendly_name, user_id) WHERE (TRIM(BOTH FROM friendly_name) <> ''::text)`	✓		8192 bytes
mfa_factors_user_id_idx	`CREATE INDEX mfa_factors_user_id_idx ON auth.mfa_factors USING btree (user_id)`			8192 bytes

Name	Type	Definition
mfa_factors_user_id_fkey	FOREIGN KEY	`FOREIGN KEY (user_id) REFERENCES auth.users(id) ON DELETE CASCADE`
mfa_factors_pkey	PRIMARY KEY	`PRIMARY KEY (id)`