app_user_identity

Description

A way to sign in as a user (identity provider + subject). Invariant (application): a user cannot remove their last remaining identity.

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	bigint	nextval(‘app_user_identity_seq’::regclass)	false
user_id	bigint		false		public.app_user
provider	varchar(255)		false
provider_user_id	varchar(255)		false
email	varchar(255)		true
email_verified	boolean		true
created_at	timestamp with time zone	now()	false
updated_at	timestamp with time zone		true

Constraints

Name	Type	Definition
fk_app_user_identity_user_id	FOREIGN KEY	FOREIGN KEY (user_id) REFERENCES app_user(id)
app_user_identity_pkey	PRIMARY KEY	PRIMARY KEY (id)
uq_app_user_identity_provider_provider_user_id	UNIQUE	UNIQUE (provider, provider_user_id)

Indexes

Name	Definition
app_user_identity_pkey	CREATE UNIQUE INDEX app_user_identity_pkey ON public.app_user_identity USING btree (id)
uq_app_user_identity_provider_provider_user_id	CREATE UNIQUE INDEX uq_app_user_identity_provider_provider_user_id ON public.app_user_identity USING btree (provider, provider_user_id)
ix_app_user_identity_user_id	CREATE INDEX ix_app_user_identity_user_id ON public.app_user_identity USING btree (user_id)

Relations

---

Generated by tbls