model


Description

With the self-referencing "current" field; we consider a model to be the current one if current is null. See comment about recursion in modelling_group

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id text 2147483647 null
gavi_focal_model.model gavi_focal_model_model_fkey R
model_version.model model_version_model_fkey R
modelling_group text 2147483647 'NULL'::text
modelling_group.id model_modelling_group_fkey R
description text 2147483647 null
citation text 2147483647 √ null
is_current bool 1 false
current_version int4 10 √ null
model_version.id model_current_version_fkey R
disease text 2147483647 √ null
disease.id model_disease_fkey R
gender_specific bool 1 √ false
gender int4 10 √ null
gender.id model_gender_fkey R

Table contained 0 rows

Indexes

Constraint Name Type Sort Column(s)
model_pkey Primary key Asc id
modelling_group_disease_unique_when_current Must be unique Asc/Asc modelling_group + disease

Relationships

Close relationships within degrees of separation