deploy/transactions@v1.0.0-alpha.1.sql


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

-- Deploy kakeibo:transactions to pg
-- requires: schema

BEGIN;

CREATE TABLE kakeibo.transactions (
  id SERIAL PRIMARY KEY,
  type_code INTEGER,
  date DATE NOT NULL,
  note TEXT,
  created_at TIMESTAMP NOT NULL DEFAULT NOW(),
  updated_at TIMESTAMP NOT NULL DEFAULT NOW()
);

COMMIT;