init.sql

CREATE TABLE IF NOT EXISTS customers
(
    id INTEGER NOT NULL PRIMARY KEY,
    name VARCHAR(100) NOT NULL
);

CREATE TABLE IF NOT EXISTS balances
(
    customer_id INTEGER NOT NULL PRIMARY KEY,
    "limit" INTEGER NOT NULL,
    amount INTEGER NOT NULL,
    CONSTRAINT fk_balances_customers FOREIGN KEY (customer_id) REFERENCES customers(id)
);

CREATE TABLE IF NOT EXISTS transactions
(
    id SERIAL NOT NULL PRIMARY KEY,
    customer_id INTEGER NOT NULL,
    "type" CHAR(1) NOT NULL,
    amount INTEGER NOT NULL,
    description VARCHAR(10) NOT NULL,
    created_at BIGINT NOT NULL,
    CONSTRAINT fk_transactions_customers FOREIGN KEY (customer_id) REFERENCES customers(id)
);

CREATE INDEX IF NOT EXISTS IX_transactions_customer_id ON transactions(customer_id);

INSERT INTO customers VALUES(1, 'Mario Bros'    ) ON CONFLICT (id) DO NOTHING;
INSERT INTO customers VALUES(2, 'Luigi Bros'    ) ON CONFLICT (id) DO NOTHING;
INSERT INTO customers VALUES(3, 'Peach Princess') ON CONFLICT (id) DO NOTHING;
INSERT INTO customers VALUES(4, 'Bowser'        ) ON CONFLICT (id) DO NOTHING;
INSERT INTO customers VALUES(5, 'Yoshi'         ) ON CONFLICT (id) DO NOTHING;

INSERT INTO balances VALUES(1,   100000, 0)  ON CONFLICT (customer_id) DO NOTHING;
INSERT INTO balances VALUES(2,    80000, 0)  ON CONFLICT (customer_id) DO NOTHING;
INSERT INTO balances VALUES(3,  1000000, 0)  ON CONFLICT (customer_id) DO NOTHING;
INSERT INTO balances VALUES(4, 10000000, 0)  ON CONFLICT (customer_id) DO NOTHING;
INSERT INTO balances VALUES(5,   500000, 0)  ON CONFLICT (customer_id) DO NOTHING;