montagu Database

Columns

Related columns Constraint Comments

Search:

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

Showing 1 to 5 of 5 entries

Table contained 0 rows

Indexes

Search:

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

Showing 1 to 2 of 2 entries

Relationships

Close relationships within degrees of separation

One
Two degrees