commodity_equivalence_groups

32 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('commodity_equivalence_group_refs_id_seq'::regclass)
commodity_equivalence_group_factors.com_eq_group_id commodity_equivalence_group_factors_com_eq_group_ref_id_fkey R
commodity_ratios.commodity_equivalence_group_id commodity_ratios_commodity_equivalence_group_id_fkey R
flows.com_eq_group_id flows_com_eq_group_ref_id_fkey R
flows_references.commodity_equivalence_group_id refs_commodity_equivalence_group_id_fkey R
description text 2147483647 √ null
com_id int4 10 √ null
commodities.id commodity_equivalence_groups_com_id_fkey R
is_default bool 1 √ null
name text 2147483647 null

Indexes

Constraint Name Type Sort Column(s)
commodity_equivalence_group_refs_pkey Primary key Asc id
commodity_equivalence_groups_name_idx Must be unique Asc name
commodity_equivalence_groups_name_idx1 Must be unique Asc name

Relationships

Close relationships within degrees of separation