Table mimic.mimiciii.caregivers
List of caregivers associated with an ICU stay.

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
row_id int4 10 Unique row identifier.
cgid int4 10
chartevents.cgid chartevents_fk_cgid R
datetimeevents.cgid datetimeevents_fk_cgid R
inputevents_cv.cgid inputevents_cv_fk_cgid R
inputevents_mv.cgid inputevents_mv_fk_cgid R
noteevents.cgid noteevents_fk_cgid R
outputevents.cgid outputevents_fk_cgid R
procedureevents_mv.cgid procedureevents_mv_fk_cgid R
Unique caregiver identifier.
label varchar 15  √  null Title of the caregiver, for example MD or RN.
description varchar 30  √  null More detailed description of the caregiver, if available.

Table contained 7,567 rows at Thu Oct 12 12:29 EDT 2017

Indexes:
Column(s) Type Sort Constraint Name
row_id Primary key Asc cg_rowid_pk
cgid Must be unique Asc cg_cgid_unique

Close relationships  within of separation: