public.team_member¶

Description¶

Name	Type	Default	Nullable	Parents	Comment
id	uuid		false		Unique identifier of the team member.(DC2Type:uuid)
team_id	uuid		false	public.team	Reference to the team this member belongs to.(DC2Type:uuid)
created_at	timestamp(0) without time zone		false		The date and time when the team member was added.(DC2Type:datetime_immutable)
first_name	varchar(255)		true		First name of the team member.
last_name	varchar(255)		true		Last name of the team member.
email_address	varchar(255)		false		Email address of the team member, used for communication and identification.
user_id	uuid		true	public.user	Reference to the user account if the team member is registered.(DC2Type:uuid)
role	varchar(255)	NULL::character varying	true		Role of the team member: OWNER or MEMBER.

Name	Type	Definition
fk_6ffbda1a76ed395	FOREIGN KEY	FOREIGN KEY (user_id) REFERENCES "user"(id)
fk_6ffbda1296cd8ae	FOREIGN KEY	FOREIGN KEY (team_id) REFERENCES team(id)
team_member_pkey	PRIMARY KEY	PRIMARY KEY (id)

Name	Definition
team_member_pkey	CREATE UNIQUE INDEX team_member_pkey ON public.team_member USING btree (id)
idx_6ffbda1296cd8ae	CREATE INDEX idx_6ffbda1296cd8ae ON public.team_member USING btree (team_id)
uniq_6ffbda1296cd8aeb08e074e	CREATE UNIQUE INDEX uniq_6ffbda1296cd8aeb08e074e ON public.team_member USING btree (team_id, email_address)
idx_6ffbda1a76ed395	CREATE INDEX idx_6ffbda1a76ed395 ON public.team_member USING btree (user_id)

Generated by tbls