sql/types/auth.user_roles_t.sql


1
2
3
4
5
6
7
8
9
10
11
12
13

drop type auth.user_roles_t cascade;

CREATE TYPE auth.user_roles_t AS (
    user_role_group_id bigint,
    user_id bigint,
    role_group_id bigint,
    role_group_name character varying,
    role_group_description character varying,
    role_group_role_id bigint,
    role_id bigint,
    role_name character varying,
    role_description character varying
);