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 Unique identifier of the user.(DC2Type:uuid)
first_name varchar(255) NULL::character varying true User first name.
last_name varchar(255) NULL::character varying true User last name.
email varchar(255) NULL::character varying true User email address. Deprecated in favor of emailAddress relation.
gender varchar(255) NULL::character varying true User gender.
birthday date true User date of birth.(DC2Type:date_immutable)
skill_level varchar(255) NULL::character varying true User skill level in padel.
is_age_public boolean false Whether the user age is publicly visible to other users.
profile_image_path varchar(255) NULL::character varying true File path to the user profile image.
is_marketing_consent_granted boolean false false Whether the user has granted consent for marketing communications.
marketing_consent_granted_at timestamp(0) with time zone NULL::timestamp with time zone true The date and time when marketing consent was granted.(DC2Type:datetimetz_immutable)
get_stream_token text true Authentication token for GetStream chat service.
email_address_id uuid true public.email_address Email address entity associated with this user.(DC2Type:uuid)
preferred_playing_times text true User preferred playing time slots.(DC2Type:simple_array)
dominant_hands text true User dominant hands (left, right, or both).(DC2Type:simple_array)
locale varchar(255) 'de'::character varying false User preferred language locale.
is_deleted boolean false false Soft delete flag indicating if the user account is deleted.
deleted_at timestamp(0) with time zone NULL::timestamp with time zone true The date and time when the user account was deleted.(DC2Type:datetimetz_immutable)
created_at timestamp(0) with time zone '2013-01-01 13:37:00+00'::timestamp with time zone false The date and time when the user account was created.(DC2Type:datetimetz_immutable)
phone_number varchar(255) NULL::character varying true User phone number.

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