Main Tables Materialized Views Indexes Constraints DDL scrips
Description Columns Primary key Check Constraints Foreign keys Unique Keys Options Indexes Referenced by Triggers Partitions

MIMIC2V26.DELIVERIES

DDL script

Columns

NameTypeNullableDefault valueComment
SUBJECT_IDNUMBER(7)N Unique patient identifier.
ICUSTAY_IDNUMBER(7)Y Unique ICU stay identifier
IOITEMIDNUMBER(7)N The IO item id for the delivery.
CHARTTIMETIMESTAMP(6) WITH TIME ZONEN The chart time of the IO delivery.
ELEMIDNUMBER(7)N The element of a combined delivery
CGIDNUMBER(7)Y The care giver for the delivery.
CUIDNUMBER(7)Y The care unit for the delivery.
SITEVARCHAR2(20)Y The site of the delivery.
RATENUMBER(38)Y The delivery rate.
RATEUOMVARCHAR2(20)N The units of measurement of the rate of delivery.

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
MIMIC2V26.DELIVERI_FK_D_CAREGICGID MIMIC2V26.D_CAREGIVERS MIMIC2V26.D_CAREGIVERS_PK NO ACTION
MIMIC2V26.DELIVERI_FK_D_CAREUNCUID MIMIC2V26.D_CAREUNITS MIMIC2V26.D_CAREUNITS_PK NO ACTION
MIMIC2V26.DELIVERI_FK_D_IOITEMIOITEMID MIMIC2V26.D_IOITEMS MIMIC2V26.D_IOITEMS_PK NO ACTION
MIMIC2V26.DELIVERI_FK_D_PATIENSUBJECT_ID MIMIC2V26.D_PATIENTS MIMIC2V26.D_PATIENTS_PK NO ACTION
MIMIC2V26.DELIVERI_FK_ICUSTAYICUSTAY_ID MIMIC2V26.ICUSTAYEVENTS MIMIC2V26.ICUSTAYEV_PK NO ACTION

Options:

OptionSettings
TablespaceMIMIC2_DAT
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumnsDDL script
MIMIC2V26.DELIVERIES_O1NORMALNONUNIQUECUID DDL script
MIMIC2V26.DELIVERIES_O2NORMALNONUNIQUESUBJECT_ID DDL script
MIMIC2V26.DELIVERIES_O3NORMALNONUNIQUEIOITEMID DDL script
MIMIC2V26.DELIVERIES_O4NORMALNONUNIQUEICUSTAY_ID DDL script
MIMIC2V26.DELIVERIES_O5NORMALNONUNIQUECGID DDL script
MIMIC2V26.DELIVERIES_PKFUNCTION-BASED NORMALUNIQUESUBJECT_ID , IOITEMID , SYS_EXTRACT_UTC("CHARTTIME") , ELEMID DDL script
Generated by OraSchemaDoc, (c) Petr Vanek, 2005; Aram Kananov, 2002, on Tue Apr 19 09:28:47 2011