ALTER TABLE FCT_CONTRATODOC ADD IDDOCUMCERTSIGN VARCHAR2(500)
/

ALTER TABLE FCT_CONTRATODOC ADD CHAVEDOCUMCERTSIGN VARCHAR2(500)
/

ALTER TABLE FCT_CONTRATODOC DROP CONSTRAINT CK_IDSITUACAOCONTRATO_CON
/
  
ALTER TABLE FCT_CONTRATODOC ADD CONSTRAINT CK_IDSITUACAOCONTRATO_CON CHECK (IDSITUACAOCONTRATO  IN ('P','A','R','C', 'E','D'))
/

ALTER TABLE FCT_ORCAMENTODOC ADD IDDOCUMCERTSIGN VARCHAR2(500)
/

ALTER TABLE FCT_ORCAMENTODOC ADD CHAVEDOCUMCERTSIGN VARCHAR2(500)
/

ALTER TABLE FCT_ASSINATDIGITALPROP ADD IDSIGNATCERTSIGN VARCHAR2(500)
/

ALTER TABLE FCT_ASSINATDIGITALPROP ADD DSJUSTIFICARECUSA VARCHAR2(4000)
/

ALTER TABLE FCT_ASSINATDIGITALCONTR ADD IDSIGNATCERTSIGN VARCHAR2(500)
/

ALTER TABLE FCT_ASSINATDIGITALCONTR ADD DSJUSTIFICARECUSA VARCHAR2(4000)
/

ALTER TABLE FCT_CONTRATO DROP CONSTRAINT CK_IDSITUACAOCONTRATO_CONTR
/
  
ALTER TABLE FCT_CONTRATO ADD CONSTRAINT CK_IDSITUACAOCONTRATO_CONTR CHECK (IDSITUACAOCONTRATO  IN ('P','A','R','C', 'E','D'))
/

ALTER TABLE FCT_MODELODOCCONTR DROP CONSTRAINT CK_IDSITUACAOCONTRATO_DOC
/

ALTER TABLE FCT_MODELODOCCONTR ADD CONSTRAINT CK_IDSITUACAOCONTRATO_DOC CHECK (IDSITUACAOCONTRATO  IN ('P','A','R','C', 'E','D'))
/