personal finance control engine
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 

16 lines
359 B

CREATE TABLE TRANSACTION (
ID char(64) NOT NULL,
TDATE date NOT NULL,
ACCOUNT_ID integer NOT NULL,
MEMO varchar(64) NOT NULL,
COUNTRY char(2),
OUTFLOW decimal(20,2),
INFLOW decimal(12,2),
OWNER_ID integer,
INSTALLMENT_NR integer,
INSTALLMENT_TT integer,
CREATED datetime NOT NULL,
UPDATED datetime
)
ENGINE = MergeTree
PRIMARY KEY (ID)