/*************************************************/
/***               DATA ANALYSIS               ***/
/*************************************************/

CREATE TABLE DAN_DataAnalysisResults
(
  ID          VARCHAR(50) NOT NULL,
  analysis_ID VARCHAR(50) NOT NULL,
  file_url    VARCHAR(50),
  file_type   VARCHAR(50),
  hypotheses  TEXT,
  results     TEXT,
  xml_schema  VARCHAR(50),
  comment     TEXT,

  PRIMARY KEY(ID),

  FOREIGN KEY(ID) REFERENCES ADM_Experiment(ID)
  ON DELETE RESTRICT ON UPDATE CASCADE,

  FOREIGN KEY(analysis_ID) REFERENCES ANL_Analysis(ID)
  ON DELETE RESTRICT ON UPDATE CASCADE
);