contexts

61 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('contexts_id_seq'::regclass)
release_context_node_inds.context_id release_node_inds_context_id_fkey R
release_context_node_quals.context_id release_node_quals_context_id_fkey R
release_context_node_quants.context_id release_node_quants_context_id_fkey R
country_id int8 19 √ null
nodes.id contexts_country_id_fkey R
com_id int4 10 √ null
commodities.id contexts_com_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
contexts_pkey Primary key Asc id
unique_country_commodity Must be unique Asc/Asc country_id + com_id

Check Constraints

Constraint Name Constraint
check_node_is_country ((get_node_level(country_id) = 1))
commodity_is_primary (commodity_is_primary(com_id))

Relationships

Close relationships within degrees of separation