public.user_group¶

Description¶

Name	Type	Default	Nullable	Children	Parents	Comment
id	uuid		false	public.user_group_club public.member public.discount		Unique identifier of the user group.(DC2Type:uuid)
public_name	varchar(255)		false			Public display name of the user group visible to members.
internal_name	varchar(60)		false			Internal name of the user group for administrative purposes.
note	text		true			Optional notes or description about the user group.
created_at	timestamp(0) with time zone		false			The date and time when the user group was created.(DC2Type:datetimetz_immutable)
type	varchar(255)	NULL::character varying	false			Type of the user group: MANUAL or WELLPASS.
invite_code	varchar(10)		true			Unique invite code that allows users to join this group.
deactivated_by_id	uuid		true		public.user	User who deactivated this group (if applicable).(DC2Type:uuid)
deactivated_at	timestamp(0) with time zone	NULL::timestamp with time zone	true			The date and time when the user group was deactivated.(DC2Type:datetimetz_immutable)
active	boolean	true	false			Whether the user group is currently active.

Name	Type	Definition
fk_8f02bf9dbdc76baa	FOREIGN KEY	FOREIGN KEY (deactivated_by_id) REFERENCES "user"(id)
user_group_pkey	PRIMARY KEY	PRIMARY KEY (id)

Name	Definition
user_group_pkey	CREATE UNIQUE INDEX user_group_pkey ON public.user_group USING btree (id)
uniq_8f02bf9d6f21f112	CREATE UNIQUE INDEX uniq_8f02bf9d6f21f112 ON public.user_group USING btree (invite_code)
idx_8f02bf9dbdc76baa	CREATE INDEX idx_8f02bf9dbdc76baa ON public.user_group USING btree (deactivated_by_id)

Generated by tbls