Project

General

Profile

Specification » History » Version 3

chin-yeh, 08/10/2011 09:30 AM

1 1 chin-yeh
{{toc}}
2
3
h1. Specification
4
5 3 chin-yeh
h2. Table Schema
6 1 chin-yeh
7
h3. DP_INTERFACE
8 3 chin-yeh
9
This table stores those events which are needed to submit to DP services. It can also be used to track the status of the submitted events.
10 1 chin-yeh
11
<pre>
12
<code class="SQL">
13
create table dp_interface (
14
	id int not null generated always as identity,
15 2 chin-yeh
	process_code varchar(30),
16 1 chin-yeh
	trx_id varchar(30) not null,
17
	trx_type varchar(15),
18 2 chin-yeh
	country_code varchar(10),
19
	member_id varchar(20),
20
	trx_date varchar(8),
21
	dp_amount decimal(10,2),
22
	invoice_amount decimal(10,2),
23 1 chin-yeh
	status varchar(15),
24
	last_updated timestamp,
25
	error_code varchar(10),
26
	error_message varchar(255),
27
	primary key (id)
28
);
29
30 2 chin-yeh
create unique index idx_dp_id_type on dp_interface(trx_id,trx_type);
31 1 chin-yeh
create index idx_dp_status on dp_interface(status);
32
create index idx_dp_err_code on dp_interface(error_code);
33
</code>
34
</pre>