Project

General

Profile

Specification » History » Revision 6

Revision 5 (chin-yeh, 08/26/2011 05:20 PM) → Revision 6/7 (chin-yeh, 09/05/2011 10:43 AM)

{{toc}} 

 h1. Specification 

 h2. Activity Diagram 

 * [[Activity Diagram - Sales]] 
 * [[Activity Diagram - Return/Exchange]] 
 * [[Activity Diagram - VIP Upgrade]] 

 h2. Transaction Code 

 !dp_transaction_code.jpg! 


 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>