Skip to content

public.users_groups

Columns

Name Type Default Nullable Children Parents Comment
group_id integer false
id bigint false
user_id bigint false public.users

Constraints

Name Type Definition
users_groups_group_id_2f3517aa_fk_auth_group_id FOREIGN KEY FOREIGN KEY (group_id) REFERENCES auth_group(id) DEFERRABLE INITIALLY DEFERRED
users_groups_pkey PRIMARY KEY PRIMARY KEY (id)
users_groups_user_id_f500bee5_fk_users_id FOREIGN KEY FOREIGN KEY (user_id) REFERENCES users(id) DEFERRABLE INITIALLY DEFERRED
users_groups_user_id_group_id_fc7788e8_uniq UNIQUE UNIQUE (user_id, group_id)

Indexes

Name Definition
users_groups_group_id_2f3517aa CREATE INDEX users_groups_group_id_2f3517aa ON public.users_groups USING btree (group_id)
users_groups_pkey CREATE UNIQUE INDEX users_groups_pkey ON public.users_groups USING btree (id)
users_groups_user_id_f500bee5 CREATE INDEX users_groups_user_id_f500bee5 ON public.users_groups USING btree (user_id)
users_groups_user_id_group_id_fc7788e8_uniq CREATE UNIQUE INDEX users_groups_user_id_group_id_fc7788e8_uniq ON public.users_groups USING btree (user_id, group_id)

Generated by tbls