Project

General

Profile

Actions

Specification » History » Revision 1

Revision 1/7 | Next »
chin-yeh, 08/02/2011 03:27 PM


Specification

Table(s) Used

DP_INTERFACE

create table dp_interface (
    id int not null generated always as identity,
    trx_id varchar(30) not null,
    trx_type varchar(15),
    status varchar(15),
    last_updated timestamp,
    error_code varchar(10),
    error_message varchar(255),
    primary key (id)
);

create unique index idx_dp_trx_id on dp_interface(trx_id);

create index idx_dp_status on dp_interface(status);
create index idx_dp_err_code on dp_interface(error_code);

Updated by chin-yeh over 13 years ago · 1 revisions