Postgres 14

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

select version();

version

PostgreSQL 14.9 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 8.5.0 20210514 (Red Hat 8.5.0-18), 64-bit

SELECT 1

CREATE TABLE IF NOT EXISTS vaults (
    id BIGSERIAL PRIMARY KEY,
    name VARCHAR(30) NOT NULL,
    identifier VARCHAR(6) NOT NULL
);

CREATE TABLE

INSERT INTO vaults (name, identifier) VALUES ('vault 1', 'v1');
INSERT INTO vaults (name, identifier) VALUES ('vault 2', 'v2');

INSERT 0 1

INSERT 0 1

SELECT * FROM vaults;

id
name
identifier

1
vault 1
v1

2
vault 2
v2

SELECT 2

CREATE TABLE IF NOT EXISTS transactions (
    id BIGSERIAL PRIMARY KEY,
    transaction_type VARCHAR(6) NOT NULL,
    amount NUMERIC(15,6) NOT NULL,
    vault_id BIGINT NOT NULL,
    FOREIGN KEY (vault_id) REFERENCES vaults (id)
);

CREATE TABLE

INSERT INTO transactions (transaction_type, amount, vault_id) VALUES ('credit', 100, 1);
INSERT INTO transactions (transaction_type, amount, vault_id) VALUES ('credit', 400, 1);
INSERT INTO transactions (transaction_type, amount, vault_id) VALUES ('debit', 200, 1);
INSERT INTO transactions (transaction_type, amount, vault_id) VALUES ('credit', 100, 1);

INSERT 0 1

INSERT 0 1

INSERT 0 1

INSERT 0 1

SELECT * FROM transactions;

id
transaction_type
amount
vault_id

1
credit
100.000000
1

2
credit
400.000000
1

3
debit
200.000000
1

4
credit
100.000000
1

SELECT 4

id	transaction_type	amount	vault_id
1	credit	100.000000	1
2	credit	400.000000	1
3	debit	200.000000	1
4	credit	100.000000	1