commodity_equivalence_group_factors

194 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
com_eq_group_id int4 10 √ null
commodity_equivalence_groups.id commodity_equivalence_group_factors_com_eq_group_ref_id_fkey R
com_eq_factor_id int4 10 √ null
commodity_equivalence_factors.id commodity_equivalence_group_factors_com_eq_factor_id_fkey R

Indexes

Constraint Name Type Sort Column(s)
commodity_equivalence_group_f_com_eq_group_ref_id_com_eq_fa_idx Must be unique Asc/Asc com_eq_group_id + com_eq_factor_id

Check Constraints

Constraint Name Constraint
unique_com_factor_per_group ((commodity_equivalence_group_already_has_com_factor(com_eq_group_id, com_eq_factor_id) = false))

Relationships

Close relationships within degrees of separation