/*************************************************/
/***          CONTROLLED VOCABULARIES          ***/
/*************************************************/

CREATE TABLE VOC_experiment_type
(
  entry      VARCHAR(50) NOT NULL,
  definition TEXT,

  PRIMARY KEY(entry)
);


CREATE TABLE VOC_organism
(
  entry      VARCHAR(50) NOT NULL,
  definition TEXT,
  class      VARCHAR(50) NOT NULL,

  PRIMARY KEY(entry)
);


CREATE TABLE VOC_method
(
  entry      VARCHAR(50)   NOT NULL,
  name       VARCHAR(50)   NOT NULL,
  definition TEXT,

  PRIMARY KEY(entry)
);


CREATE TABLE VOC_mutation_type
(
  entry      VARCHAR(50) NOT NULL,
  definition TEXT,

  PRIMARY KEY(entry)
);


CREATE TABLE VOC_gender
(
  entry      CHAR(1)     NOT NULL,
  definition VARCHAR(10),

  PRIMARY KEY(entry)
);


CREATE TABLE VOC_ethnicity
(
  entry VARCHAR(50) NOT NULL,

  PRIMARY KEY(entry)
);