Columns

Columns

Table Type Column Type Size Nulls Auto Default Comments
nodes Table time_start timestamp 29 √ null
node_quals Table time_end timestamp 29 √ null
release_actor_node_quals Table release_id int4 10 √ null
node_roles Table node_type_id int4 10 √ null
node_names Table name text 2147483647 √ null
datasets_com_eq_refs_view View ref_id int4 10 √ null
releases_view View context_id int4 10 √ null
equivalence_groups_view View location text 2147483647 √ null
metadata_datasets_view View commodity text 2147483647 √ null
steps Table com_id int4 10 √ null
nodes Table parent_id int8 19 √ null
metadata_datasets_view View country text 2147483647 √ null
equivalence_groups_view View parent_commodity_id int4 10 √ null
links Table link_type_id int4 10 √ null
nodes Table id bigserial 19 √ nextval('nodes_id_seq'::regclass)
releases_view View country_id int8 19 √ null
datasets_flow_quals_view View reference text 2147483647 √ null
equivalence_groups_view View com_eq_group_id int4 10 √ null
metadata_datasets_view View type text 2147483647 √ null
datasets_node_roles_view View title text 2147483647 √ null
datasets_view View year float8 17 √ null
release_node_inds Table context_id int4 10 √ null
cost_refs Table description text 2147483647 √ null
steps Table com_eq_factor_id int4 10 √ null
node_quants Table ref_id int4 10 √ null
ref_years Table ref_id int4 10 √ null
contexts Table com_id int4 10 √ null
step_inds Table value float8 17 null
refs Table latest bool 1 √ null
commodity_names Table is_default bool 1 √ null
commodity_code_values Table com_id int4 10 √ null
costs Table cost float8 17 √ null
releases_view View version text 2147483647 √ null
equivalence_groups_view View eq_factor float8 17 √ null
datasets_view View description text 2147483647 √ null
trader_countries Table country_id int8 19 √ null
equivalence_groups_view View commodity text 2147483647 √ null
equivalence_groups_view View eq_factor_id int4 10 √ null
commodity_names Table name text 2147483647 √ null
release_nodes Table name text 2147483647 √ null
datasets_view View raw_vol int8 19 √ null
flow_paths_view View title text 2147483647 √ null
cost_refs Table title text 2147483647 √ null
datasets_flow_quants_view View reference text 2147483647 √ null
releases_node_attributes_view View attribute_type text 2147483647 √ null
inds Table country_id int4 10 √ null
node_inds Table ref_id int4 10 √ null
links Table time_end timestamp 29 √ null
nodes Table ref_id int4 10 null
commodity_codes Table id serial 10 √ nextval('commodity_codes_id_seq'::regclass)
contexts Table id serial 10 √ nextval('contexts_id_seq'::regclass)
cost_refs Table id serial 10 √ nextval('cost_refs_id_seq'::regclass)
commodity_equivalence_groups Table title text 2147483647 √ null
inds Table scale text 2147483647 √ null
releases_view View flow_quals _text 2147483647 √ null
release_nodes Table geo_id text 2147483647 √ null
commodity_equivalence_factors Table node_id int8 19 √ null
step_quals Table qual_id int4 10 √ null
quants Table unit text 2147483647 √ null
datasets_flow_inds_view View ind_name text 2147483647 √ null
releases Table symbol text 2147483647 √ null
costs Table dest_id int8 19 √ null
datasets_com_eq_refs_view View com_eq_ref_id int4 10 √ null
releases Table description text 2147483647 √ null
refs Table quality_control_passed bool 1 √ null
releases_view View release_id int4 10 √ null
datasets_flow_quals_view View date_part float8 17 √ null
release_nodes Table main_id int8 19 √ null
quals Table country_id int4 10 √ null
flow_inds Table flow_id int8 19 √ null
commodity_names Table com_id int4 10 √ null
cost_refs Table country_id int8 19 √ null
datasets_flow_inds_view View ref_id int4 10 √ null
inds Table description text 2147483647 √ null
datasets_node_roles_view View ref_id int4 10 √ null
datasets_flow_quants_view View quant_sum float8 17 √ null
release_node_quants Table context_id int4 10 √ null
node_quants Table quant_id int4 10 √ null
release_node_inds Table release_id int4 10 √ null
link_quals Table value text 2147483647 null
flow_quants Table flow_id int8 19 √ null
metadata_datasets_view View raw_vol int8 19 √ null
commodities_view View commodity_name text 2147483647 √ null
node_inds Table node_id int8 19 √ null
step_quants Table value float8 17 null
inds Table id serial 10 √ nextval('inds_id_seq'::regclass)
releases_view View quality_control_passed bool 1 √ null
releases_view View columns _text 2147483647 √ null
refs Table title text 2147483647 √ null
datasets_flow_inds_view View reference text 2147483647 √ null
release_actor_node_inds Table release_id int4 10 √ null
release_actor_node_inds Table ind_id int4 10 √ null
releases_node_attributes_view View country text 2147483647 √ null
commodity_equivalence_refs Table title text 2147483647 √ null
release_actor_node_quants Table quant_id int4 10 √ null
steps Table time_end timestamp 29 √ null
commodity_equivalence_factors Table eq_factor float8 17 √ null
step_refs Table ref_id int4 10 √ null
release_refs Table ref_id int4 10 √ null
links Table ref_id int4 10 √ null
equivalence_groups_view View com_id int4 10 √ null
link_quants Table ref_id int4 10 √ null
release_node_quals Table release_id int4 10 √ null
link_paths Table node_id int8 19 √ null
commodity_codes Table regex text 2147483647 √ null
releases_view View com_id int4 10 √ null
node_inds Table ind_id int4 10 √ null
datasets_node_roles_view View role text 2147483647 √ null
link_types Table id serial 10 √ nextval('link_types_id_seq'::regclass)
node_code_values Table node_id int8 19 √ null
reference_node_roles Table position int4 10 √ null
attributes_view View attribute_type text 2147483647 √ null
link_quals Table ref_id int4 10 √ null
nodes Table type_id int4 10 √ null
flow_inds Table ref_id int4 10 √ null
commodity_equivalence_factors Table ref_id int4 10 √ null
refs Table com_id int4 10 √ null
flow_quals Table qual_id int4 10 √ null
country_levels Table id serial 10 √ nextval('country_levels_id_seq'::regclass)
flows Table time_end timestamp 29 √ null
equivalence_groups_view View node_id int8 19 √ null
node_quants Table value float8 17 null
link_quants Table link_id int8 19 √ null
datasets_flow_quants_view View date_part float8 17 √ null
node_types Table type text 2147483647 √ null
country_levels Table name text 2147483647 √ null
node_quals Table node_id int8 19 √ null
flows Table id bigserial 19 √ nextval('flows_id_seq'::regclass)
node_quals Table time_start timestamp 29 √ null
link_quants Table quant_id int4 10 √ null
node_inds Table value float8 17 null
nodes Table level int2 5 √ null
equivalence_groups_view View eq_group text 2147483647 √ null
nodes Table trase_id text 2147483647 √ null
node_inds Table time_end timestamp 29 √ null
commodity_equivalence_refs Table id serial 10 √ nextval('new_commodity_equivalence_refs_id_seq'::regclass)
quants Table description text 2147483647 √ null
flow_quals Table ref_id int4 10 √ null
hard_coded_tool_node_types Table id int4 10 √ null
node_quants Table time_end timestamp 29 √ null
release_node_inds Table ind_id int4 10 √ null
hard_coded_tool_node_types Table name text 2147483647 √ null
link_types Table link_type text 2147483647 √ null
release_refs Table release_id int4 10 √ null
release_nodes Table type_id int8 19 √ null
commodity_codes Table description text 2147483647 √ null
node_quals Table value text 2147483647 null
releases_view View title text 2147483647 √ null
link_types Table direction bool 1 √ null
releases_view View country text 2147483647 √ null
datasets_view View country text 2147483647 √ null
node_quals Table ref_id int4 10 √ null
quals Table id serial 10 √ nextval('quals_id_seq'::regclass)
country_node_attributes_view View attribute_type text 2147483647 √ null
commodity_equivalence_groups Table is_default bool 1 √ null
metadata_datasets_view View quality_control_passed bool 1 √ null
flow_paths_view View node_roles _text 2147483647 √ null
node_code_values Table time_end timestamp 29 √ null
flows Table com_eq_group_id int4 10 √ null
datasets_flow_quals_view View qual_name text 2147483647 √ null
refs Table id serial 10 √ nextval('refs_id_seq'::regclass)
flow_quals Table flow_id int8 19 √ null
commodity_equivalence_factors Table com_id int4 10 √ null
steps Table volume float8 17 √ null
quals Table description text 2147483647 √ null
node_code_values Table code_id int4 10 √ null
refs Table version text 2147483647 √ null
link_inds Table ref_id int4 10 √ null
flow_paths Table position int4 10 √ null
commodity_equivalence_groups Table description text 2147483647 √ null
trader_aggregates Table time_end timestamp 29 √ null
metadata_datasets_view View ref_id int4 10 √ null
datasets_view View type text 2147483647 √ null
link_inds Table ind_id int4 10 √ null
ref_years Table year int4 10 √ null
steps Table id bigserial 19 √ nextval('steps_id_seq'::regclass)
equivalence_groups_view View eq_factor_ref text 2147483647 √ null
releases_node_attributes_view View commodity text 2147483647 √ null
commodity_code_values Table value text 2147483647 √ null
flows Table raw_id int4 10 √ null
step_quants Table quant_id int4 10 √ null
release_nodes Table tool_id int8 19 √ null
flows Table raw_vol float8 17 √ null
releases_view View node_quants _text 2147483647 √ null
releases Table id serial 10 √ nextval('releases_id_seq'::regclass)
node_quants Table time_start timestamp 29 √ null
quants Table com_id int4 10 √ null
trader_aggregates Table aggregate_id int8 19 √ null
hard_coded_tool_node_types_mod Table id int4 10 √ null
nodes Table time_end timestamp 29 √ null
flow_quants Table ref_id int4 10 √ null
trader_labels Table trader_id int8 19 √ null
flows Table ref_id int4 10 √ null
link_types Table description text 2147483647 √ null
flow_inds Table ind_id int4 10 √ null
flow_quants Table value float8 17 null
datasets_com_eq_refs_view View ref_title text 2147483647 √ null
releases_node_attributes_view View context_id int4 10 √ null
flow_paths Table flow_id int8 19 √ null
node_names Table is_default bool 1 √ null
quants Table name text 2147483647 √ null
commodities_view View hs_codes _text 2147483647 √ null
release_node_quants Table release_id int4 10 √ null
nodes Table created_at timestamp 29 √ null
releases_view View flow_quants _text 2147483647 √ null
commodity_codes Table name text 2147483647 √ null
equivalence_groups_view View year_start float8 17 √ null
inds Table name text 2147483647 √ null
step_inds Table ind_id int4 10 √ null
releases_view View node_inds _text 2147483647 √ null
node_codes Table id serial 10 √ nextval('node_codes_id_seq'::regclass)
release_actor_node_quants Table release_id int4 10 √ null
releases_view View commodity text 2147483647 √ null
link_paths Table link_id int8 19 √ null
commodity_equivalence_factors Table time_end timestamp 29 √ null
node_codes Table name text 2147483647 √ null
releases Table current bool 1 √ null
quants Table id serial 10 √ nextval('quants_id_seq'::regclass)
trader_countries Table trader_id int8 19 √ null
commodities Table unit text 2147483647 √ null
refs Table type ref_type 2147483647 √ null
release_node_quants Table quant_id int4 10 √ null
node_roles Table id serial 10 √ nextval('node_roles_id_seq'::regclass)
trader_aggregates Table time_start timestamp 29 √ null
costs Table ref_id int4 10 √ null
step_quals Table value text 2147483647 null
links Table raw_id int4 10 √ null
country_levels Table country_id int8 19 √ null
step_refs Table step_id int8 19 √ null
release_actor_node_quals Table qual_id int4 10 √ null
datasets_view View commodity text 2147483647 √ null
step_quals Table step_id int8 19 √ null
commodity_equivalence_factors Table id serial 10 √ nextval('new_commodity_equivalence_factors_id_seq'::regclass)
link_paths Table position int4 10 √ null
country_node_attributes_view View attribute_id int4 10 √ null
node_names Table node_id int8 19 √ null
flow_quals Table value text 2147483647 null
flow_inds Table value float8 17 null
country_node_attributes_view View description text 2147483647 √ null
datasets_node_roles_view View node_role_id int4 10 √ null
commodities_view View com_id int4 10 √ null
links Table id bigserial 19 √ nextval('links_id_seq'::regclass)
trader_aggregates Table trader_id int8 19 √ null
country_node_attributes_view View attribute_name text 2147483647 √ null
datasets_view View ref_id int4 10 √ null
node_code_values Table value text 2147483647 √ null
link_inds Table link_id int8 19 √ null
metadata_datasets_view View description text 2147483647 √ null
datasets_flow_inds_view View date_part float8 17 √ null
commodity_equivalence_groups Table id serial 10 √ nextval('commodity_equivalence_group_refs_id_seq'::regclass)
releases_view View ref_id int4 10 √ null
steps Table time_start timestamp 29 √ null
releases_view View node_quals _text 2147483647 √ null
commodity_equivalence_refs Table description text 2147483647 √ null
flow_paths Table node_id int8 19 null
steps Table position int4 10 √ null
commodity_equivalence_group_factors Table com_eq_group_id int4 10 √ null
commodity_equivalence_factors Table time_start timestamp 29 √ null
datasets_flow_quals_view View ref_id int4 10 √ null
links Table time_start timestamp 29 √ null
quals Table com_id int4 10 √ null
equivalence_groups_view View eq_ref_id int4 10 √ null
release_node_quals Table qual_id int4 10 √ null
reference_node_roles Table ref_id int4 10 √ null
link_quals Table link_id int8 19 √ null
costs Table year int4 10 √ null
step_quals Table ref_id int4 10 √ null
inds Table com_id int4 10 √ null
node_quals Table qual_id int4 10 √ null
reference_node_roles Table node_role_id int4 10 √ null
steps Table flow_id int8 19 √ null
commodity_code_values Table com_code_id int4 10 √ null
datasets_view View total_vol int8 19 √ null
country_levels Table level int2 5 √ null
flow_quants Table quant_id int4 10 √ null
commodities Table id serial 10 √ nextval('commodities_id_seq'::regclass)
country_node_attributes_view View country_name text 2147483647 √ null
attributes_view View attribute_unit text 2147483647 √ null
datasets_flow_quants_view View quant_name text 2147483647 √ null
costs Table orig_id int8 19 √ null
datasets_node_roles_view View position int4 10 √ null
commodities Table parent_id int4 10 √ null
releases_view View flow_inds _text 2147483647 √ null
datasets_view View reference text 2147483647 √ null
node_inds Table time_start timestamp 29 √ null
step_quants Table ref_id int4 10 √ null
attributes_view View description text 2147483647 √ null
commodity_equivalence_group_factors Table com_eq_factor_id int4 10 √ null
link_quants Table value float8 17 null
refs Table country_id int8 19 √ null
releases_node_attributes_view View years _float8 17 √ null
trader_labels Table label_id int8 19 √ null
quants Table country_id int4 10 √ null
releases_node_attributes_view View attribute_name text 2147483647 √ null
datasets_flow_quants_view View ref_id int4 10 √ null
country_node_attributes_view View year int4 10 √ null
equivalence_groups_view View year_end float8 17 √ null
flow_paths_view View ref_id int4 10 √ null
hard_coded_tool_node_types_mod Table name text 2147483647 √ null
commodities_view View parent_commodity_name text 2147483647 √ null
node_codes Table description text 2147483647 √ null
step_inds Table ref_id int4 10 √ null
link_inds Table value float8 17 null
metadata_datasets_view View year float8 17 √ null
releases_view View years _float8 17 √ null
node_quants Table node_id int8 19 √ null
commodity_equivalence_groups Table com_id int4 10 √ null
equivalence_groups_view View parent_commodity text 2147483647 √ null
release_node_quals Table context_id int4 10 √ null
metadata_datasets_view View reference text 2147483647 √ null
node_types Table id serial 10 √ nextval('node_types_id_seq'::regclass)
node_code_values Table time_start timestamp 29 √ null
step_quants Table step_id int8 19 √ null
quals Table name text 2147483647 √ null
attributes_view View attribute_name text 2147483647 √ null
refs Table description text 2147483647 √ null
country_node_attributes_view View level_name text 2147483647 √ null
flows Table time_start timestamp 29 √ null
node_roles Table role text 2147483647 √ null
step_inds Table step_id int8 19 √ null
contexts Table country_id int8 19 √ null
releases_node_attributes_view View release_id int4 10 √ null
node_codes Table regex text 2147483647 √ null
link_quals Table qual_id int4 10 √ null
datasets_com_eq_refs_view View com_eq_ref_group_title text 2147483647 √ null