/******************************************************************************/
/***               Generated by IBExpert 28/09/2021 08:20:40                ***/
/******************************************************************************/

/******************************************************************************/
/***      Following SET SQL DIALECT is just for the Database Comparer       ***/
/******************************************************************************/
SET SQL DIALECT 3;



/******************************************************************************/
/***                                 Tables                                 ***/
/******************************************************************************/

CREATE GENERATOR PQ_TAXASCARTOES;

CREATE TABLE TAXASCARTOES(
    ID                  INTEGER NOT NULL,
    IDFORMAPAGAMENTO    INT,
    DESCRICAOFORMA      VARCHAR(100),
    IDBANDEIRA          INT,
    BANDEIRA            VARCHAR(50),
    TIPO                INT,
    DESCTIPO            VARCHAR(20),
    IDTAXAPRAZO         INT,
    TAXAPRAZO           VARCHAR(50),
    DIASRECEBIMENTO     INT,
    TAXARECEBIMENTO     NUMERIC(12,2),
    IDBANCO             INT,
    DESCBANCO           VARCHAR(50),
    QUANTIDADEVEZES     VARCHAR(20),
    TAXAX               NUMERIC(12,2),
    RECEBIMENTOINTEGRAL VARCHAR(5),
    CONTROLE            VARCHAR(20)

);




/******************************************************************************/
/***                              Primary Keys                              ***/
/******************************************************************************/

ALTER TABLE TAXASCARTOES ADD CONSTRAINT PK_TAXASCARTOES PRIMARY KEY (ID);


/******************************************************************************/
/***                                Triggers                                ***/
/******************************************************************************/


SET TERM ^ ;



/******************************************************************************/
/***                          Triggers for tables                           ***/
/******************************************************************************/



/* Trigger: INSTAXASCARTOES */
CREATE OR ALTER TRIGGER INSTAXASCARTOES FOR TAXASCARTOES
ACTIVE BEFORE INSERT POSITION 0
as 
begin 
   new.ID=gen_id(PQ_TAXASCARTOES,1);
end
^


SET TERM ; ^  



/******************************************************************************/
/***                               Privileges                               ***/
/******************************************************************************/


