public.team_member

Description

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
id	uuid		false			(DC2Type:uuid)
team_id	uuid		false		public.team	(DC2Type:uuid)
created_at	timestamp(0) without time zone		false			(DC2Type:datetime_immutable)
first_name	varchar(255)		true
last_name	varchar(255)		true
email_address	varchar(255)		false
user_id	uuid		true		public.user	(DC2Type:uuid)
role	varchar(255)	NULL::character varying	true

Constraints

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)

Indexes

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)

Relations

---

Generated by tbls