 	element_type,
 	nanoparticle_entity_pk_id
 )
-SELECT nc.nanoparticle_entity_pk_id,
+SELECT ce.composing_element_pk_id,
 	ce.element_type,
 	ce.characterization_pk_id
 FROM cananolab.composing_element ce,
-	cananolab.characterization c,	
-	cananolab.nanoparticle_char nc
+	cananolab.characterization c
 WHERE ce.characterization_pk_id = c.characterization_pk_id
-and nc.characterization_pk_id = ca.characterization_pk_id
 AND c.discriminator != 'ComplexComp'
 ORDER BY ce.composing_element_pk_id, ce.list_index
 ;

	created_date,
	discriminator
)
SELECT nc.e_composition_pk_id,
	c.e_composition_pk_id,
	ca.created_by,
	ca.created_date,
	'Emulsion'
FROM cananolab.emulsion_composition c,
	cananolab.characterization ca,
	cananolab.nanoparticle_char nc
WHERE c.e_composition_pk_id = ca.characterization_pk_id
and nc.characterization_pk_id = ca.characterization_pk_id
;

insert into canano.composition

	created_date,
	discriminator
)
SELECT ca.characterization_pk_id,
	ca.characterization_pk_id,
	ca.created_by,
	ca.created_date,
	'QuantumDot'
FROM cananolab.characterization ca
WHERE ca.discriminator = 'QuantumDotComp'
;

insert into canano.composition
