ALTER TABLE FCT_PARAMETROGERAL ADD DSURLINTEGRACAOFM VARCHAR2(4000)
/

ALTER TABLE FCT_PARAMETROGERAL ADD NRTIPOLOCALCLIFM NUMBER
/

ALTER TABLE FCT_PARAMETROGERAL 
  ADD CONSTRAINT FK_FCM_TPLOCALCLI_FCT_PARGERAL FOREIGN KEY (NRTIPOLOCALCLIFM)
      REFERENCES FCM_TIPOLOCALCLI (NRTIPOLOCALCLI)
/

ALTER TABLE FCT_MODELOCONTRATO ADD IDINTEGRACAOFM VARCHAR2(1) DEFAULT 'N' NOT NULL
/

ALTER TABLE FCT_MODELOCONTRATO ADD CONSTRAINT CK_IDINTEGRACAOFM CHECK (IDINTEGRACAOFM IN ('S','N'))
/

ALTER TABLE FCT_MODELOCONTRATO ADD IDINTEGRALOCAISFM VARCHAR2(1) DEFAULT 'N' NOT NULL
/

ALTER TABLE FCT_MODELOCONTRATO ADD CONSTRAINT CK_IDINTEGRALOCAISFM CHECK (IDINTEGRALOCAISFM IN ('S','N'))
/

ALTER TABLE FCT_MODELOCONTRATO ADD IDINTEGRAMEDICAOFM VARCHAR2(1) DEFAULT 'N' NOT NULL
/

ALTER TABLE FCT_MODELOCONTRATO ADD CONSTRAINT CK_IDINTEGRAMEDICAOFM CHECK (IDINTEGRAMEDICAOFM IN ('S','N'))
/


-- ============================================================
--   Table: FCT_CONTRATO                                        
-- ============================================================

ALTER TABLE FCT_CONTRATO ADD IDINTEGRACAOFM VARCHAR2(1) DEFAULT 'N' NOT NULL
/

ALTER TABLE FCT_CONTRATO ADD CONSTRAINT CK_IDINTEGRACAOFM_CONT CHECK (IDINTEGRACAOFM IN ('S','N'))
/

ALTER TABLE FCT_CONTRATO ADD IDINTEGRALOCAISFM VARCHAR2(1) DEFAULT 'N' NOT NULL
/

ALTER TABLE FCT_CONTRATO ADD CONSTRAINT CK_IDINTEGRALOCAISFM_CONT CHECK (IDINTEGRALOCAISFM IN ('S','N'))
/

ALTER TABLE FCT_CONTRATO ADD IDINTEGRAMEDICAOFM VARCHAR2(1) DEFAULT 'N' NOT NULL
/

ALTER TABLE FCT_CONTRATO ADD CONSTRAINT CK_IDINTEGRAMEDICAOFM_CONT CHECK (IDINTEGRAMEDICAOFM IN ('S','N'))
/