Repository List / Contenido / utf8 / plugins / payments / sql / TOAST / transactions.sql @ r358

create table payments_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(),
	dtime timestamp not null default now(),
	status smallint not null default 0,
	provider text,
	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 text
);
CREATE INDEX payments_transactions_operations ON payments_transactions USING btree (provider, operation_id);
CREATE INDEX payments_transactions_orders ON payments_transactions USING btree (order_id);