Table mimic.mimiciii.noteevents
Notes associated with hospital stays.

 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.
subject_id int4 10
patients.subject_id noteevents_fk_subject_id R
Foreign key. Identifies the patient.
hadm_id int4 10  √  null
admissions.hadm_id noteevents_fk_hadm_id R
Foreign key. Identifies the hospital stay.
chartdate timestamp 22  √  null Date when the note was charted.
charttime timestamp 22  √  null Date and time when the note was charted. Note that some notes (e.g. discharge summaries) do not have a time associated with them: these notes have NULL in this column.
storetime timestamp 22  √  null
category varchar 50  √  null Category of the note, e.g. Discharge summary.
description varchar 255  √  null A more detailed categorization for the note, sometimes entered by free-text.
cgid int4 10  √  null
caregivers.cgid noteevents_fk_cgid R
Foreign key. Identifies the caregiver.
iserror bpchar 1  √  null Flag to highlight an error with the note.
text text 2147483647  √  null Content of the note.

Table contained 2,083,180 rows at Thu Oct 12 12:29 EDT 2017

Indexes:
Column(s) Type Sort Constraint Name
row_id Primary key Asc noteevents_rowid_pk
subject_id Performance Asc noteevents_idx01
hadm_id Performance Asc noteevents_idx02
category Performance Asc noteevents_idx05

Close relationships  within of separation: