<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
                                   "http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
    
<hibernate-mapping>
<!-- 
    Created by the Middlegen Hibernate plugin 2.1

    http://boss.bekk.no/boss/middlegen/
    http://www.hibernate.org/
-->

<class 
    name="acorn.hibernate.ServiceItemChoose" 
    table="service_item_choose"
>

    <id
        name="serviceItemChoosedId"
        type="java.lang.Long"
        column="SERVICE_ITEM_CHOOSED_ID"
    >
        <generator class="native" />
    </id>

    <property
        name="serviceProtocolId"
        type="long"
        column="SERVICE_PROTOCOL_ID"
        not-null="true"
        length="20"
    />
    <property
        name="serviceItemNo"
        type="int"
        column="SERVICE_ITEM_NO"
        not-null="true"
        length="11"
    />
    <property
        name="strategyNo"
        type="java.lang.Long"
        column="STRATEGY_NO"
        length="20"
    />
    <property
        name="beginDate"
        type="java.sql.Date"
        column="BEGIN_DATE"
        length="10"
    />
    <property
        name="itemPeriods"
        type="java.lang.Integer"
        column="ITEM_PERIODS"
        length="11"
    />
    <property
        name="endDate"
        type="java.sql.Date"
        column="END_DATE"
        length="10"
    />
    <property
        name="strategyPrices"
        type="java.math.BigDecimal"
        column="STRATEGY_PRICES"
        length="10"
    />
    <property
        name="stateCode"
        type="java.lang.Byte"
        column="STATE_CODE"
        length="4"
    />
    <property
        name="stateName"
        type="java.lang.String"
        column="STATE_NAME"
        length="12"
    />

    <!-- Associations -->
  

</class>
</hibernate-mapping>