-- created by Oraschemadoc Tue Apr 19 09:28:33 2011 -- visit http://www.yarpen.cz/oraschemadoc/ for more info CREATE TABLE "MIMIC2V26"."ICUSTAY_DAYS" ( "ICUSTAY_ID" NUMBER(7,0), "SUBJECT_ID" NUMBER(7,0), "SEQ" NUMBER(7,0), "BEGINTIME" TIMESTAMP (6) WITH TIME ZONE, "ENDTIME" TIMESTAMP (6) WITH TIME ZONE, "FIRST_DAY_FLG" CHAR(1), "LAST_DAY_FLG" CHAR(1) ) 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" CACHE /