public.email_address

Description

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	uuid		false	public.user		Unique identifier of the email address.(DC2Type:uuid)
user_id	uuid		true		public.user	Unique identifier of the user.(DC2Type:uuid)
email_address	varchar(255)		false			The email address value.
confirmation_token	uuid		false			UUID token used for email ownership confirmation.(DC2Type:uuid)
is_ownership_confirmed	boolean		false			Whether the email ownership has been confirmed by the user.
ownership_confirmed_at	timestamp(0) without time zone	NULL::timestamp without time zone	true			The date and time when email ownership was confirmed.(DC2Type:datetime_immutable)

Constraints

Name	Type	Definition
email_address_pkey	PRIMARY KEY	PRIMARY KEY (id)
fk_b08e074ea76ed395	FOREIGN KEY	FOREIGN KEY (user_id) REFERENCES "user"(id)

Indexes

Name	Definition
email_address_pkey	CREATE UNIQUE INDEX email_address_pkey ON public.email_address USING btree (id)
uniq_b08e074ea76ed395	CREATE UNIQUE INDEX uniq_b08e074ea76ed395 ON public.email_address USING btree (user_id)

Relations

---

Generated by tbls