SchemaSpy Analysis of eicu.eicu_crd - Columns Generated by
SchemaSpy
Generated by SchemaSpy on Thu Aug 08 18:15 EDT 2019
Legend: SourceForge.net
Primary key columns
Columns with indexes
 

eicu.eicu_crd contains 391 columns - click on heading to sort:
Table Column Type Size Nulls Auto Default Comments
apachepredvar activetx int2 5  √  null
careplancareprovider activeupondischarge varchar 10
careplaneol activeupondischarge varchar 10  √  null
careplangeneral activeupondischarge varchar 10
careplangoal activeupondischarge varchar 10
careplaninfectiousdisease activeupondischarge varchar 10
diagnosis activeupondischarge varchar 64  √  null
treatment activeupondischarge varchar 10  √  null
apachepatientresult actualhospitallos float8 17,17  √  null
apachepatientresult actualhospitalmortality varchar 50  √  null
apachepatientresult actualiculos float8 17,17  √  null
apachepatientresult actualicumortality varchar 50  √  null
apachepatientresult actualventdays float8 17,17  √  null
apachepatientresult acutephysiologyscore int4 10  √  null
admissiondrug admissiondrugid int4 10
admissiondx admissiondxid int4 10
patient admissionheight numeric 10,2  √  null
patient admissionweight numeric 10,2  √  null
apachepredvar admitdiagnosis varchar 11  √  null
admissiondx admitdxenteredoffset int4 10
admissiondx admitdxname varchar 255  √  null
admissiondx admitdxpath varchar 500
admissiondx admitdxtext varchar 255  √  null
apachepredvar admitsource int2 5  √  null
apachepredvar age int2 5  √  null
patient age varchar 10  √  null
apachepredvar aids int2 5  √  null
respiratorycare airwayposition varchar 32  √  null
respiratorycare airwaysize varchar 10  √  null
respiratorycare airwaytype varchar 30  √  null
apacheapsvar albumin float8 17,17  √  null
allergy allergyenteredoffset int4 10
allergy allergyid int4 10
allergy allergyname varchar 255  √  null
allergy allergynotetype varchar 255  √  null
allergy allergyoffset int4 10
allergy allergytype varchar 255  √  null
apachepredvar amilocation int2 5  √  null
microlab antibiotic varchar 255  √  null
patient apacheadmissiondx varchar 1000  √  null
apacheapsvar apacheapsvarid int4 10  √  null
apachepatientresult apachepatientresultsid int4 10
apachepredvar apachepredvarid int4 10  √  null
apachepatientresult apachescore int4 10  √  null
apachepatientresult apacheversion varchar 5
respiratorycare apneaparams varchar 80  √  null
apachepredvar bedcount int2 5  √  null
apacheapsvar bilirubin float8 17,17  √  null
apacheapsvar bun float8 17,17  √  null
vitalaperiodic cardiacinput float8 17,17  √  null
vitalaperiodic cardiacoutput float8 17,17  √  null
careplancareprovider careprovidersaveoffset int4 10
nurseassessment cellattribute varchar 255
nursecare cellattribute varchar 255
nurseassessment cellattributepath varchar 255
nursecare cellattributepath varchar 255
nurseassessment cellattributevalue varchar 4000  √  null
nursecare cellattributevalue varchar 4000  √  null
intakeoutput celllabel varchar 255  √  null
nurseassessment celllabel varchar 255
nursecare celllabel varchar 255
intakeoutput cellpath varchar 500  √  null
intakeoutput cellvaluenumeric numeric 12,4
intakeoutput cellvaluetext varchar 255
apachepredvar cirrhosis int2 5  √  null
respiratorycare cpaplimit numeric 11,4  √  null
careplancareprovider cplcareprovderid int4 10
careplaneol cpleoldiscussionoffset int4 10  √  null
careplaneol cpleolid int4 10
careplaneol cpleolsaveoffset int4 10
careplangeneral cplgeneralid int4 10
careplangoal cplgoalcategory varchar 255  √  null
careplangoal cplgoalid int4 10
careplangoal cplgoaloffset int4 10
careplangoal cplgoalstatus varchar 255  √  null
careplangoal cplgoalvalue varchar 1000  √  null
careplangeneral cplgroup varchar 255
careplaninfectiousdisease cplinfectdiseaseoffset int4 10
careplaninfectiousdisease cplinfectid int4 10
careplangeneral cplitemoffset int4 10
careplangeneral cplitemvalue varchar 1024  √  null
apacheapsvar creatinine float8 17,17  √  null
apachepredvar creatinine float8 17,17  √  null
respiratorycare cuffpressure numeric 5,1  √  null
microlab culturesite varchar 255
microlab culturetakenoffset int4 10
respiratorycare currenthistoryseqnum int4 10  √  null
customlab customlabid int4 10
vitalperiodic cvp int4 10  √  null
apachepredvar day1eyes int2 5  √  null
apachepredvar day1fio2 float8 17,17  √  null
apachepredvar day1meds int2 5  √  null
apachepredvar day1motor int2 5  √  null
apachepredvar day1pao2 float8 17,17  √  null
apachepredvar day1verbal int2 5  √  null
apachepredvar diabetes int2 5  √  null
diagnosis diagnosisid int4 10
diagnosis diagnosisoffset int4 10
diagnosis diagnosispriority varchar 10
diagnosis diagnosisstring varchar 200
apacheapsvar dialysis int2 5  √  null
intakeoutput dialysistotal numeric 12,4  √  null
apachepredvar diedinhospital int2 5  √  null
apachepredvar dischargelocation int2 5  √  null
patient dischargeweight numeric 10,2  √  null
medication dosage varchar 60  √  null
admissiondrug drugadmitfrequency varchar 1000
infusiondrug drugamount varchar 255  √  null
admissiondrug drugdosage numeric 11,4  √  null
admissiondrug drugenteredoffset int4 10
admissiondrug drughiclseqno int4 10  √  null
allergy drughiclseqno int4 10  √  null
medication drughiclseqno int4 10  √  null
medication drugivadmixture varchar 6
admissiondrug drugname varchar 255
allergy drugname varchar 255
infusiondrug drugname varchar 255
medication drugname varchar 220  √  null
admissiondrug drugnotetype varchar 255  √  null
admissiondrug drugoffset int4 10
medication drugordercancelled varchar 6
medication drugorderoffset int4 10
infusiondrug drugrate varchar 255  √  null
medication drugstartoffset int4 10
medication drugstopoffset int4 10
admissiondrug drugunit varchar 1000  √  null
apachepredvar ejectfx float8 17,17  √  null
apachepredvar electivesurgery int2 5  √  null
vitalperiodic etco2 int4 10  √  null
patient ethnicity varchar 50  √  null
apacheapsvar eyes int2 5  √  null
apachepredvar eyes int2 5  √  null
apacheapsvar fio2 float8 17,17  √  null
apachepredvar fio2 float8 17,17  √  null
medication frequency varchar 255  √  null
apachepredvar gender int2 5  √  null
patient gender varchar 25  √  null
apacheapsvar glucose float8 17,17  √  null
apachepredvar graftcount int2 5  √  null
medication gtc int4 10
apacheapsvar heartrate float8 17,17  √  null
vitalperiodic heartrate int4 10  √  null
apacheapsvar hematocrit float8 17,17  √  null
apachepredvar hepaticfailure int2 5  √  null
respiratorycare hiexhmvlimit numeric 11,4  √  null
respiratorycare highironoxlimit numeric 11,4  √  null
respiratorycare hipeakpreslimit numeric 11,4  √  null
respiratorycare hirespratelimit numeric 11,4  √  null
patient hospitaladmitoffset int4 10  √  null
patient hospitaladmitsource varchar 30  √  null
patient hospitaladmittime24 varchar 8  √  null
patient hospitaldischargelocation varchar 100  √  null
patient hospitaldischargeoffset int4 10  √  null
patient hospitaldischargestatus varchar 10  √  null
patient hospitaldischargetime24 varchar 8  √  null
patient hospitaldischargeyear int2 5  √  null
hospital hospitalid int4 10
patient hospitalid int4 10  √  null
diagnosis icd9code varchar 100  √  null
vitalperiodic icp int4 10  √  null
apachepredvar ima int2 5  √  null
apachepredvar immunosuppression int2 5  √  null
careplaninfectiousdisease infectdiseaseassessment varchar 64  √  null
careplaninfectiousdisease infectdiseasesite varchar 64  √  null
infusiondrug infusiondrugid int4 10
infusiondrug infusionoffset int4 10
infusiondrug infusionrate varchar 255  √  null
intakeoutput intakeoutputentryoffset int4 10
intakeoutput intakeoutputid int4 10
intakeoutput intakeoutputoffset int4 10
intakeoutput intaketotal numeric 12,4  √  null
careplancareprovider interventioncategory varchar 255  √  null
apacheapsvar intubated int2 5  √  null
lab labid int4 10
lab labmeasurenameinterface varchar 255  √  null
lab labmeasurenamesystem varchar 255  √  null
lab labname varchar 256  √  null
customlab labothername varchar 64  √  null
customlab labotheroffset int4 10
customlab labotherresult varchar 64  √  null
customlab labothertypeid int4 10
customlab labothervaluetext varchar 128  √  null
lab labresult numeric 11,4  √  null
lab labresultoffset int4 10
lab labresultrevisedoffset int4 10  √  null
lab labresulttext varchar 255  √  null
lab labtypeid numeric 3
apachepredvar leukemia int2 5  √  null
medication loadingdose varchar 120
respiratorycare lowexhmvlimit numeric 11,4  √  null
respiratorycare lowexhtvlimit numeric 11,4  √  null
respiratorycare lowironoxlimit numeric 11,4  √  null
respiratorycare lowpeakpreslimit numeric 11,4  √  null
respiratorycare lowrespratelimit numeric 11,4  √  null
apachepredvar lymphoma int2 5  √  null
apachepredvar managementsystem int2 5  √  null
careplancareprovider managingphysician varchar 50  √  null
respiratorycare meanairwaypreslimit numeric 11,4  √  null
apacheapsvar meanbp float8 17,17  √  null
medication medicationid int4 10
apacheapsvar meds int2 5  √  null
apachepredvar meds int2 5  √  null
apachepredvar metastaticcancer int2 5  √  null
microlab microlabid int4 10
apachepredvar midur int2 5  √  null
apacheapsvar motor int2 5  √  null
apachepredvar motor int2 5  √  null
intakeoutput nettotal numeric 12,4  √  null
vitalaperiodic noninvasivediastolic float8 17,17  √  null
vitalaperiodic noninvasivemean float8 17,17  √  null
vitalaperiodic noninvasivesystolic float8 17,17  √  null
note noteenteredoffset int4 10
note noteid int4 10
note noteoffset int4 10
note notepath varchar 255
note notetext varchar 500  √  null
note notetype varchar 50
note notevalue varchar 150  √  null
hospital numbedscategory varchar 32  √  null
nurseassessment nurseassessentryoffset int4 10
nurseassessment nurseassessid int4 10
nurseassessment nurseassessoffset int4 10
nursecare nursecareentryoffset int4 10
nursecare nursecareid int4 10
nursecare nursecareoffset int4 10
nursecharting nursingchartcelltypecat varchar 255
nursecharting nursingchartcelltypevallabel varchar 255  √  null
nursecharting nursingchartcelltypevalname varchar 255  √  null
nursecharting nursingchartentryoffset int4 10
nursecharting nursingchartid int8 19
nursecharting nursingchartoffset int4 10
nursecharting nursingchartvalue varchar 255  √  null
vitalaperiodic observationoffset int4 10
vitalperiodic observationoffset int4 10  √  null
apachepredvar oobintubday1 int2 5  √  null
apachepredvar oobventday1 int2 5  √  null
microlab organism varchar 255
intakeoutput outputtotal numeric 12,4  √  null
vitalperiodic padiastolic int4 10  √  null
vitalperiodic pamean int4 10  √  null
apacheapsvar pao2 float8 17,17  √  null
apachepredvar pao2 float8 17,17  √  null
vitalaperiodic paop float8 17,17  √  null
pasthistory pasthistoryenteredoffset int4 10
pasthistory pasthistoryid int4 10
pasthistory pasthistorynotetype varchar 40  √  null
pasthistory pasthistoryoffset int4 10
pasthistory pasthistorypath varchar 255
pasthistory pasthistoryvalue varchar 100  √  null
pasthistory pasthistoryvaluetext varchar 255  √  null
vitalperiodic pasystolic int4 10  √  null
patient patienthealthsystemstayid int4 10  √  null
admissiondrug patientunitstayid int4 10
admissiondx patientunitstayid int4 10
allergy patientunitstayid int4 10
apacheapsvar patientunitstayid int4 10  √  null
apachepatientresult patientunitstayid int4 10
apachepredvar patientunitstayid int4 10  √  null
careplancareprovider patientunitstayid int4 10
careplaneol patientunitstayid int4 10
careplangeneral patientunitstayid int4 10
careplangoal patientunitstayid int4 10
careplaninfectiousdisease patientunitstayid int4 10
customlab patientunitstayid int4 10
diagnosis patientunitstayid int4 10
infusiondrug patientunitstayid int4 10
intakeoutput patientunitstayid int4 10
lab patientunitstayid int4 10
medication patientunitstayid int4 10
microlab patientunitstayid int4 10
note patientunitstayid int4 10
nurseassessment patientunitstayid int4 10
nursecare patientunitstayid int4 10
nursecharting patientunitstayid int4 10
pasthistory patientunitstayid int4 10
patient patientunitstayid int4 10
physicalexam patientunitstayid int4 10
respiratorycare patientunitstayid int4 10  √  null
respiratorycharting patientunitstayid int4 10  √  null
treatment patientunitstayid int4 10  √  null
vitalaperiodic patientunitstayid int4 10
vitalperiodic patientunitstayid int4 10  √  null
infusiondrug patientweight varchar 255  √  null
apacheapsvar pco2 float8 17,17  √  null
respiratorycare peeplimit numeric 11,4  √  null
apacheapsvar ph float8 17,17  √  null
physicalexam physicalexamid int4 10  √  null
physicalexam physicalexamoffset int4 10
physicalexam physicalexampath varchar 255
physicalexam physicalexamtext varchar 500  √  null
physicalexam physicalexamvalue varchar 100  √  null
apachepatientresult physicianinterventioncategory varchar 50  √  null
apachepatientresult physicianspeciality varchar 50  √  null
apachepatientresult predictedhospitallos float8 17,17  √  null
apachepatientresult predictedhospitalmortality varchar 50  √  null
apachepatientresult predictediculos float8 17,17  √  null
apachepatientresult predictedicumortality varchar 50  √  null
apachepatientresult predventdays float8 17,17  √  null
apachepatientresult preopcardiaccath int4 10  √  null
apachepatientresult preopmi int4 10  √  null
respiratorycare priorventendoffset int4 10  √  null
respiratorycare priorventstartoffset int4 10  √  null
medication prn varchar 6
careplancareprovider providertype varchar 255  √  null
apachepatientresult ptcawithin24h int4 10  √  null
vitalaperiodic pvr float8 17,17  √  null
vitalaperiodic pvri float8 17,17  √  null
apachepredvar readmit int2 5  √  null
apachepredvar region int2 5  √  null
hospital region varchar 64  √  null
respiratorycare respcareid int4 10  √  null
respiratorycare respcarestatusoffset int4 10  √  null
respiratorycharting respchartentryoffset int4 10  √  null
respiratorycharting respchartid int4 10  √  null
respiratorycharting respchartoffset int4 10  √  null
respiratorycharting respcharttypecat varchar 255  √  null
respiratorycharting respchartvalue varchar 1000  √  null
respiratorycharting respchartvaluelabel varchar 255  √  null
vitalperiodic respiration int4 10  √  null
apacheapsvar respiratoryrate float8 17,17  √  null
careplaninfectiousdisease responsetotherapy varchar 32  √  null
medication routeadmin varchar 120  √  null
admissiondrug rxincluded varchar 5  √  null
allergy rxincluded varchar 5  √  null
vitalperiodic sao2 int4 10  √  null
apachepredvar saps3day1 int2 5  √  null
apachepredvar saps3today int2 5  √  null
apachepredvar saps3yesterday int2 5  √  null
microlab sensitivitylevel varchar 255  √  null
respiratorycare setapneafio2 varchar 80  √  null
respiratorycare setapneaie varchar 80  √  null
respiratorycare setapneainsptime varchar 80  √  null
respiratorycare setapneainterval varchar 80  √  null
respiratorycare setapneaippeephigh varchar 80  √  null
respiratorycare setapneapeakflow varchar 80  √  null
respiratorycare setapnearr varchar 80  √  null
respiratorycare setapneatv varchar 80  √  null
apachepredvar sicuday int2 5  √  null
respiratorycare sighpreslimit numeric 11,4  √  null
apacheapsvar sodium float8 17,17  √  null
careplancareprovider specialty varchar 255  √  null
admissiondrug specialtytype varchar 255  √  null
allergy specialtytype varchar 255  √  null
vitalperiodic st1 float8 17,17  √  null
vitalperiodic st2 float8 17,17  √  null
vitalperiodic st3 float8 17,17  √  null
vitalaperiodic svr float8 17,17  √  null
vitalaperiodic svri float8 17,17  √  null
vitalperiodic systemicdiastolic int4 10  √  null
vitalperiodic systemicmean int4 10  √  null
vitalperiodic systemicsystolic int4 10  √  null
hospital teachingstatus bool 1  √  null
apachepredvar teachtype int2 5  √  null
apacheapsvar temperature float8 17,17  √  null
vitalperiodic temperature numeric 11,4  √  null
apachepredvar thrombolytics int2 5  √  null
careplaninfectiousdisease treatment varchar 32  √  null
treatment treatmentid int4 10  √  null
treatment treatmentoffset int4 10  √  null
treatment treatmentstring varchar 200  √  null
apachepatientresult unabridgedactualventdays float8 17,17  √  null
apachepatientresult unabridgedhosplos float8 17,17  √  null
apachepatientresult unabridgedunitlos float8 17,17  √  null
patient uniquepid varchar 10  √  null
patient unitadmitsource varchar 100  √  null
patient unitadmittime24 varchar 8  √  null
patient unitdischargelocation varchar 100  √  null
patient unitdischargeoffset int4 10  √  null
patient unitdischargestatus varchar 10  √  null
patient unitdischargetime24 varchar 8  √  null
patient unitstaytype varchar 15  √  null
patient unittype varchar 50  √  null
patient unitvisitnumber int4 10  √  null
apacheapsvar urine float8 17,17  √  null
admissiondrug usertype varchar 255
allergy usertype varchar 255
apachepredvar var03hspxlos float8 17,17  √  null
apacheapsvar vent int2 5  √  null
apachepredvar ventday1 int2 5  √  null
respiratorycare ventendoffset int4 10  √  null
respiratorycare ventstartoffset int4 10  √  null
apacheapsvar verbal int2 5  √  null
apachepredvar verbal int2 5  √  null
apachepredvar visitnumber int2 5  √  null
vitalaperiodic vitalaperiodicid int4 10
vitalperiodic vitalperiodicid int8 19  √  null
infusiondrug volumeoffluid varchar 255  √  null
patient wardid int4 10  √  null
apacheapsvar wbc float8 17,17  √  null
admissiondrug writtenineicu varchar 5  √  null
allergy writtenineicu varchar 5  √  null