script.sql

/*
 * Copyright (c) 2024.
 * Julio Cezar Riffel
 * https://www.linkedin.com/in/julio-cezar-riffel/
 * https://github.com/julioriffel
 */

BEGIN;

CREATE UNLOGGED TABLE "cliente"
(
    "id"     bigint  NOT NULL PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
    "limite" integer NOT NULL
);

CREATE UNLOGGED TABLE "transacao"
(
    "id"           bigint                   NOT NULL PRIMARY KEY GENERATED BY DEFAULT AS IDENTITY,
    "tipo"         varchar(1)               NOT NULL,
    "valor"        integer                  NOT NULL,
    "descricao"    varchar(10)              NOT NULL,
    "realizada_em" timestamp with time zone NOT NULL,
    "cliente_id"   bigint                   NOT NULL
);

INSERT INTO cliente (id, limite)
VALUES (1, 100000),
       (2, 80000),
       (3, 1000000),
       (4, 10000000),
       (5, 500000);


COMMIT;