releases_node_attributes_view

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

release_id

int4

√

null

context_id

int4

√

null

country

text

2147483647

√

null

commodity

text

2147483647

√

null

attribute_type

text

2147483647

√

null

attribute_name

text

2147483647

√

null

years

_float8

17,17

√

null

Table contained 0 rows

View Definition

SELECT foo.release_id,
    foo.context_id,
    foo.country,
    foo.commodity,
    foo.attribute_type,
    foo.attribute_name,
    foo.years
   FROM ( SELECT release_node_quants.release_id,
            release_node_quants.context_id,
            node_names.name AS country,
            commodity_names.name AS commodity,
            'quant'::text AS attribute_type,
            quants.name AS attribute_name,
            quant_years.years
           FROM (((((release_node_quants
             JOIN quants ON ((release_node_quants.quant_id = quants.id)))
             JOIN contexts ON ((release_node_quants.context_id = contexts.id)))
             JOIN node_names ON ((contexts.country_id = node_names.node_id)))
             JOIN commodity_names ON ((commodity_names.com_id = contexts.com_id)))
             JOIN ( SELECT DISTINCT node_quants.quant_id AS id,
                    array_agg(DISTINCT date_part('year'::text, node_quants.time_start)) AS years
                   FROM node_quants
                  GROUP BY node_quants.quant_id) quant_years ON ((quant_years.id = quants.id)))
          WHERE (node_names.is_default AND commodity_names.is_default)
        UNION
         SELECT release_node_quals.release_id,
            release_node_quals.context_id,
            node_names.name AS country,
            commodity_names.name AS commodity,
            'qual'::text AS attribute_type,
            quals.name AS attribute_name,
            qual_years.years
           FROM (((((release_node_quals
             JOIN quals ON ((release_node_quals.qual_id = quals.id)))
             JOIN contexts ON ((release_node_quals.context_id = contexts.id)))
             JOIN node_names ON ((contexts.country_id = node_names.node_id)))
             JOIN commodity_names ON ((commodity_names.com_id = contexts.com_id)))
             JOIN ( SELECT DISTINCT node_quals.qual_id AS id,
                    array_agg(DISTINCT date_part('year'::text, node_quals.time_start)) AS years
                   FROM node_quals
                  GROUP BY node_quals.qual_id) qual_years ON ((qual_years.id = quals.id)))
          WHERE (node_names.is_default AND commodity_names.is_default)
        UNION
         SELECT release_node_inds.release_id,
            release_node_inds.context_id,
            node_names.name AS country,
            commodity_names.name AS commodity,
            'ind'::text AS attribute_type,
            inds.name AS attribute_name,
            ind_years.years
           FROM (((((release_node_inds
             JOIN inds ON ((release_node_inds.ind_id = inds.id)))
             JOIN contexts ON ((release_node_inds.context_id = contexts.id)))
             JOIN node_names ON ((contexts.country_id = node_names.node_id)))
             JOIN commodity_names ON ((commodity_names.com_id = contexts.com_id)))
             JOIN ( SELECT DISTINCT node_inds.ind_id AS id,
                    array_agg(DISTINCT date_part('year'::text, node_inds.time_start)) AS years
                   FROM node_inds
                  GROUP BY node_inds.ind_id) ind_years ON ((ind_years.id = inds.id)))
          WHERE (node_names.is_default AND commodity_names.is_default)) foo
  ORDER BY foo.release_id, foo.context_id, foo.attribute_type, foo.attribute_name;

Columns

View Definition

Possibly Referenced Tables/Views