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

Description:

Medications which make up a POE_ORDER. For each entry in the POE_ORDER table there will be 1 or more rows here indicating the medication administered

DDL script

Columns

NameTypeNullableDefault valueComment
POE_IDNUMBER(15)N The POE_ID from POE_ORDER
DRUG_TYPEVARCHAR2(20)N Type of drug
DRUG_NAMEVARCHAR2(100)N The drug's name
DRUG_NAME_GENERICVARCHAR2(100)Y Generic name of the drug
PROD_STRENGTHVARCHAR2(255)Y Product strength
FORM_RXVARCHAR2(25)Y  
DOSE_VAL_RXVARCHAR2(100)Y Value of dose received
DOSE_UNIT_RXVARCHAR2(50)Y Units of dose received
FORM_VAL_DISPVARCHAR2(50)Y  
FORM_UNIT_DISPVARCHAR2(50)Y  
DOSE_VAL_DISPNUMBER(38)Y Displayed dosage
DOSE_UNIT_DISPVARCHAR2(50)Y Displayed dispensed unit
DOSE_RANGE_OVERRIDEVARCHAR2(2000)Y Override the range of the dosage

Foreign Keys:

Constraint NameColumnsReferenced tableReferenced ConstraintOn Delete Rule
MIMIC2V26.POE_MED_POE_ORDER_FK1POE_ID MIMIC2V26.POE_ORDER MIMIC2V26.POE_ORDER_PK NO ACTION

Options:

OptionSettings
TablespaceMIMIC2_DAT
Index OrganizedNo
Generated by OracleNo
ClusteredNo
NestedNo
TemporaryNo

Indexes:

Index NameTypeUnuquenessColumnsDDL script
MIMIC2V26.POE_MED_O1NORMALNONUNIQUEPOE_ID DDL script
Generated by OraSchemaDoc, (c) Petr Vanek, 2005; Aram Kananov, 2002, on Tue Apr 19 09:28:48 2011