refs


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('refs_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
flows.ref_id flows_ref_id_fkey R
link_inds.ref_id link_inds_ref_id_fkey R
link_quants.ref_id link_quants_ref_id_fkey R
links.ref_id links_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
ref_years.ref_id ref_id_fkey R
reference_node_roles.ref_id reference_node_roles_ref_id_fkey R
release_refs.ref_id release_refs_ref_id_fkey R
step_inds.ref_id step_inds_ref_id_fkey R
step_quals.ref_id step_quals_ref_id_fkey R
step_quants.ref_id step_quants_ref_id_fkey R
step_refs.ref_id step_refs_ref_id_fkey R
type ref_type 2147483647 √ null
title text 2147483647 √ null
description text 2147483647 √ null
country_id int8 19 √ null
nodes.id refs_country_id_fkey R
com_id int4 10 √ null
commodities.id refs_com_id_fkey R
quality_control_passed bool 1 √ null
version text 2147483647 √ null
latest bool 1 √ null

Table contained 312 rows

Indexes

Constraint Name Type Sort Column(s)
refs_pkey Primary key Asc id
unique_ref_title Must be unique Asc title

Relationships

Close relationships within degrees of separation