/*************************************************/
/***               YEAST METADATA              ***/
/*************************************************/

CREATE TABLE YST_Mutation
(
  source_ID     VARCHAR(50) NOT NULL,
  gene_ID       VARCHAR(10) NOT NULL,
  mutation_type VARCHAR(50) NOT NULL,

  PRIMARY KEY(source_ID, gene_ID),

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

  FOREIGN KEY(mutation_type) REFERENCES VOC_mutation_type(entry)
  ON DELETE RESTRICT ON UPDATE CASCADE
);


CREATE TABLE YST_GrowthProgress
(
  biosample_ID VARCHAR(50) NOT NULL,
  stage        INT         NOT NULL,
  check_date   DATE,
  check_time   TIME,
  observation  TEXT        NOT NULL,

  PRIMARY KEY(biosample_ID, stage),

  FOREIGN KEY(biosample_ID) REFERENCES BIO_BioSample(ID)
  ON DELETE RESTRICT ON UPDATE CASCADE
);
