oracle 主外键关系处理

ALTER TABLE CHK_TC_PRODSEQ ADD CONSTRAINT FK_TC_OID_PRODSEQ FOREIGN KEY(TECHCHGOID) REFERENCES CHK_TC(OID);
ALTER TABLE CHK_REPLACE_BC ADD CONSTRAINT FK_REPLACE_BC_NCR FOREIGN KEY(BELONG_CODE) REFERENCES CHK_NCR(NCR_CODE);

ALTER TABLE CHK_THING_TODO ADD CONSTRAINT CONSTRAINT_BELONG_CODE UNIQUE (BELONG_CODE);

ALTER TABLE CHK_TC ADD CONSTRAINT CONSTRAINT_TC_OID UNIQUE (OID);

ALTER TABLE CHK_NCR ADD CONSTRAINT PK_NCR_CODE_OID PRIMARY KEY (NCR_CODE,OID);

alter table CHK_NCR drop constraint CHK_NCR_PK