-- ABS-30104
ALTER TABLE PACKINGNOTE ADD (CLEANROOMBATCH_ID NUMBER NULL);

CREATE INDEX XIF20PACKINGNOTE ON PACKINGNOTE (CLEANROOMBATCH_ID ASC);
  
ALTER TABLE PACKINGNOTE
  ADD CONSTRAINT PACKINGNOTE_CLEANROOMBATCH FOREIGN KEY (CLEANROOMBATCH_ID)
  REFERENCES CLEANROOMBATCH (CLEANROOMBATCH_ID);
