impact_estimate_ingredient


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('impact_estimate_ingredient_id_seq'::regclass)
impact_estimate_recipe.focal_ingredient impact_estimate_recipe_focal_ingredient_fkey R
impact_estimate_set_ingredient.impact_estimate_ingredient impact_estimate_set_ingredient_impact_estimate_ingredient_fkey R
impact_estimate_recipe int4 10 null
impact_estimate_recipe.id impact_estimate_ingredient_impact_estimate_recipe_fkey R
responsibility int4 10 null
responsibility.id impact_estimate_ingredient_responsibility_fkey R
burden_outcome int2 5 null
burden_outcome.id impact_estimate_ingredient_burden_outcome_fkey R
name text 2147483647 null

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
impact_estimate_ingredient_pkey Primary key Asc id
impact_estimate_ingredient_responsibility_impact_estimate_r_key Must be unique Asc/Asc/Asc/Asc responsibility + impact_estimate_recipe + burden_outcome + name

Relationships

Close relationships within degrees of separation