node_attributes_references

109 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('node_attributes_references_id_seq'::regclass)
flow_inds.ref_id flow_inds_ref_id_fkey R
flow_quals.ref_id flow_quals_ref_id_fkey R
flow_quants.ref_id flow_quants_ref_id_fkey R
node_attributes_references.other_parent_ref_id node_attributes_references_other_parent_ref_id_fkey R
node_attributes_references.parent_ref_id node_attributes_references_parent_ref_id_fkey R
node_inds.ref_id node_inds_ref_id_fkey R
node_quals.ref_id node_quals_ref_id_fkey R
node_quants.ref_id node_quants_ref_id_fkey R
release_actor_node_inds.ref_id release_actor_node_inds_ref_id_fkey R
release_actor_node_quals.ref_id release_actor_node_quals_ref_id_fkey R
release_actor_node_quants.ref_id release_actor_node_quants_ref_id_fkey R
release_context_node_inds.ref_id release_context_node_inds_ref_id_fkey R
release_context_node_quals.ref_id release_context_node_quals_ref_id_fkey R
release_context_node_quants.ref_id release_context_node_quants_ref_id_fkey R
release_country_node_inds.ref_id release_country_node_inds_ref_id_fkey R
release_country_node_quals.ref_id release_country_node_quals_ref_id_fkey R
release_country_node_quants.ref_id release_country_node_quants_ref_id_fkey R
country_id int8 19 √ null
nodes.id node_attributes_references_country_id_fkey R
commodity_id int4 10 √ null
commodities.id node_attributes_references_commodity_id_fkey R
latest bool 1 √ null
updated timestamptz 35,6 √ null
version text 2147483647 √ null
version_type version_type 2147483647 √ null
suffix text 2147483647 √ ''::text
title text 2147483647 √ get_node_attributes_generated_title(country_id, commodity_id, version, version_type, suffix)
parent_ref_id int4 10 √ null
node_attributes_references.id node_attributes_references_parent_ref_id_fkey R
old_title text 2147483647 √ null
other_parent_ref_id int4 10 √ null
node_attributes_references.id node_attributes_references_other_parent_ref_id_fkey R

Indexes

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

Check Constraints

Constraint Name Constraint
commodity_is_primary (commodity_is_primary(com_id))

Relationships

Close relationships within degrees of separation