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

  CREATE TABLE "MIMIC2V26"."DEMOGRAPHIC_DETAIL" 
   (	"SUBJECT_ID" NUMBER(7,0) NOT NULL ENABLE, 
	"HADM_ID" NUMBER(7,0) NOT NULL ENABLE, 
	"MARITAL_STATUS_ITEMID" NUMBER(7,0), 
	"MARITAL_STATUS_DESCR" VARCHAR2(50), 
	"ETHNICITY_ITEMID" NUMBER(7,0), 
	"ETHNICITY_DESCR" VARCHAR2(50), 
	"OVERALL_PAYOR_GROUP_ITEMID" NUMBER(7,0), 
	"OVERALL_PAYOR_GROUP_DESCR" VARCHAR2(50), 
	"RELIGION_ITEMID" NUMBER(7,0), 
	"RELIGION_DESCR" VARCHAR2(50), 
	"ADMISSION_TYPE_ITEMID" NUMBER(7,0), 
	"ADMISSION_TYPE_DESCR" VARCHAR2(50), 
	"ADMISSION_SOURCE_ITEMID" NUMBER(7,0), 
	"ADMISSION_SOURCE_DESCR" VARCHAR2(50)
   ) 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" 
/