--ABS-54301/ ABS57180

---PACKINGNOTECONTAINER table---
ALTER TABLE PACKINGNOTECONTAINER ADD (WEIGHINGTICKETLINE_ID NUMBER NULL);

CREATE INDEX XIF7PACKINGNOTECONTAINER ON PACKINGNOTECONTAINER (WEIGHINGTICKETLINE_ID ASC);

ALTER TABLE PACKINGNOTECONTAINER
  ADD CONSTRAINT PNCONTAINER_WEIGHTTICKETLINE FOREIGN KEY (WEIGHINGTICKETLINE_ID)
  REFERENCES WEIGHINGTICKETLINE (WEIGHINGTICKETLINE_ID) ON DELETE SET NULL;

---WEIGHINGTICKET table---
ALTER TABLE WEIGHINGTICKET ADD (CREATIONWORKSTATION_ID NUMBER NULL);

CREATE INDEX XIF8WEIGHINGTICKET ON WEIGHINGTICKET (CREATIONWORKSTATION_ID ASC);

ALTER TABLE WEIGHINGTICKET
  ADD CONSTRAINT WEIGHINGTICKET_CREATIONWS FOREIGN KEY (CREATIONWORKSTATION_ID)
  REFERENCES WORKSTATION (WORKSTATION_ID) ON DELETE SET NULL;