 ----------------------------------
 -- VIEWS AND MATERIALIZED VIEWS --
 ----------------------------------
+
 CREATE MATERIALIZED VIEW gn_profiles.vm_valid_profiles AS
 SELECT DISTINCT
 	t.cd_ref AS cd_ref,

LEFT JOIN taxonomie.taxref t ON p.cd_nom=t.cd_nom;


-----------
-- INDEX --
-----------

---------------
--PRIMARY KEY--
---------------

ALTER TABLE ONLY gn_profiles.t_parameters 
	ADD CONSTRAINT pk_parameters PRIMARY KEY (id_parameter);

