modelling_group


Description

With the self-referencing "current" field; we consider a modelling group to be the current one if current is null. This is not recursive; if we move a modelling group to a new id then every modelling group that has current pointing at the old id must be updated to point at the new one. This means that no current points at an id that does not have current as null.

Columns

Column Type Size Nulls Auto Default Children Parents Comments
id text 2147483647 null
model.modelling_group model_modelling_group_fkey R
modelling_group.replaced_by modelling_group_current_fkey R
responsibility_set.modelling_group responsibility_set_modelling_group_fkey R
institution text 2147483647 null
pi text 2147483647 null
description text 2147483647 null
comment text 2147483647 √ null
replaced_by text 2147483647 √ null
modelling_group.id modelling_group_current_fkey R

Table contained 0 rows

Indexes

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

Relationships

Close relationships within degrees of separation