quals

68 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('quals_id_seq'::regclass)
flow_quals.qual_id flow_quals_qual_id_fkey R
link_quals.qual_id link_quals_qual_id_fkey R
node_quals.qual_id node_quals_qual_id_fkey R
release_actor_node_quals.qual_id release_actor_node_quals_qual_id_fkey R
release_context_node_quals.qual_id release_node_quals_qual_id_fkey R
release_country_node_quals.qual_id release_country_node_quals_qual_id_fkey R
step_quals.qual_id step_quals_qual_id_fkey R
name text 2147483647 √ null
country_id int4 10 √ null
nodes.id quals_country_id_fkey R
com_id int4 10 √ null
commodities.id quals_com_id_fkey R
description text 2147483647 √ null
indicator_type_id int4 10 √ null
indicator_types.id quals_indicator_type_id_fkey1 R

Indexes

Constraint Name Type Sort Column(s)
quals_pkey Primary key Asc id
unique_qual_name Must be unique Asc name

Check Constraints

Constraint Name Constraint
name_must_be_uppercase ((upper(name) = name))
only_quals_with_indicator_type ( CASE WHEN (indicator_type_id IS NOT NULL) THEN ((number_quants_with_indicator_type(indicator_type_id) = 0) AND (number_inds_with_indicator_type(indicator_type_id) = 0)) ELSE true END)

Relationships

Close relationships within degrees of separation