-- ABS-137846

ALTER TABLE CLEANROOMBATCHCUSTOMER
  ADD (CREATIONREASONCODE_ID NUMBER DEFAULT NULL,
     CUSTOMER_LINK_ID NUMBER DEFAULT NULL);
  
  
ALTER TABLE CLEANROOMBATCHCUSTOMER 
ADD CONSTRAINT FK_CLEANROOMBATCHCUSTOMER_CREATIONREASONCODE_ID FOREIGN KEY (CREATIONREASONCODE_ID) 
REFERENCES REASONCODE (REASONCODE_ID) ON DELETE SET NULL;

ALTER TABLE CLEANROOMBATCHCUSTOMER 
ADD CONSTRAINT FK_CLEANROOMBATCHCUSTOMER_CUSTOMER_LINK_ID FOREIGN KEY (CUSTOMER_LINK_ID) 
REFERENCES CUSTOMER_LINK (CUSTOMER_LINK_ID);
