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.ADDITIVES

DDL script

Columns

NameTypeNullableDefault valueComment
SUBJECT_IDNUMBER(7)N Unique patient identifier
ICUSTAY_IDNUMBER(7)Y Unique ICU stay identifier
ITEMIDNUMBER(7)N The medication item which this additive relates to
IOITEMIDNUMBER(7)N The IO item which this additive relates to
CHARTTIMETIMESTAMP(6) WITH TIME ZONEN The date/time for the additive
ELEMIDNUMBER(7)N The element of a combined additive
CGIDNUMBER(7)Y The caregiver ID
CUIDNUMBER(7)Y The careunit ID
AMOUNTNUMBER(38)Y The amount of additive given
DOSEUNITSVARCHAR2(20)Y The units of the additive given
ROUTEVARCHAR2(20)Y The route through which the additive is given

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
MIMIC2V26.ADDITIVES_FK_D_CAREGICGID MIMIC2V26.D_CAREGIVERS MIMIC2V26.D_CAREGIVERS_PK NO ACTION
MIMIC2V26.ADDITIVES_FK_D_CAREUNCUID MIMIC2V26.D_CAREUNITS MIMIC2V26.D_CAREUNITS_PK NO ACTION
MIMIC2V26.ADDITIVES_FK_D_IOITEMIOITEMID MIMIC2V26.D_IOITEMS MIMIC2V26.D_IOITEMS_PK NO ACTION
MIMIC2V26.ADDITIVES_FK_D_MEDITEITEMID MIMIC2V26.D_MEDITEMS MIMIC2V26.D_MEDITEMS_PK NO ACTION
MIMIC2V26.ADDITIVES_FK_D_PATIENSUBJECT_ID MIMIC2V26.D_PATIENTS MIMIC2V26.D_PATIENTS_PK NO ACTION
MIMIC2V26.ADDITIVES_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.ADDITIVES_O1NORMALNONUNIQUECUID DDL script
MIMIC2V26.ADDITIVES_O2NORMALNONUNIQUESUBJECT_ID DDL script
MIMIC2V26.ADDITIVES_O3NORMALNONUNIQUEIOITEMID DDL script
MIMIC2V26.ADDITIVES_O4NORMALNONUNIQUEITEMID DDL script
MIMIC2V26.ADDITIVES_O5NORMALNONUNIQUEICUSTAY_ID DDL script
MIMIC2V26.ADDITIVES_O6NORMALNONUNIQUECGID DDL script