flows_long

Columns

Column

Type

Size

Nulls

Auto

Default

Children

Parents

Comments

flow_id

int8

√

null

ref_id

int4

√

null

year

int4

√

null

position

int4

√

null

node_role

text

2147483647

√

null

node_name

text

2147483647

√

null

node_id

int8

√

null

node_trase_id

text

2147483647

√

null

indicator_name

text

2147483647

√

null

indicator_type

text

2147483647

√

null

numeric_value

float8

17,17

√

null

string_value

text

2147483647

√

null

Relationships

Close relationships within degrees of separation

View Definition

SELECT flows.id AS flow_id,
    flows.ref_id,
    (date_part('year'::text, flows.time_start))::integer AS year,
    NULL::integer AS "position",
    NULL::text AS node_role,
    NULL::text AS node_name,
    NULL::bigint AS node_id,
    NULL::text AS node_trase_id,
    'VOLUME'::text AS indicator_name,
    'VOLUME'::text AS indicator_type,
    flows.raw_vol AS numeric_value,
    NULL::text AS string_value
   FROM flows
UNION ALL
 SELECT flows.id AS flow_id,
    flows.ref_id,
    (date_part('year'::text, flows.time_start))::integer AS year,
    flow_paths."position",
    node_roles.role AS node_role,
    node_names.name AS node_name,
    flow_paths.node_id,
    nodes.trase_id AS node_trase_id,
    NULL::text AS indicator_name,
    NULL::text AS indicator_type,
    NULL::double precision AS numeric_value,
    NULL::text AS string_value
   FROM (((((flows
     JOIN flow_paths ON ((flow_paths.flow_id = flows.id)))
     LEFT JOIN node_names ON ((node_names.node_id = flow_paths.node_id)))
     JOIN nodes ON ((nodes.id = flow_paths.node_id)))
     JOIN reference_node_roles ON (((reference_node_roles.ref_id = flows.ref_id) AND (reference_node_roles."position" = flow_paths."position"))))
     JOIN node_roles ON ((reference_node_roles.node_role_id = node_roles.id)))
  WHERE COALESCE(node_names.is_default, true)
UNION ALL
 SELECT flows.id AS flow_id,
    flows.ref_id,
    (date_part('year'::text, flows.time_start))::integer AS year,
    NULL::integer AS "position",
    NULL::text AS node_role,
    NULL::text AS node_name,
    NULL::bigint AS node_id,
    NULL::text AS node_trase_id,
    quants.name AS indicator_name,
    indicator_types.indicator_type,
    flow_quants.value AS numeric_value,
    NULL::text AS string_value
   FROM (((flows
     JOIN flow_quants ON ((flow_quants.flow_id = flows.id)))
     JOIN quants ON ((flow_quants.quant_id = quants.id)))
     LEFT JOIN indicator_types ON ((quants.indicator_type_id = indicator_types.id)))
UNION ALL
 SELECT flows.id AS flow_id,
    flows.ref_id,
    (date_part('year'::text, flows.time_start))::integer AS year,
    NULL::integer AS "position",
    NULL::text AS node_role,
    NULL::text AS node_name,
    NULL::bigint AS node_id,
    NULL::text AS node_trase_id,
    quals.name AS indicator_name,
    indicator_types.indicator_type,
    NULL::double precision AS numeric_value,
    flow_quals.value AS string_value
   FROM (((flows
     JOIN flow_quals ON ((flow_quals.flow_id = flows.id)))
     JOIN quals ON ((flow_quals.qual_id = quals.id)))
     LEFT JOIN indicator_types ON ((quals.indicator_type_id = indicator_types.id)))
UNION ALL
 SELECT flows.id AS flow_id,
    flows.ref_id,
    (date_part('year'::text, flows.time_start))::integer AS year,
    NULL::integer AS "position",
    NULL::text AS node_role,
    NULL::text AS node_name,
    NULL::bigint AS node_id,
    NULL::text AS node_trase_id,
    inds.name AS indicator_name,
    indicator_types.indicator_type,
    flow_inds.value AS numeric_value,
    NULL::text AS string_value
   FROM (((flows
     JOIN flow_inds ON ((flow_inds.flow_id = flows.id)))
     JOIN inds ON ((flow_inds.ind_id = inds.id)))
     LEFT JOIN indicator_types ON ((inds.indicator_type_id = indicator_types.id)))
UNION ALL
 SELECT flows.id AS flow_id,
    flows.ref_id,
    (date_part('year'::text, flows.time_start))::integer AS year,
    NULL::integer AS "position",
    NULL::text AS node_role,
    NULL::text AS node_name,
    NULL::bigint AS node_id,
    NULL::text AS node_trase_id,
    'PRODUCT TYPE'::text AS indicator_name,
    NULL::text AS indicator_type,
    NULL::double precision AS numeric_value,
    commodity_names.name AS string_value
   FROM ((flows
     JOIN steps ON ((steps.flow_id = flows.id)))
     JOIN commodity_names USING (com_id))
  WHERE (commodity_names.is_default AND (steps."position" = 0));

Columns

Relationships

Close relationships within degrees of separation

View Definition

Possibly Referenced Tables/Views