Repository List / Contenido / utf8 / plugins / monetaru / sql / TOAST / transactions.sql @ r328

create table monetaru_transactions
(
	id integer not null primary key default nextval('public.documents_id_seq'::text),
	class text not null,
	ctime timestamp not null default now(),
	mtime timestamp not null default now(),
	status smallint not null default 0,
	name text,
	account_id numeric,
	order_id integer not null,
	operation_id numeric not null,
	currency_code varchar(4),
	sum float,
	account_user text,
	payment_system text,
	account_corr text,
	data
);
CREATE INDEX monetaru_transactions_operations ON monetaru_transactions USING btree (operation_id);
CREATE INDEX monetaru_transactions_orders ON monetaru_transactions USING btree (order_id);