-- 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;