CREATE TABLE rbc_returned_evaluation (
  id bigint(20) NOT NULL AUTO_INCREMENT,
  original_evaluation_id bigint(20) NOT NULL,
  overallComment varchar(255) DEFAULT NULL,
  PRIMARY KEY (id),
  KEY rbc_ret_orig_id (original_evaluation_id)
);

CREATE TABLE rbc_returned_criterion_outcome (
  id bigint(20) NOT NULL AUTO_INCREMENT,
  comments longtext DEFAULT NULL,
  criterion_id bigint(20) DEFAULT NULL,
  points double DEFAULT NULL,
  pointsAdjusted bit(1) NOT NULL,
  selected_rating_id bigint(20) DEFAULT NULL,
  PRIMARY KEY (id),
  KEY ret_criterion_key (criterion_id),
  CONSTRAINT ret_criterion_fk FOREIGN KEY (criterion_id) REFERENCES rbc_criterion (id)
);

CREATE TABLE rbc_returned_criterion_outcomes (
  rbc_returned_evaluation_id bigint(20) NOT NULL,
  rbc_returned_criterion_outcome_id bigint(20) NOT NULL,
  UNIQUE KEY returned_criterion_outcome_id_key (rbc_returned_criterion_outcome_id),
  KEY returned_evaluation_id_key (rbc_returned_evaluation_id),
  CONSTRAINT returned_criterion_outcome_id_fk FOREIGN KEY (rbc_returned_criterion_outcome_id) REFERENCES rbc_returned_criterion_outcome (id),
  CONSTRAINT returned_evalution_id_fk FOREIGN KEY (rbc_returned_evaluation_id) REFERENCES rbc_returned_evaluation (id)
);