public.member¶

Description¶

Name	Type	Default	Nullable	Children	Parents	Comment
id	uuid		false	public.wellpass_account		(DC2Type:uuid)
group_id	uuid		false		public.user_group	(DC2Type:uuid)
user_id	uuid		true		public.user	(DC2Type:uuid)
created_at	timestamp(0) with time zone		false			(DC2Type:datetimetz_immutable)
email_address	varchar(255)	NULL::character varying	true
status	varchar(255)		false
added_by_id	uuid		true		public.user	(DC2Type:uuid)

Name	Type	Definition
fk_70e4fa7855b127a4	FOREIGN KEY	FOREIGN KEY (added_by_id) REFERENCES "user"(id)
fk_70e4fa78a76ed395	FOREIGN KEY	FOREIGN KEY (user_id) REFERENCES "user"(id)
fk_70e4fa78fe54d947	FOREIGN KEY	FOREIGN KEY (group_id) REFERENCES user_group(id)
member_pkey	PRIMARY KEY	PRIMARY KEY (id)

Name	Definition
member_pkey	CREATE UNIQUE INDEX member_pkey ON public.member USING btree (id)
idx_70e4fa78fe54d947	CREATE INDEX idx_70e4fa78fe54d947 ON public.member USING btree (group_id)
idx_70e4fa78a76ed395	CREATE INDEX idx_70e4fa78a76ed395 ON public.member USING btree (user_id)
uniq_70e4fa78a76ed395fe54d947	CREATE UNIQUE INDEX uniq_70e4fa78a76ed395fe54d947 ON public.member USING btree (user_id, group_id)
uniq_70e4fa78b08e074efe54d947	CREATE UNIQUE INDEX uniq_70e4fa78b08e074efe54d947 ON public.member USING btree (email_address, group_id)
idx_70e4fa7855b127a4	CREATE INDEX idx_70e4fa7855b127a4 ON public.member USING btree (added_by_id)

Generated by tbls