CREATE TYPE public.full_code AS
(
	class smallint,
	subclass smallint,
	"group" character varying(2),
	subgroup character varying(2),
	sort character varying(2),
	subsort character varying(2)
);

CREATE TABLE public."Documents"
(
    document_id integer NOT NULL,
    document_type_id integer NOT NULL,
    document_name text NOT NULL,
    document_short_name text,
    full_code full_code,
    path_file text);

SELECT document_name 
FROM public."Documents" 
WHERE document_type_id = 1 AND (full_code).class = 1 AND (full_code).subclass = 1 AND (full_code).GROUP = '00' AND (full_code).subgroup = '00'
AND (full_code).sort = '00' AND (full_code).subsort = '00'
ORDER BY document_id