Skip to content

public.users_user_permissions

Columns

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

Constraints

Name Type Definition
users_user_permissio_permission_id_6d08dcd2_fk_auth_perm FOREIGN KEY FOREIGN KEY (permission_id) REFERENCES auth_permission(id) DEFERRABLE INITIALLY DEFERRED
users_user_permissions_pkey PRIMARY KEY PRIMARY KEY (id)
users_user_permissions_user_id_92473840_fk_users_id FOREIGN KEY FOREIGN KEY (user_id) REFERENCES users(id) DEFERRABLE INITIALLY DEFERRED
users_user_permissions_user_id_permission_id_3b86cbdf_uniq UNIQUE UNIQUE (user_id, permission_id)

Indexes

Name Definition
users_user_permissions_permission_id_6d08dcd2 CREATE INDEX users_user_permissions_permission_id_6d08dcd2 ON public.users_user_permissions USING btree (permission_id)
users_user_permissions_pkey CREATE UNIQUE INDEX users_user_permissions_pkey ON public.users_user_permissions USING btree (id)
users_user_permissions_user_id_92473840 CREATE INDEX users_user_permissions_user_id_92473840 ON public.users_user_permissions USING btree (user_id)
users_user_permissions_user_id_permission_id_3b86cbdf_uniq CREATE UNIQUE INDEX users_user_permissions_user_id_permission_id_3b86cbdf_uniq ON public.users_user_permissions USING btree (user_id, permission_id)

Generated by tbls