commodities

102 rows


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
commodity_ratios.commodity_id commodity_ratios_com_id_fkey R
contexts.com_id contexts_com_id_fkey R
flows.raw_id flows_raw_id_fkey R
flows_references.com_id refs_com_id_fkey R
inds.com_id inds_com_id_fkey R
links.raw_id links_com_id_fkey R
node_attributes_references.commodity_id node_attributes_references_commodity_id_fkey R
quals.com_id quals_com_id_fkey R
quants.com_id quants_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

Indexes

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

Relationships

Close relationships within degrees of separation