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

  CREATE TABLE "MIMIC2V26"."ICUSTAY_DETAIL" 
   (	"ICUSTAY_ID" NUMBER(7,0), 
	"SUBJECT_ID" NUMBER(7,0), 
	"GENDER" VARCHAR2(1), 
	"DOB" DATE NOT NULL ENABLE, 
	"DOD" DATE, 
	"EXPIRE_FLG" VARCHAR2(1), 
	"SUBJECT_ICUSTAY_TOTAL_NUM" NUMBER, 
	"SUBJECT_ICUSTAY_SEQ" NUMBER, 
	"HADM_ID" NUMBER(7,0), 
	"HOSPITAL_TOTAL_NUM" NUMBER, 
	"HOSPITAL_SEQ" NUMBER, 
	"HOSPITAL_FIRST_FLG" CHAR(1), 
	"HOSPITAL_LAST_FLG" CHAR(1), 
	"HOSPITAL_ADMIT_DT" DATE, 
	"HOSPITAL_DISCH_DT" DATE, 
	"HOSPITAL_LOS" NUMBER, 
	"HOSPITAL_EXPIRE_FLG" CHAR(1), 
	"ICUSTAY_TOTAL_NUM" NUMBER, 
	"ICUSTAY_SEQ" NUMBER, 
	"ICUSTAY_FIRST_FLG" CHAR(1), 
	"ICUSTAY_LAST_FLG" CHAR(1), 
	"ICUSTAY_INTIME" TIMESTAMP (6) WITH TIME ZONE NOT NULL ENABLE, 
	"ICUSTAY_OUTTIME" TIMESTAMP (6) WITH TIME ZONE NOT NULL ENABLE, 
	"ICUSTAY_ADMIT_AGE" NUMBER, 
	"ICUSTAY_AGE_GROUP" VARCHAR2(7), 
	"ICUSTAY_LOS" NUMBER NOT NULL ENABLE, 
	"ICUSTAY_EXPIRE_FLG" CHAR(1), 
	"ICUSTAY_FIRST_CAREUNIT" VARCHAR2(20), 
	"ICUSTAY_LAST_CAREUNIT" VARCHAR2(20), 
	"ICUSTAY_FIRST_SERVICE" VARCHAR2(110), 
	"ICUSTAY_LAST_SERVICE" VARCHAR2(110), 
	"HEIGHT" NUMBER, 
	"WEIGHT_FIRST" NUMBER, 
	"WEIGHT_MIN" NUMBER, 
	"WEIGHT_MAX" NUMBER, 
	"SAPSI_FIRST" NUMBER, 
	"SAPSI_MIN" NUMBER, 
	"SAPSI_MAX" NUMBER, 
	"SOFA_FIRST" NUMBER, 
	"SOFA_MIN" NUMBER, 
	"SOFA_MAX" NUMBER, 
	"MATCHED_WAVEFORMS_NUM" NUMBER
   ) SEGMENT CREATION IMMEDIATE 
  PCTFREE 10 PCTUSED 40 INITRANS 1 MAXTRANS 255 NOCOMPRESS 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" 
/