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

Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
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
datetimeevents
inputevents_cv
inputevents_mv
noteevents
outputevents
procedureevents_mv
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
row_id Primary key Asc
cgid Must be unique Asc

Close relationships  within of separation: