<?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.ServicePlan" 
    table="service_plan"
>

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

    <property
        name="hospitalNo"
        type="int"
        column="HOSPITAL_NO"
        not-null="true"
        length="11"
    />
    <property
        name="memberId"
        type="long"
        column="MEMBER_ID"
        not-null="true"
        length="20"
    />
    <property
        name="subject"
        type="java.lang.String"
        column="SUBJECT"
        length="30"
    />
    <property
        name="memo"
        type="java.lang.String"
        column="MEMO"
        length="200"
    />
    <property
        name="serviceNotice"
        type="java.lang.String"
        column="SERVICE_NOTICE"
        length="500"
    />
    <property
        name="planCreatePerson"
        type="java.lang.String"
        column="PLAN_CREATE_PERSON"
        length="12"
    />
    <property
        name="planCreateDate"
        type="java.sql.Date"
        column="PLAN_CREATE_DATE"
        length="10"
    />
    <property
        name="optDatetime"
        type="java.sql.Timestamp"
        column="OPT_DATETIME"
        length="19"
    />
    <property
        name="editDate"
        type="java.sql.Timestamp"
        column="EDIT_DATE"
        length="19"
    />
    <property
        name="optId"
        type="java.lang.Integer"
        column="OPT_ID"
        length="11"
    />
    <property
        name="optName"
        type="java.lang.String"
        column="OPT_NAME"
        length="12"
    />

    <!-- Associations -->
  

</class>
</hibernate-mapping>