impact_estimate_recipe


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id serial 10 √ nextval('impact_estimate_recipe_id_seq'::regclass)
impact_estimate_ingredient.impact_estimate_recipe impact_estimate_ingredient_impact_estimate_recipe_fkey R
impact_estimate_set.impact_estimate_recipe impact_estimate_set_impact_estimate_recipe_fkey R
version int4 10 null
responsibility_set int4 10 null
responsibility_set.id impact_estimate_recipe_responsibility_set_fkey R
name text 2147483647 null
script text 2147483647 null
comment text 2147483647 √ null
impact_outcome text 2147483647 null
impact_outcome.id impact_estimate_recipe_impact_outcome_fkey R
activity_type text 2147483647 null
activity_type.id impact_estimate_recipe_activity_type_fkey R
support_type text 2147483647 null
support_type.id impact_estimate_recipe_support_type_fkey R
disease text 2147483647 null
disease.id impact_estimate_recipe_disease_fkey R
vaccine text 2147483647 null
vaccine.id impact_estimate_recipe_vaccine_fkey R
focal_ingredient int4 10 √ null
impact_estimate_ingredient.id impact_estimate_recipe_focal_ingredient_fkey R
current_impact_estimate_set int4 10 √ null
impact_estimate_set.id impact_estimate_recipe_current_impact_estimate_set_fkey R

Table contained 0 rows

Indexes

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

Relationships

Close relationships within degrees of separation