- or download this
CREATE TABLE ICD_9 (
ICD_9 VARCHAR(10) NOT NULL, /*Unique values taken from here*/
+
)
- 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)
)
- 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
)