script.sql

CREATE UNLOGGED TABLE tb_cliente (
                            id BIGSERIAL PRIMARY KEY,
                            limite BIGINT NOT NULL,
                            saldo BIGINT NOT NULL
);

CREATE UNLOGGED TABLE tb_transacao (
                              id SERIAL PRIMARY KEY,
                              valor BIGINT NOT NULL,
                              tipo VARCHAR(255) NOT NULL,
                              descricao VARCHAR(255) NOT NULL,
                              realizada_em TIMESTAMP NOT NULL,
                              cliente_id BIGINT NOT NULL,
                              FOREIGN KEY (cliente_id) REFERENCES tb_cliente(id)
);

DO
$$
BEGIN
INSERT INTO tb_cliente (saldo, limite)
VALUES (0, 100000);
INSERT INTO tb_cliente (saldo, limite)
VALUES (0, 80000);
INSERT INTO tb_cliente (saldo, limite)
VALUES (0, 1000000);
INSERT INTO tb_cliente (saldo, limite)
VALUES (0, 10000000);
INSERT INTO tb_cliente (saldo, limite)
VALUES (0, 500000);
END;
$$;