TavernerPOS - Source Code
Clone:
git clone http://www.librarysmith.co.uk/tavernerPOS
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN" "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<hibernate-mapping package="com.floreantpos.model">
<class lazy="false" name="com.floreantpos.model.PosTransaction" table="TRANSACTIONS">
<id column="ID" name="id" type="java.lang.Integer">
<generator class="identity" />
</id>
<discriminator column="PAYMENT_TYPE" length="30" type="string" />
<property column="TRANSACTION_TIME" length="10" name="transactionTime" type="java.util.Date" />
<property column="AMOUNT" length="52" name="amount" type="java.lang.Double" />
<property column="TIPS_AMOUNT" length="52" name="tipsAmount" type="java.lang.Double" />
<property column="TENDER_AMOUNT" length="52" name="tenderAmount" type="java.lang.Double" />
<property column="TRANSACTION_TYPE" name="transactionType" type="string" length="20" not-null="true"/>
<property column="PAYMENT_SUB_TYPE" name="paymentType" type="string" length="40" not-null="true"/>
<property column="CAPTURED" name="captured" type="java.lang.Boolean" />
<property column="AUTHORIZABLE" name="authorizable" type="java.lang.Boolean" />
<!-- card -->
<property column="CARD_TRACK" length="1000" name="cardTrack" type="string" />
<property column="CARD_NUMBER" length="40" name="cardNumber" type="string" />
<property column="CARD_AUTH_CODE" length="30" name="cardAuthCode" type="string" />
<property column="CARD_TYPE" length="20" name="cardType" type="string" />
<property column="CARD_TRANSACTION_ID" name="cardTransactionId" type="string" length="255" />
<property column="CARD_MERCHANT_GATEWAY" name="cardMerchantGateway" type="string" length="60" />
<property column="CARD_EXP_MONTH" name="cardExpiryMonth" type="string" length="16" />
<property column="CARD_EXP_YEAR" name="cardExpiryYear" type="string" length="4" />
<property column="CARD_READER" name="cardReader" type="string" length="20" />
<!-- GIFT CERT SPECIFIC -->
<property column="GIFT_CERT_NUMBER" name="giftCertNumber" type="string" length="64"/>
<property column="GIFT_CERT_FACE_VALUE" name="giftCertFaceValue" type="java.lang.Double" />
<property column="GIFT_CERT_PAID_AMOUNT" name="giftCertPaidAmount" type="java.lang.Double" />
<property column="GIFT_CERT_CASH_BACK_AMOUNT" name="giftCertCashBackAmount" type="java.lang.Double" />
<!-- a transaction is marked as settled when drawer is resetted -->
<property column="DRAWER_RESETTED" index="tran_drawer_resetted" name="drawerResetted" type="java.lang.Boolean" />
<property column="NOTE" name="note" length="255" type="string" />
<map name="properties" cascade="all" lazy="false" table="TRANSACTION_PROPERTIES">
<key column="id" />
<index column="property_name" type="string" />
<element column="property_value" type="string" />
</map>
<!-- Associations -->
<!-- uni-directional many-to-one association to Terminal -->
<many-to-one class="com.floreantpos.model.Terminal" name="terminal" cascade="none">
<column name="TERMINAL_ID" />
</many-to-one>
<!-- uni-directional one-to-one association to Ticket -->
<many-to-one class="com.floreantpos.model.Ticket" name="ticket">
<column name="TICKET_ID" />
</many-to-one>
<!-- uni-directional many-to-one association to User -->
<many-to-one class="com.floreantpos.model.User" name="user">
<column name="USER_ID" />
</many-to-one>
<many-to-one class="com.floreantpos.model.PayoutReason" lazy="false" name="reason">
<column name="PAYOUT_REASON_ID" />
</many-to-one>
<many-to-one class="com.floreantpos.model.PayoutRecepient" lazy="false" name="recepient">
<column name="PAYOUT_RECEPIENT_ID" />
</many-to-one>
<subclass discriminator-value="CASH" name="com.floreantpos.model.CashTransaction">
</subclass>
<subclass discriminator-value="GIFT_CERT" name="com.floreantpos.model.GiftCertificateTransaction">
</subclass>
<subclass discriminator-value="CREDIT_CARD" name="com.floreantpos.model.CreditCardTransaction">
</subclass>
<subclass discriminator-value="DEBIT_CARD" name="com.floreantpos.model.DebitCardTransaction">
</subclass>
<subclass discriminator-value="CASH_DROP" name="com.floreantpos.model.CashDropTransaction">
</subclass>
<subclass discriminator-value="REFUND" name="com.floreantpos.model.RefundTransaction">
</subclass>
<subclass discriminator-value="PAY_OUT" name="com.floreantpos.model.PayOutTransaction">
</subclass>
<subclass discriminator-value="VOID_TRANS" name="com.floreantpos.model.VoidTransaction">
</subclass>
</class>
</hibernate-mapping>
- Details
- Last Updated: Monday, 04 April 2016 02:04
- Hits: 39816167