Database modules can be configured in the database.xml. If the APP is updated, the database is updated as well. The version of the database must increased, or the data can not be transfered and the table can not be created.
<?xml
version="1.0" encoding="utf-8"?> <!-- dadabase definition
--> <!-- version After the definition of field, the
version should be revised if the fields are added or deleted. And the SDK
can automatically reinitialize the database on the basis of the new
version
--> <Database name="Cashier.db" defaultTable="transaction_data" version="1" > <!--
transation data saved --> <!-- primaryKey should be defined in the first
field --> <table
name="transaction_data"
primaryKey="id" >
<field
name="id" /> <!-- major key, It is a self-propagation
interger
-->
<field
name="referenceNo" /> <!-- Reference
Number ,It
may has multiple numbers
-->
<field
name="trace" /> <!-- serial number -->
<field
name="merchant_name" /> <!-- merchant name -->
<field
name="merchant_no" /> <!-- mechant number -->
<field
name="terminal_no" /> <!-- terminal number -->
<field
name="pay_type" /> <!-- type of payment, bank card or mobile
payment -->
<field
name="func" /> <!-- transation type: purchase, revocation or
return -->
<field
name="card_number" /> <!-- card number -->
<field
name="operatorNo" /> <!-- operator number -->
<field
name="exp_date" /> <!-- expire data -->
<field
name="batch_no" /> <!-- batch number -->
<field
name="auth_no" /> <!-- authorization number -->
<field
name="date_time" /> <!-- transaction time -->
<field
name="amount" /> <!-- amount -->
<field
name="ticket_no" /> <!-- ticket number -->
<field
name="iss_desc" /> <!-- -->
<field
name="issuerId2" /> <!-- issuer card ID -->
<field
name="app_lab" /> <!-- APP LAB -->
<field
name="maskedPan" /> <!-- maskedPan
-->
<field
name="atc" /> <!-- ATC -->
<field
name="aid" /> <!-- AID -->
<field
name="csn" /> <!-- CSN -->
<field
name="iad" /> <!-- IAD -->
<field
name="tc" /> <!-- TC -->
<field
name="aip" /> <!-- AIP -->
<field
name="cardtype" /> <!-- card type. bank card:magnetci card, IC, RF
Mobile payment: wechat ,alipay -->
<field
name="qrcode" /> <!-- two-dimension code, it will be returned
during mobile payment -->
<field
name="status" /> <!-- the current state of transation:normal,been revoked,
been returned -->
<field
name="oldreferenceNo" /> <!-- the old reference Number -->
<field
name="oldtrace" /> <!-- the old serial number -->
</table> </Database> |