inds

89 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('inds_id_seq'::regclass)
flow_inds.ind_id flow_inds_ind_id_fkey R
link_inds.ind_id link_inds_ind_id_fkey R
node_inds.ind_id node_inds_ind_id_fkey R
release_actor_node_inds.ind_id release_actor_node_inds_ind_id_fkey R
release_context_node_inds.ind_id release_node_inds_ind_id_fkey R
release_country_node_inds.ind_id release_country_node_inds_ind_id_fkey R
step_inds.ind_id step_inds_ind_id_fkey R
name text 2147483647 √ null
scale text 2147483647 √ null
country_id int4 10 √ null
nodes.id inds_country_id_fkey R
com_id int4 10 √ null
commodities.id inds_com_id_fkey R
description text 2147483647 √ null
indicator_type_id int4 10 √ null
indicator_types.id inds_indicator_type_id_fkey1 R

Indexes

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

Check Constraints

Constraint Name Constraint
name_must_be_uppercase ((upper(name) = name))
one_ind_scale_per_indicator_type ((scale_of_other_inds_with_indicator_type(id, indicator_type_id) = scale))
only_inds_with_indicator_type ( CASE WHEN (indicator_type_id IS NOT NULL) THEN ((number_quals_with_indicator_type(indicator_type_id) = 0) AND (number_quants_with_indicator_type(indicator_type_id) = 0)) ELSE true END)

Relationships

Close relationships within degrees of separation