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