auth.flow_state

#NameTypeNullableDefaultPK
1iduuidNOPK
2user_iduuidYES
3auth_codetextNO
4code_challenge_methodUSER-DEFINEDNO
5code_challengetextNO
6provider_typetextNO
7provider_access_tokentextYES
8provider_refresh_tokentextYES
9created_attimestamp with time zoneYES
10updated_attimestamp with time zoneYES
11authentication_methodtextNO
12auth_code_issued_attimestamp with time zoneYES

Indexes

NameDefinitionUniquePrimarySize
flow_state_created_at_idxCREATE INDEX flow_state_created_at_idx ON auth.flow_state USING btree (created_at DESC)8192 bytes
flow_state_pkeyCREATE UNIQUE INDEX flow_state_pkey ON auth.flow_state USING btree (id)8192 bytes
idx_auth_codeCREATE INDEX idx_auth_code ON auth.flow_state USING btree (auth_code)8192 bytes
idx_user_id_auth_methodCREATE INDEX idx_user_id_auth_method ON auth.flow_state USING btree (user_id, authentication_method)8192 bytes

Constraints

NameTypeDefinition
flow_state_pkeyPRIMARY KEYPRIMARY KEY (id)