metadata_datasets_view

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

type

text

2147483647

√

null

ref_id

int4

√

null

reference

text

2147483647

√

null

description

text

2147483647

√

null

country

text

2147483647

√

null

commodity

text

2147483647

√

null

raw_vol

int8

√

null

year

float8

17,17

√

null

quality_control_passed

bool

√

null

Table contained 0 rows

View Definition

SELECT foo.type,
    foo.ref_id,
    foo.reference,
    foo.description,
    foo.country,
    get_com_name(foo.parent_id) AS commodity,
    foo.raw_vol,
    foo.year,
    foo.quality_control_passed
   FROM ( SELECT (refs.type)::text AS type,
            refs.id AS ref_id,
            refs.title AS reference,
            refs.description,
            node_names.name AS country,
            get_com_parent(flows.raw_id) AS parent_id,
            (sum(flows.raw_vol))::bigint AS raw_vol,
            date_part('year'::text, flows.time_start) AS year,
            refs.quality_control_passed
           FROM ((((refs
             JOIN nodes ON ((refs.country_id = nodes.id)))
             JOIN node_names ON ((nodes.id = node_names.node_id)))
             FULL JOIN flows ON ((flows.ref_id = refs.id)))
             JOIN commodity_names ON ((nodes.parent_id = commodity_names.com_id)))
          WHERE ((refs.type <> 'OTHER'::ref_type) AND node_names.is_default AND commodity_names.is_default)
          GROUP BY refs.type, refs.id, refs.title, refs.description, node_names.name, flows.raw_id, (date_part('year'::text, flows.time_start))) foo;

Columns

View Definition

Possibly Referenced Tables/Views