db_globoxylo

View: v_metadonnees_zone_appli

Schema

application

Owner

globoxylo_application

Descriptions

vue permettant un affichage travaillé des métadonnées de zones d'étude.

Columns

Rules

Indices

There are no indices for table v_metadonnees_zone_appli

Definition

CREATE VIEW application.v_metadonnees_zone_appli (
   hierarchie,
   hierarchie_parent,
   inherited,
   date_measure,
   variable_name,
   code,
   value,
   unit,
   unit_symbol,
   protocol,
   id_zone,
   id_zone_parent)
AS
SELECT v_metadonnees_zone.ltree_child AS hierarchie,
       CASE
           WHEN v_metadonnees_zone.inherited THEN v_metadonnees_zone.ltree_parent
           ELSE NULL::ltree
       END AS hierarchie_parent,
   v_metadonnees_zone.inherited,
   v_metadonnees_zone.date_measure,
   v_metadonnees_zone.var_name AS variable_name,
   v_metadonnees_zone.var_code AS code,
   v_metadonnees_zone.value,
   v_metadonnees_zone.uni_name AS unit,
   v_metadonnees_zone.uni_symbol AS unit_symbol,
   v_metadonnees_zone.prot_description AS protocol,
   v_metadonnees_zone.id_child AS id_zone,
       CASE
           WHEN v_metadonnees_zone.id_parent <> v_metadonnees_zone.id_child
               THEN v_metadonnees_zone.id_parent
           ELSE NULL::integer
       END AS id_zone_parent
FROM v_metadata_zone v_metadonnees_zone
ORDER BY v_metadonnees_zone.ltree_child, v_metadonnees_zone.inherited,
   v_metadonnees_zone.ltree_parent;

COMMENT ON VIEW application.v_metadonnees_zone_appli
IS 'vue permettant un affichage travaillé des métadonnées de zones d''étude.';

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com)