nodes

2058959 rows


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
commodity_ratios.node_id commodity_ratios_node_id_fkey R
contexts.country_id contexts_country_id_fkey R
country_levels.country_id country_levels_country_id_fkey R
flow_paths.node_id flow_paths_node_id_fkey R
flows_references.country_id refs_country_id_fkey R
inds.country_id inds_country_id_fkey R
link_paths.node_id link_paths_node_id_fkey R
node_attributes_references.country_id node_attributes_references_country_id_fkey R
node_code_values.node_id node_code_values_node_id_fkey R
node_inds.node_id node_inds_node_id_fkey R
node_names.node_id node_names_node_id_fkey C
node_quals.node_id node_quals_node_id_fkey R
node_quants.node_id node_quants_node_id_fkey R
nodes.parent_id nodes_parent_id_fkey R
quals.country_id quals_country_id_fkey R
quants.country_id quants_country_id_fkey R
reference_group_traders.group_id reference_group_traders_group_id_fkey R
reference_group_traders.trader_id reference_group_traders_trader_id_fkey R
reference_trader_labels.label_id reference_trader_labels_label_id_fkey R
reference_trader_labels.trader_id reference_trader_labels_trader_id_fkey R
release_nodes.main_id main_id_fkey R
trader_groups.group_id trader_groups_group_id_fkey C
trader_groups.trader_id trader_groups_trader_id_fkey C
trader_labels.label_id trader_labels_label_id_fkey C
trader_labels.trader_id trader_labels_trader_id_fkey C
sp_points.node_id sp_points_node_id_fkey R
sp_regions.node_id sp_regions_node_id_fkey R
type_id int4 10 √ null
node_types.id nodes_type_id_fkey R
level int2 5 √ null
parent_id int8 19 √ null
nodes.id nodes_parent_id_fkey R
time_start timestamp 29,6 √ null
time_end timestamp 29,6 √ null
trase_id text 2147483647 √ null
sub_type_id int4 10 √ null
node_sub_types.id nodes_sub_type_id_fkey3 R

Indexes

Constraint Name Type Sort Column(s)
nodes_pkey Primary key Asc id
nodes_parent_id_idx Performance Asc parent_id
nodes_trase_id_idx Performance Asc trase_id
nodes_trase_id_time_start_time_end_idx Performance Asc/Asc/Asc trase_id + time_start + time_end
nodes_type_id_idx Performance Asc type_id

Check Constraints

Constraint Name Constraint
unique_trase_id ( CASE WHEN ((time_start IS NOT NULL) OR (time_end IS NOT NULL) OR (trase_id IS NULL)) THEN true ELSE (trase_id_already_exists(id, trase_id) = false) END)
sub_type_is_allowed ((get_sub_type_type_id((sub_type_id)::bigint) = type_id))
level_not_null_if_trader_node ((node_level_not_null_if_trader_node(id) = true))

Relationships

Close relationships within degrees of separation