<?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.ServiceProtocol" 
    table="service_protocol"
>

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

    <property
        name="serviceProtocolNo"
        type="java.lang.String"
        column="SERVICE_PROTOCOL_NO"
        length="12"
    />
    <property
        name="memberId"
        type="long"
        column="MEMBER_ID"
        not-null="true"
        length="20"
    />
    <property
        name="orgNo"
        type="java.lang.Integer"
        column="ORG_NO"
        length="11"
    />
    <property
        name="protocolOwner"
        type="java.lang.Byte"
        column="PROTOCOL_OWNER"
        length="4"
    />
    <property
        name="hospitalNo"
        type="java.lang.Integer"
        column="HOSPITAL_NO"
        length="11"
    />
    <property
        name="protocolCostFees"
        type="java.math.BigDecimal"
        column="PROTOCOL_COST_FEES"
        length="10"
    />
    <property
        name="optId"
        type="java.lang.Integer"
        column="OPT_ID"
        length="11"
    />
    <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="createName"
        type="java.lang.String"
        column="CREATE_NAME"
        length="12"
    />
    <property
        name="createDate"
        type="java.sql.Date"
        column="CREATE_DATE"
        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"
    />
    <property
        name="memo"
        type="java.lang.String"
        column="MEMO"
        length="500"
    />

    <!-- Associations -->
  

</class>
</hibernate-mapping>