TABLES
61
VIEWS
1
COLUMNS
280
Constraints
140
Anomalies
7
Routines
0
Database Properties
Database Type: PostgreSQL - 12.11
Tables
| Table / View | Children | Parents | Columns | Rows | Type | Comments |
|---|---|---|---|---|---|---|
| node_roles | 2 | 2 | 5 | 54 | Table | |
| releases | 11 | 0 | 6 | 31 | Table | |
| step_inds | 0 | 2 | 3 | 0 | Table | |
| node_inds | 0 | 3 | 7 | 3598799 | Table | |
| flow_inds | 0 | 3 | 4 | 42294656 | Table | |
| trader_labels | 0 | 2 | 2 | 1082795 | Table | |
| step_quals | 0 | 3 | 3 | 0 | Table | |
| release_flows_references | 0 | 2 | 3 | 764 | Table | |
| quants | 7 | 4 | 7 | 245 | Table | |
| release_context_node_quals | 0 | 4 | 4 | 445 | Table | |
| flows | 5 | 3 | 7 | 57028160 | Table | |
| release_country_node_quals | 0 | 3 | 3 | 28 | Table | |
| commodity_equivalence_refs | 1 | 0 | 3 | 16 | Table | |
| link_inds | 0 | 2 | 3 | 0 | Table | |
| node_types | 3 | 0 | 2 | 7 | Table | |
| release_country_node_inds | 0 | 3 | 3 | 88 | Table | |
| links_references | 3 | 1 | 11 | 36 | Table | |
| flow_quants | 0 | 3 | 4 | 182197808 | Table | |
| node_sub_types | 5 | 1 | 3 | 29 | Table | |
| commodity_names | 0 | 1 | 3 | 148 | Table | |
| indicator_types | 6 | 0 | 2 | 25 | Table | |
| reference_node_roles | 0 | 2 | 3 | 3383 | Table | Roles of nodes in flow datasets paths |
| flow_paths | 0 | 2 | 3 | 605685504 | Table | |
| reference_trader_labels | 0 | 3 | 3 | 469877 | Table | |
| release_nodes | 0 | 1 | 5 | 0 | Table | |
| steps | 4 | 3 | 8 | 549045060 | Table | |
| commodity_equivalence_factors | 2 | 3 | 7 | 181 | Table | |
| node_quants | 0 | 3 | 7 | 8856068 | Table | |
| link_quals | 0 | 2 | 3 | 64273 | Table | |
| node_codes | 1 | 0 | 3 | 43 | Table | |
| links | 4 | 2 | 5 | 63163 | Table | |
| flow_quals | 0 | 3 | 4 | 229398960 | Table | |
| node_names | 0 | 1 | 4 | 2021680 | Table | |
| link_paths | 0 | 2 | 3 | 181166 | Table | |
| flows_references | 7 | 5 | 13 | 445 | Table | Dataset references |
| commodity_equivalence_group_factors | 0 | 2 | 2 | 194 | Table | |
| release_actor_node_inds | 0 | 3 | 3 | 96 | Table | |
| commodity_equivalence_groups | 4 | 1 | 5 | 32 | Table | |
| inds | 7 | 4 | 7 | 89 | Table | |
| release_context_node_quants | 0 | 4 | 4 | 3020 | Table | |
| country_levels | 0 | 1 | 4 | 21 | Table | |
| nodes | 28 | 6 | 8 | 2058959 | Table | |
| release_country_node_quants | 0 | 3 | 3 | 413 | Table | |
| rejected_name_matches | 0 | 0 | 3 | 2494 | Table | |
| commodity_code_values | 0 | 2 | 3 | 256 | Table | |
| commodity_ratios | 0 | 3 | 7 | 9 | Table | |
| step_quants | 0 | 2 | 3 | 0 | Table | |
| link_quants | 0 | 2 | 3 | 10882 | Table | |
| reference_group_traders | 0 | 3 | 3 | 199283 | Table | |
| release_actor_node_quals | 0 | 3 | 3 | 260 | Table | |
| links_reference_node_roles | 0 | 2 | 3 | 93 | Table | |
| node_code_values | 0 | 2 | 3 | 48884 | Table | |
| release_context_node_inds | 0 | 4 | 4 | 1593 | Table | |
| trader_groups | 0 | 2 | 5 | 532108 | Table | |
| contexts | 3 | 2 | 3 | 61 | Table | |
| node_quals | 0 | 3 | 7 | 278730 | Table | |
| node_attributes_references | 17 | 4 | 12 | 109 | Table | |
| commodity_codes | 1 | 0 | 3 | 7 | Table | |
| quals | 7 | 4 | 6 | 68 | Table | |
| commodities | 15 | 1 | 3 | 102 | Table | |
| release_actor_node_quants | 0 | 3 | 3 | 0 | Table | |
| node_parents | 0 | 0 | 8 | 0 | View |