1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
|
CREATE TABLE clients (
id SERIAL PRIMARY KEY,
name VARCHAR(50) NOT NULL,
mov_limit INTEGER NOT NULL
);
CREATE TYPE transaction_type AS ENUM ('credit', 'debit');
CREATE TABLE transactions (
id SERIAL PRIMARY KEY,
client_id INTEGER REFERENCES clients,
value INTEGER NOT NULL,
type transaction_type NOT NULL,
description VARCHAR(10) NOT NULL,
created_at TIMESTAMP NOT NULL DEFAULT NOW()
);
CREATE TABLE balances (
id SERIAL PRIMARY KEY,
client_id INTEGER REFERENCES clients,
value INTEGER NOT NULL
);
DO $$
BEGIN
INSERT INTO clients (name, mov_limit)
VALUES
('naruto', 1000 * 100),
('mob', 800 * 100),
('jojo', 10000 * 100),
('hellboy', 5000 * 100);
INSERT INTO balances (client_id, value)
SELECT id, 0 FROM clients;
END;
$$
|