 -- keyword_lab_file table
 CREATE TABLE keyword_file_temp AS SELECT * FROM keyword_lab_file;
 
-update keyword_file_temp kpt, keyword_temp kt, keyword k
+update keyword_file_temp kpt, keyword_temp kt, cananolab.keyword k
 set kpt.keyword_pk_id = kt.keyword_pk_id
 where  lcase(kt.name) = lcase(k.name)
 and  kpt.keyword_pk_id = k.keyword_pk_id

FROM cananolab.keyword_bioassay_data
;


INSERT INTO canano.keyword
(
	keyword_pk_id,
	name
)
SELECT keyword_pk_id,
  name
FROM cananolab.keyword
;

-- sample

insert into canano.report
(
	report_pk_id,

FROM cananolab.instrument_config
;

INSERT INTO canano.derived_bioassay_data
(
	derived_bioassay_data_pk_id,
