<?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>