CREATE TABLE ICD_9 (
        ICD_9 VARCHAR(10) NOT NULL, /*Unique values taken from here*/	
)

##</code><code>##

CREATE TABLE ICD_specifications_for_disease (                                                              Range_key int NOT NULL,
	Disease_or_health_catagory VARCHAR(30) NOT NULL,
	ICD_catagory int NOT NULL,  
	ICD_start VARCHAR(5) NULL,   /*between this value and */
   	ICD_end VARCHAR(5) NULL,     /* and this value */ 	                                                       Date_created TIMESTAMP NOT NULL,
   	PRIMARY KEY (Range_Key)
)

##</code><code>##

CREATE TABLE ICD_9_Disease_Types (
          ICD_9_code VARCHAR(4) NOT NULL, /* same as first collumn in table 1*/
          CHD int DEFAULT '0' NOT NULL,
          Circulatory_Disease int DEFAULT '0' NOT NULL,
          All_Cancer int DEFAULT '0' NOT NULL,
          Lung_Cancer int DEFAULT '0' NOT NULL,
          Breast_Cancer int DEFAULT '0' NOT NULL,
          Cervical_Cancer int DEFAULT '0' NOT NULL,
          Colorectal_Cancer int DEFAULT '0' NOT NULL,
          Skin_Cancer int DEFAULT '0' NOT NULL,
          Respiratory_Disease int DEFAULT '0' NOT NULL,
          COPD int DEFAULT '0' NOT NULL,
          Stroke int DEFAULT '0' NOT NULL
)