ALTER TABLE CP_CALL ADD (
  CUSTOMER_INTERLOCUTOR_CODE VARCHAR2(2) DEFAULT NULL NULL,
  PRIORITY_CODE NUMBER(10) DEFAULT NULL NULL, 
  PRODUCT_RESPONSABLE_CODE VARCHAR2(12) DEFAULT NULL NULL, 
  CUSTOMER_RESPONSABLE_CODE VARCHAR2(21) DEFAULT NULL NULL, 
  TEKNISA_INTERLOCUTOR_CODE VARCHAR2(12) DEFAULT NULL NULL, 
  PLANNED_VERSION VARCHAR2(50) DEFAULT NULL NULL, 
  PLANNED_VALUE NUMBER(10) DEFAULT NULL NULL, 
  RESPONSABLE_DIVISION_CODE NUMBER(10) DEFAULT NULL NULL
)
/
ALTER TABLE CP_CALL ADD CONSTRAINT FK_CP_CALL_CRM_PRIORI FOREIGN KEY (PRIORITY_CODE) REFERENCES CRM_PRIORIDADE(NRPRIORIDADE)
/
ALTER TABLE CP_CALL ADD CONSTRAINT FK_CP_CALL_OPER_RESP FOREIGN KEY (PRODUCT_RESPONSABLE_CODE) REFERENCES OPERADOR(CDOPERADOR)
/
ALTER TABLE CP_CALL ADD CONSTRAINT FK_CP_CALL_OPER_INTERLOC FOREIGN KEY (TEKNISA_INTERLOCUTOR_CODE) REFERENCES OPERADOR(CDOPERADOR)
/
ALTER TABLE CP_CALL ADD CONSTRAINT FK_CP_CALL_CLASSOPORT FOREIGN KEY (RESPONSABLE_DIVISION_CODE) REFERENCES CRM_CLASSOPORTUNI(NRSEQCLASSOPORT)

