Specification » History » Revision 5
Revision 4 (chin-yeh, 08/19/2011 03:10 PM) → Revision 5/7 (chin-yeh, 08/26/2011 05:20 PM)
{{toc}}
h1. Specification
h2. Activity Diagram
* [[Activity Diagram - Sales]]
* [[Activity Diagram - Return/Exchange]]
* [[Activity Diagram - VIP Upgrade]]
h2. Table Schema
h3. DP_INTERFACE
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.
<pre>
<code class="SQL">
create table dp_interface (
id int not null generated always as identity,
process_code varchar(30),
trx_id varchar(30) not null,
trx_type varchar(15),
country_code varchar(10),
member_name varchar(100),
member_id varchar(20),
new_member_id varchar(20),
trx_date varchar(8),
dp_amount decimal(10,2),
invoice_amount decimal(10,2),
status varchar(15),
last_updated timestamp,
error_code varchar(10),
error_message varchar(255),
primary key (id)
);
create unique index idx_dp_id_type on dp_interface(trx_id,trx_type);
create index idx_dp_status on dp_interface(status);
create index idx_dp_err_code on dp_interface(error_code);
</code>
</pre>