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

  CREATE TABLE "MIMIC2V26"."COMORBIDITY_SCORES" 
   (	"SUBJECT_ID" NUMBER(7,0) NOT NULL ENABLE, 
	"HADM_ID" NUMBER(7,0) NOT NULL ENABLE, 
	"CATEGORY" CHAR(10), 
	"CONGESTIVE_HEART_FAILURE" NUMBER, 
	"CARDIAC_ARRHYTHMIAS" NUMBER, 
	"VALVULAR_DISEASE" NUMBER, 
	"PULMONARY_CIRCULATION" NUMBER, 
	"PERIPHERAL_VASCULAR" NUMBER, 
	"HYPERTENSION" NUMBER, 
	"PARALYSIS" NUMBER, 
	"OTHER_NEUROLOGICAL" NUMBER, 
	"CHRONIC_PULMONARY" NUMBER, 
	"DIABETES_UNCOMPLICATED" NUMBER, 
	"DIABETES_COMPLICATED" NUMBER, 
	"HYPOTHYROIDISM" NUMBER, 
	"RENAL_FAILURE" NUMBER, 
	"LIVER_DISEASE" NUMBER, 
	"PEPTIC_ULCER" NUMBER, 
	"AIDS" NUMBER, 
	"LYMPHOMA" NUMBER, 
	"METASTATIC_CANCER" NUMBER, 
	"SOLID_TUMOR" NUMBER, 
	"RHEUMATOID_ARTHRITIS" NUMBER, 
	"COAGULOPATHY" NUMBER, 
	"OBESITY" NUMBER, 
	"WEIGHT_LOSS" NUMBER, 
	"FLUID_ELECTROLYTE" NUMBER, 
	"BLOOD_LOSS_ANEMIA" NUMBER, 
	"DEFICIENCY_ANEMIAS" NUMBER, 
	"ALCOHOL_ABUSE" NUMBER, 
	"DRUG_ABUSE" NUMBER, 
	"PSYCHOSES" NUMBER, 
	"DEPRESSION" 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" 
  CACHE 
/