commodities


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('commodities_id_seq'::regclass)
commodities.parent_id commodities_parent_id_fkey R
commodity_code_values.com_id commodity_code_values_com_id_fkey R
commodity_equivalence_factors.com_id new_commodity_equivalence_factors_com_id_fkey R
commodity_equivalence_groups.com_id commodity_equivalence_groups_com_id_fkey R
commodity_names.com_id commodity_names_com_id_fkey R
contexts.com_id contexts_com_id_fkey R
flows.raw_id flows_raw_id_fkey R
inds.com_id inds_com_id_fkey R
links.raw_id links_com_id_fkey R
quals.com_id quals_com_id_fkey R
quants.com_id quants_com_id_fkey R
refs.com_id refs_com_id_fkey R
steps.com_id steps_com_id_fkey R
parent_id int4 10 √ null
commodities.id commodities_parent_id_fkey R
unit text 2147483647 √ null

Table contained 87 rows

Indexes

Constraint Name Type Sort Column(s)
commodities_pkey Primary key Asc id

Relationships

Close relationships within degrees of separation