ALTER TABLE ATTACHMENT ADD (
  RELEASE NUMBER(10) DEFAULT NULL NULL, 
  SUBRELEASE NUMBER(10) DEFAULT NULL NULL, 
  DEPLOY NUMBER(10) DEFAULT NULL NULL
)
/
ALTER TABLE ATTACHMENT ADD CONSTRAINT ATTACHMENT_RELEASE_FK FOREIGN KEY (RELEASE) REFERENCES RELEASE (ID)
/
ALTER TABLE ATTACHMENT ADD CONSTRAINT ATTACHMENT_SUBRELEASE_FK FOREIGN KEY (SUBRELEASE) REFERENCES SUBRELEASE (ID)
/
ALTER TABLE ATTACHMENT ADD CONSTRAINT ATTACHMENT_DEPLOY_FK FOREIGN KEY (DEPLOY) REFERENCES DEPLOY (ID)
/
ALTER TABLE ATTACHMENT ADD (
  RESOURCE_T NUMBER(10) DEFAULT NULL NULL
)
/
ALTER TABLE ATTACHMENT ADD CONSTRAINT ATTACHMENT_RESOURCE_T_FK FOREIGN KEY (RESOURCE_T) REFERENCES RESOURCE_T (ID)
/
ALTER TABLE ATTACHMENT ADD (
  SERVER NUMBER(10) DEFAULT NULL NULL
)
/
ALTER TABLE ATTACHMENT ADD CONSTRAINT ATTACHMENT_SERVER_FK FOREIGN KEY (SERVER) REFERENCES SERVER (ID)
/