Project

General

Profile

Specification » History » Version 6

chin-yeh, 09/05/2011 10:43 AM

1 1 chin-yeh
{{toc}}
2
3
h1. Specification
4
5 5 chin-yeh
h2. Activity Diagram
6
7
* [[Activity Diagram - Sales]]
8
* [[Activity Diagram - Return/Exchange]]
9
* [[Activity Diagram - VIP Upgrade]]
10
11 6 chin-yeh
h2. Transaction Code
12
13
!dp_transaction_code.jpg!
14
15
16 3 chin-yeh
h2. Table Schema
17 1 chin-yeh
18
h3. DP_INTERFACE
19 3 chin-yeh
20
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.
21 1 chin-yeh
22
<pre>
23
<code class="SQL">
24
create table dp_interface (
25
	id int not null generated always as identity,
26 2 chin-yeh
	process_code varchar(30),
27 1 chin-yeh
	trx_id varchar(30) not null,
28
	trx_type varchar(15),
29 2 chin-yeh
	country_code varchar(10),
30 4 chin-yeh
	member_name varchar(100),
31 2 chin-yeh
	member_id varchar(20),
32 4 chin-yeh
	new_member_id varchar(20),
33 2 chin-yeh
	trx_date varchar(8),
34
	dp_amount decimal(10,2),
35
	invoice_amount decimal(10,2),
36 1 chin-yeh
	status varchar(15),
37
	last_updated timestamp,
38
	error_code varchar(10),
39
	error_message varchar(255),
40
	primary key (id)
41
);
42
43 2 chin-yeh
create unique index idx_dp_id_type on dp_interface(trx_id,trx_type);
44 1 chin-yeh
create index idx_dp_status on dp_interface(status);
45
create index idx_dp_err_code on dp_interface(error_code);
46
</code>
47
</pre>