 
 CREATE INDEX QUALCTRLTYPE_TERM_IDX ON QUALITYCONTROLTYPE(TERM_ID);
 
+CREATE INDEX CHARACTERISTIC_TERM_IDX ON CHARACTERISTIC(TERM_ID);
+
+CREATE INDEX CHARACTERISTIC_UNIT_IDX ON CHARACTERISTIC(UNIT_ID);
+
+CREATE INDEX CHARACTERISTIC_BIOMATERIAL_IDX ON CHARACTERISTIC(BIOMATERIAL_ID);
+
+CREATE INDEX BIOMATERIAL_TYPE_IDX ON BIOMATERIAL(BIOMATERIAL_TYPE_ID);
+
+CREATE INDEX BIOMATERIAL_LABEL_IDX ON BIOMATERIAL(LABEL_ID);
+
+CREATE INDEX SOURCEPROVIDER_SOURCE_IDX ON SOURCEPROVIDER(SOURCE_ID);
+
+CREATE INDEX SOURCEPROVIDER_CONTACT_IDX ON SOURCEPROVIDER(CONTACT_ID);
+
+CREATE INDEX SOURCESAMPLE_SOURCE_IDX ON SOURCESAMPLE(SOURCE_ID);
+
+CREATE INDEX SOURCESAMPLE_SAMPLE_IDX ON SOURCESAMPLE(SAMPLE_ID);
+
+CREATE INDEX SAMPLEEXTRACT_SAMPLE_IDX ON SAMPLEEXTRACT(SAMPLE_ID);
+
+CREATE INDEX SAMPLEEXTRACT_EXTRACT_IDX ON SAMPLEEXTRACT(EXTRACT_ID);
+
+CREATE INDEX EXTRACTLABELEDEXTRACT_E_IDX ON EXTRACTLABELEDEXTRACT(EXTRACT_ID);
+
+CREATE INDEX EXTRACTLABELEDEXTRACT_LE_IDX ON EXTRACTLABELEDEXTRACT(LABELEDEXTRACT_ID);
+
 SET FOREIGN_KEY_CHECKS = 1;

(
  ID                          BIGINT      NOT NULL,
  PROTOCOL_ID                 BIGINT      NOT NULL,
  PRIMARY KEY                 (ID)
);



CREATE INDEX PROTOCOLAPP_PROTOCOL ON PROTOCOLAPPLICATION(PROTOCOL_ID);

CREATE INDEX PROTOCOLAPP_BIOMATERIAL ON PROTOCOLAPPLICATION(BIOMATERIAL_ID);

CREATE INDEX PARAMVALUE_PROTOCOLAPP_IDX ON PARAMETERVALUE(PROTOCOL_APPLICATION_ID);

CREATE INDEX PARAMVALUE_PARAMETER_IDX ON PARAMETERVALUE(PARAMETER_ID);
