 DROP TABLE IF EXISTS mimic_ed.triage CASCADE;
 CREATE TABLE mimic_ed.triage
 (
-  subject_id INT NOT NULL,
-  stay_id INT NOT NULL,
-  temperature DOUBLE PRECISION,
-  heartrate DOUBLE PRECISION,
-  resprate DOUBLE PRECISION,
-  o2sat DOUBLE PRECISION,
-  sbp DOUBLE PRECISION,
-  dbp DOUBLE PRECISION,
-  pain DOUBLE PRECISION,
-  acuity DOUBLE PRECISION,
+  subject_id INTEGER NOT NULL,
+  stay_id INTEGER NOT NULL,
+  temperature NUMERIC,
+  heartrate NUMERIC,
+  resprate NUMERIC,
+  o2sat NUMERIC,
+  sbp NUMERIC,
+  dbp NUMERIC,
+  pain TEXT,
+  acuity NUMERIC,
   chiefcomplaint VARCHAR(255)
 ) ;
 

DROP TABLE IF EXISTS mimic_ed.diagnosis CASCADE;
CREATE TABLE mimic_ed.diagnosis
(
  subject_id INT NOT NULL,
  stay_id INT NOT NULL,
  seq_num INT NOT NULL,
  icd_code VARCHAR(10) NOT NULL,
  icd_version INT NOT NULL,
  icd_title VARCHAR(255) NOT NULL
) ;

--------------------------------------------------------

-- -------------------------------------------------------------------------------

--------------------------------------------------------
--  File created - Wed 13 Jul 2022
--------------------------------------------------------

DROP SCHEMA IF EXISTS mimic_ed CASCADE;
