group_member

Columns

Name	Type	Default	Nullable	Children	Parents	Comment
group_id	bigint		false		public.app_group
user_id	bigint		false		public.app_user
added_at	timestamp with time zone	now()	false

Constraints

Name	Type	Definition
fk_group_member_user_id	FOREIGN KEY	FOREIGN KEY (user_id) REFERENCES app_user(id)
fk_group_member_group_id	FOREIGN KEY	FOREIGN KEY (group_id) REFERENCES app_group(id)
group_member_pkey	PRIMARY KEY	PRIMARY KEY (group_id, user_id)

Indexes

Name	Definition
group_member_pkey	CREATE UNIQUE INDEX group_member_pkey ON public.group_member USING btree (group_id, user_id)
ix_group_member_user_id	CREATE INDEX ix_group_member_user_id ON public.group_member USING btree (user_id)

Relations

---

Generated by tbls