 	FOREIGN KEY (functionalizing_entity_pk_id) REFERENCES associated_element (associated_element_pk_id)
 ;
 
-ALTER TABLE functionalizing_entity ADD CONSTRAINT FK_functionalizing_entity_composition 
-	FOREIGN KEY (composition_pk_id) REFERENCES composition (composition_pk_id)
-;
-
-ALTER TABLE composition_lab_file ADD CONSTRAINT FK_composition_lab_file_composition 
-	FOREIGN KEY (composition_pk_id) REFERENCES composition (composition_pk_id)
-;
-
 ALTER TABLE composition_lab_file ADD CONSTRAINT FK_composition_lab_file_lab_file 
 	FOREIGN KEY (file_pk_id) REFERENCES lab_file (file_pk_id)
 ;

CREATE TABLE derived_bioassay_data
(
	derived_bioassay_data_pk_id BIGINT NOT NULL,
	characterization_pk_id BIGINT NOT NULL,
	file_pk_id BIGINT NULL,
	created_by VARCHAR(200) NOT NULL,
	created_date DATETIME NOT NULL,

) TYPE=InnoDB
;


CREATE TABLE nano_function
(
	function_pk_id BIGINT NOT NULL,
