Previous topicNext topic
 XXXX Help
Help > Modules > database module >

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>