• transactions.sql

    553 554  
    9 9 provider text,
    10 10 name text,
    11 11 account_id numeric,
    12 session_id text,
    12 13 order_id integer not null,
    13 14 operation_id numeric not null,
    14 15 currency_code varchar(4),
    … …  
    16 17 account_user text,
    17 18 payment_system text,
    18 19 account_corr text,
    20 success smallint default 1,
    19 21 data text
    20 22 );
    21 23 CREATE INDEX payments_transactions_operations ON payments_transactions USING btree (provider, operation_id);
    24 CREATE INDEX payments_transactions_sessions ON payments_transactions USING btree (provider, session_id) WHERE session_id is not null;
    22 25 CREATE INDEX payments_transactions_orders ON payments_transactions USING btree (order_id);