Skip to content

public.wellpass_account

Description

Columns

Name Type Default Nullable Children Parents Comment
id uuid false Unique identifier of the Wellpass account.(DC2Type:uuid)
created_at timestamp(0) with time zone false The date and time when the Wellpass account record was created.(DC2Type:datetimetz_immutable)
is_linked boolean false false Whether the Wellpass account is currently linked to the user.
linked_at timestamp(0) with time zone NULL::timestamp with time zone true The date and time when the Wellpass account was linked.(DC2Type:datetimetz_immutable)
member_account_id varchar(255) NULL::character varying true The Wellpass member account identifier.
owner_id uuid false public.user The user who owns this Wellpass account.(DC2Type:uuid)
linked_with_email_address varchar(255) true The email address used to link the Wellpass account.
user_group_member_id uuid true public.member The user group member associated with this Wellpass account.(DC2Type:uuid)

Constraints

Name Type Definition
fk_80e0e7c77e3c61f9 FOREIGN KEY FOREIGN KEY (owner_id) REFERENCES "user"(id)
fk_80e0e7c7a7f8e390 FOREIGN KEY FOREIGN KEY (user_group_member_id) REFERENCES member(id)
wellpass_account_pkey PRIMARY KEY PRIMARY KEY (id)

Indexes

Name Definition
wellpass_account_pkey CREATE UNIQUE INDEX wellpass_account_pkey ON public.wellpass_account USING btree (id)
idx_80e0e7c77e3c61f9 CREATE INDEX idx_80e0e7c77e3c61f9 ON public.wellpass_account USING btree (owner_id)
uniq_80e0e7c7a7f8e390 CREATE UNIQUE INDEX uniq_80e0e7c7a7f8e390 ON public.wellpass_account USING btree (user_group_member_id)

Relations

er


Generated by tbls