nodes


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id bigserial 19 √ nextval('nodes_id_seq'::regclass)
commodity_equivalence_factors.node_id new_commodity_equivalence_factors_node_id_fkey R
contexts.country_id contexts_country_id_fkey R
cost_refs.country_id cost_refs_country_id_fkey R
costs.dest_id costs_dest_id_fkey R
costs.orig_id costs_orig_id_fkey R
country_levels.country_id country_levels_country_id_fkey R
flow_paths.node_id flow_paths_node_id_fkey R
inds.country_id inds_country_id_fkey R
link_paths.node_id link_paths_node_id_fkey R
link_quals.ref_id link_quals_ref_id_fkey R
node_code_values.node_id node_id_fkey R
node_inds.node_id node_inds_node_id_fkey R
node_names.node_id node_id_fkey R
node_quals.node_id node_quals_node_id_fkey R
node_quants.node_id node_quants_node_id_fkey R
quals.country_id quals_country_id_fkey R
quants.country_id quants_country_id_fkey R
refs.country_id refs_country_id_fkey R
release_nodes.main_id main_id_fkey R
trader_aggregates.aggregate_id trader_aggregates_aggregate_id_fkey C
trader_aggregates.trader_id trader_aggregates_trader_id_fkey C
trader_countries.country_id trader_countries_country_id_fkey R
trader_countries.trader_id trader_countries_trader_id_fkey C
trader_labels.label_id trader_labels_label_id_fkey C
trader_labels.trader_id trader_labels_trader_id_fkey C
type_id int4 10 √ null
node_types.id nodes_type_id_fkey R
level int2 5 √ null
parent_id int8 19 √ null
time_start timestamp 29,6 √ null
time_end timestamp 29,6 √ null
ref_id int4 10 null
trase_id text 2147483647 √ null
created_at timestamp 29,6 √ null

Table contained 16331 rows

Indexes

Constraint Name Type Sort Column(s)
nodes_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation