Skip to content

public.user

Description

Columns

Name Type Default Nullable Children Parents Comment
id uuid false public.coach public.court_blocker public.document_approval public.email_address public.game public.liked_clubs public.match_player public.payment_intent public.voucher public.voucher_redemption public.user_group public.member public.match_series public.club_event public.event_registration public.team_member public.wellpass_account public.cancellation public.voucher_reservation (DC2Type:uuid)
first_name varchar(255) NULL::character varying true
last_name varchar(255) NULL::character varying true
email varchar(255) NULL::character varying true
gender varchar(255) NULL::character varying true
birthday date true (DC2Type:date_immutable)
skill_level varchar(255) NULL::character varying true
is_age_public boolean false
profile_image_path varchar(255) NULL::character varying true
is_marketing_consent_granted boolean false false
marketing_consent_granted_at timestamp(0) with time zone NULL::timestamp with time zone true (DC2Type:datetimetz_immutable)
get_stream_token text true
email_address_id uuid true public.email_address (DC2Type:uuid)
preferred_playing_times text true (DC2Type:simple_array)
dominant_hands text true (DC2Type:simple_array)
locale varchar(255) 'de'::character varying false
is_deleted boolean false false
deleted_at timestamp(0) with time zone NULL::timestamp with time zone true (DC2Type:datetimetz_immutable)
created_at timestamp(0) with time zone '2013-01-01 13:37:00+00'::timestamp with time zone false (DC2Type:datetimetz_immutable)
phone_number varchar(255) NULL::character varying true

Constraints

Name Type Definition
fk_8d93d64959045daa FOREIGN KEY FOREIGN KEY (email_address_id) REFERENCES email_address(id)
user_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
user_pkey CREATE UNIQUE INDEX user_pkey ON public."user" USING btree (id)
uniq_8d93d64959045daa CREATE UNIQUE INDEX uniq_8d93d64959045daa ON public."user" USING btree (email_address_id)

Relations

er


Generated by tbls