quants

245 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('quants_id_seq'::regclass)
flow_quants.quant_id flow_quants_quant_id_fkey R
link_quants.quant_id link_quants_quant_id_fkey R
node_quants.quant_id node_quants_quant_id_fkey R
release_actor_node_quants.quant_id release_actor_node_quants_quant_id_fkey R
release_context_node_quants.quant_id release_node_quants_quant_id_fkey R
release_country_node_quants.quant_id release_country_node_quants_quant_id_fkey R
step_quants.quant_id step_quants_quant_id_fkey R
name text 2147483647 √ null
unit text 2147483647 √ null
country_id int4 10 √ null
nodes.id quants_country_id_fkey R
com_id int4 10 √ null
commodities.id quants_com_id_fkey R
description text 2147483647 √ null
indicator_type_id int4 10 √ null
indicator_types.id quants_indicator_type_id_fkey1 R

Indexes

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

Check Constraints

Constraint Name Constraint
name_must_be_uppercase ((upper(name) = name))
one_quant_unit_per_indicator_type ((unit_of_other_quants_with_indicator_type(id, indicator_type_id) = unit))
only_quants_with_indicator_type ( CASE WHEN (indicator_type_id IS NOT NULL) THEN ((number_quals_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