<?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.ServiceItem" 
    table="service_item"
>

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

    <property
        name="hospitalNo"
        type="int"
        column="HOSPITAL_NO"
        not-null="true"
        length="11"
    />
    <property
        name="serviceItemName"
        type="java.lang.String"
        column="SERVICE_ITEM_NAME"
        not-null="true"
        length="30"
    />
    <property
        name="serviceItemDesc"
        type="java.lang.String"
        column="SERVICE_ITEM_DESC"
        length="100"
    />
    <property
        name="serviceItemPrice"
        type="java.lang.String"
        column="SERVICE_ITEM_PRICE"
        length="10"
    />
    <property
        name="optId"
        type="java.lang.String"
        column="OPT_ID"
        length="10"
    />
    <property
        name="optName"
        type="java.lang.String"
        column="OPT_NAME"
        length="12"
    />
    <property
        name="optDatetime"
        type="java.sql.Timestamp"
        column="OPT_DATETIME"
        length="19"
    />
    <property
        name="iflag"
        type="java.lang.Byte"
        column="IFLAG"
        length="4"
    />

    <!-- Associations -->
  

</class>
</hibernate-mapping>