Skip to content

public.email_address

Description

Columns

Name Type Default Nullable Children Parents Comment
id uuid false public.user (DC2Type:uuid)
user_id uuid true public.user (DC2Type:uuid)
email_address varchar(255) false
confirmation_token uuid false (DC2Type:uuid)
is_ownership_confirmed boolean false
ownership_confirmed_at timestamp(0) without time zone NULL::timestamp without time zone true (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

er

Generated by tbls