Help for this page

Select Code to Download


  1. or download this
    
    CREATE TABLE ICD_9 (
            ICD_9 VARCHAR(10) NOT NULL, /*Unique values taken from here*/ 
    +   
    )
    
  2. or download this
    CREATE TABLE ICD_specifications_for_disease (                         
    +                                     Range_key int NOT NULL,
        Disease_or_health_catagory VARCHAR(30) NOT NULL,
    ...
           ICD_end VARCHAR(5) NULL,     /* and this value */              
    +                                              Date_created TIMESTAMP 
    +NOT NULL,
           PRIMARY KEY (Range_Key)
    )
    
  3. or download this
    CREATE TABLE ICD_9_Disease_Types (
              ICD_9_code VARCHAR(4) NOT NULL, /* same as first collumn in 
    +table 1*/
    ...
              COPD int DEFAULT '0' NOT NULL,
              Stroke int DEFAULT '0' NOT NULL
    )