<?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.Device" 
    table="device"
>

    <id
        name="deviceNo"
        type="java.lang.String"
        column="DEVICE_NO"
    >
        <generator class="native" />
    </id>

    <property
        name="deviceTypeId"
        type="byte"
        column="DEVICE_TYPE_ID"
        not-null="true"
        length="4"
    />
    <property
        name="deviceName"
        type="java.lang.String"
        column="DEVICE_NAME"
        length="30"
    />
    <property
        name="deviceModel"
        type="java.lang.String"
        column="DEVICE_MODEL"
        length="30"
    />
    <property
        name="producingArea"
        type="java.lang.String"
        column="PRODUCING_AREA"
        length="100"
    />
    <property
        name="manufacturer"
        type="java.lang.String"
        column="MANUFACTURER"
        length="100"
    />
    <property
        name="deviceAssetValue"
        type="java.math.BigDecimal"
        column="DEVICE_ASSET_VALUE"
        length="10"
    />
    <property
        name="operInstruction"
        type="java.lang.String"
        column="OPER_INSTRUCTION"
        length="500"
    />

    <!-- Associations -->
  

</class>
</hibernate-mapping>