TABLES
57
VIEWS
14
COLUMNS
325
Constraints
109
Anomalies
7
Routines
0
Database Properties
Database Type: PostgreSQL - 10.10 (Ubuntu 10.10-1.pgdg18.04+1)
Schema public
standard public schema
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| node_roles | 1 | 1 | 3 | 33 | Table | |
| releases | 7 | 0 | 4 | 10 | Table | |
| step_inds | 0 | 3 | 4 | 0 | Table | |
| node_inds | 0 | 3 | 6 | 0 | Table | |
| flow_inds | 0 | 3 | 4 | 0 | Table | |
| trader_labels | 0 | 2 | 2 | 0 | Table | |
| step_quals | 0 | 4 | 4 | 0 | Table | |
| link_types | 1 | 0 | 4 | 11 | Table | |
| quants | 6 | 2 | 6 | 111 | Table | |
| flows | 5 | 3 | 7 | 0 | Table | |
| commodity_equivalence_refs | 1 | 0 | 3 | 9 | Table | |
| link_inds | 0 | 3 | 4 | 0 | Table | |
| node_types | 2 | 0 | 2 | 5 | Table | |
| trader_aggregates | 0 | 2 | 4 | 0 | Table | |
| release_refs | 0 | 2 | 2 | 124 | Table | |
| release_node_quals | 0 | 3 | 3 | 20 | Table | |
| flow_quants | 0 | 3 | 4 | 0 | Table | |
| cost_refs | 1 | 1 | 4 | 2 | Table | |
| hard_coded_tool_node_types_mod | 0 | 0 | 2 | 0 | Table | |
| commodity_names | 0 | 1 | 3 | 124 | Table | |
| release_node_inds | 0 | 3 | 3 | 107 | Table | |
| reference_node_roles | 0 | 2 | 3 | 453 | Table | |
| flow_paths | 0 | 2 | 3 | 0 | Table | |
| release_node_quants | 0 | 3 | 3 | 206 | Table | |
| steps | 5 | 3 | 8 | 0 | Table | |
| release_nodes | 0 | 1 | 5 | 0 | Table | |
| commodity_equivalence_factors | 2 | 3 | 7 | 750 | Table | |
| node_quants | 0 | 3 | 6 | 0 | Table | |
| link_quals | 0 | 3 | 4 | 0 | Table | |
| node_codes | 1 | 0 | 4 | 31 | Table | |
| links | 4 | 3 | 6 | 0 | Table | |
| flow_quals | 0 | 3 | 4 | 0 | Table | |
| node_names | 0 | 1 | 3 | 24146 | Table | |
| link_paths | 0 | 2 | 3 | 0 | Table | |
| commodity_equivalence_group_factors | 0 | 2 | 2 | 749 | Table | |
| release_actor_node_inds | 0 | 2 | 2 | 14 | Table | |
| commodity_equivalence_groups | 2 | 1 | 5 | 20 | Table | |
| inds | 6 | 2 | 6 | 51 | Table | |
| step_refs | 0 | 2 | 2 | 0 | Table | |
| ref_years | 0 | 1 | 2 | 0 | Table | |
| country_levels | 0 | 1 | 4 | 0 | Table | |
| nodes | 25 | 1 | 9 | 16331 | Table | |
| commodity_code_values | 0 | 2 | 3 | 393 | Table | |
| refs | 17 | 2 | 9 | 312 | Table | |
| step_quants | 0 | 3 | 4 | 0 | Table | |
| link_quants | 0 | 3 | 4 | 0 | Table | |
| release_actor_node_quals | 0 | 2 | 2 | 14 | Table | |
| node_code_values | 0 | 2 | 5 | 19566 | Table | |
| contexts | 3 | 2 | 3 | 58 | Table | |
| node_quals | 0 | 3 | 6 | 0 | Table | |
| costs | 0 | 3 | 5 | 0 | Table | |
| commodity_codes | 1 | 0 | 4 | 5 | Table | |
| quals | 6 | 2 | 5 | 56 | Table | |
| commodities | 13 | 1 | 3 | 87 | Table | |
| hard_coded_tool_node_types | 0 | 0 | 2 | 0 | Table | |
| release_actor_node_quants | 0 | 2 | 2 | 0 | Table | |
| trader_countries | 0 | 2 | 2 | 0 | Table | |
| datasets_view | 0 | 0 | 9 | 0 | View | |
| metadata_datasets_view | 0 | 0 | 9 | 0 | View | |
| datasets_com_eq_refs_view | 0 | 0 | 4 | 0 | View | |
| releases_view | 0 | 0 | 18 | 0 | View | |
| equivalence_groups_view | 0 | 0 | 14 | 0 | View | |
| datasets_flow_inds_view | 0 | 0 | 4 | 0 | View | |
| commodities_view | 0 | 0 | 4 | 0 | View | |
| datasets_flow_quals_view | 0 | 0 | 4 | 0 | View | |
| datasets_flow_quants_view | 0 | 0 | 5 | 0 | View | |
| flow_paths_view | 0 | 0 | 3 | 0 | View | |
| country_node_attributes_view | 0 | 0 | 7 | 0 | View | |
| datasets_node_roles_view | 0 | 0 | 5 | 0 | View | |
| attributes_view | 0 | 0 | 4 | 0 | View | |
| releases_node_attributes_view | 0 | 0 | 7 | 0 | View |