/* TABELA Credito Portal SDX */

CREATE TABLE CREDITOPORTALSDX
(
CDCLIENTE      VARCHAR(21)  NOT NULL,
CDCONSUMIDOR   VARCHAR(21)  NOT NULL,
CDFAMILISALD   VARCHAR(3)   NOT NULL,
DTCREDITO      DATE         NOT NULL,
VRCREDITO      FLOAT        NOT NULL,
DSOBSERVACAO   VARCHAR(20)  NOT NULL,
IDSIT          VARCHAR(1)   NOT NULL
    CONSTRAINT CKC_IDSIT check (IDSIT in ('I','A','N')),
DTATUALIZACAO  DATE         NULL,
DSMOTIVONAOINC VARCHAR(100) NULL
)
/

-- VERSAO --
BEGIN ATUVEROBJ('ATUALIZACAO_ESTRUTURA_BD','0.00.000'); END;
/

