-- created by Oraschemadoc Tue Apr 19 09:28:34 2011
-- visit http://www.yarpen.cz/oraschemadoc/ for more info

  CREATE TABLE "MIMIC2V26"."MICROBIOLOGYEVENTS" 
   (	"SUBJECT_ID" NUMBER(7,0), 
	"HADM_ID" NUMBER(7,0), 
	"CHARTTIME" TIMESTAMP (6) WITH TIME ZONE, 
	"SPEC_ITEMID" NUMBER(7,0), 
	"ORG_ITEMID" NUMBER(7,0), 
	"ISOLATE_NUM" NUMBER, 
	"AB_ITEMID" NUMBER(7,0), 
	"DILUTION_AMOUNT" VARCHAR2(72), 
	"DILUTION_COMPARISON" VARCHAR2(10), 
	"INTERPRETATION" VARCHAR2(1), 
	 CONSTRAINT "MICROBIOEV_FK_D_PATIENTS" FOREIGN KEY ("SUBJECT_ID")
	  REFERENCES "MIMIC2V26"."D_PATIENTS" ("SUBJECT_ID") ENABLE, 
	 CONSTRAINT "MICROBIOEV_FK_ADMISSIONS" FOREIGN KEY ("HADM_ID")
	  REFERENCES "MIMIC2V26"."ADMISSIONS" ("HADM_ID") ENABLE, 
	 CONSTRAINT "MICROBIOEV_SPEC_FK_D_CODED" FOREIGN KEY ("SPEC_ITEMID")
	  REFERENCES "MIMIC2V26"."D_CODEDITEMS" ("ITEMID") ENABLE, 
	 CONSTRAINT "MICROBIOEV_ORG_FK_D_CODED" FOREIGN KEY ("ORG_ITEMID")
	  REFERENCES "MIMIC2V26"."D_CODEDITEMS" ("ITEMID") ENABLE, 
	 CONSTRAINT "MICROBIOEV_AB_FK_D_CODED" FOREIGN KEY ("AB_ITEMID")
	  REFERENCES "MIMIC2V26"."D_CODEDITEMS" ("ITEMID") ENABLE
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 COMPRESS FOR OLTP LOGGING
  STORAGE(INITIAL 65536 NEXT 1048576 MINEXTENTS 1 MAXEXTENTS 2147483645
  PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1 BUFFER_POOL DEFAULT FLASH_CACHE DEFAULT CELL_FLASH_CACHE DEFAULT)
  TABLESPACE "MIMIC2_DAT" 
/