Project

General

Profile

Specification » History » Version 1

chin-yeh, 08/02/2011 03:27 PM

1 1 chin-yeh
{{toc}}
2
3
h1. Specification
4
5
h2. Table(s) Used
6
7
h3. DP_INTERFACE
8
9
<pre>
10
<code class="SQL">
11
create table dp_interface (
12
	id int not null generated always as identity,
13
	trx_id varchar(30) not null,
14
	trx_type varchar(15),
15
	status varchar(15),
16
	last_updated timestamp,
17
	error_code varchar(10),
18
	error_message varchar(255),
19
	primary key (id)
20
);
21
22
create unique index idx_dp_trx_id on dp_interface(trx_id);
23
24
create index idx_dp_status on dp_interface(status);
25
create index idx_dp_err_code on dp_interface(error_code);
26
</code>
27
</pre>