hbm arre

<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"
"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd">
<!-- Generated 28-ott-2009 12.31.42 by Hibernate Tools 3.2.4.GA -->
<hibernate-mapping  schema="BALNEAZIONE">
    <class name="it.ipzs.acque.domain.balneazione.AreeInterdette" table="aree_interdette">
        <id name="codice" type="java.lang.Integer">
            <column name="CODICE" />
            <generator class="sequence">
			    <param name="sequence">SEQ_AREE_INTERDETTE</param>
			</generator>
        </id>

        <many-to-one name="comuni" class="it.ipzs.acque.domain.balneazione.Comuni" fetch="select">
            <column name="COD_COM" length="6" not-null="true" />
        </many-to-one>
        <many-to-one name="tipoInterdizione" class="it.ipzs.acque.domain.balneazione.TipoInterdizione" fetch="select">
            <column name="TIPO" length="1" />
        </many-to-one>
        <many-to-one name="classiInterdizione" class="it.ipzs.acque.domain.balneazione.ClassiInterdizione" fetch="select">
            <column name="CLASSE" length="1" />
        </many-to-one>
        <many-to-one name="regioni" class="it.ipzs.acque.domain.balneazione.Regioni" fetch="select">
            <column name="COD_REG" length="3" not-null="true" />
        </many-to-one>
       <set name="puntiPrelievo" table="AREE_INTERD_PT_PRELIEVO_ASS"  fetch="select">
            <key>
                <column name="ID_AREE_INTERDETTE"  />
            </key>
            <many-to-many  entity-name="it.ipzs.acque.domain.balneazione.PuntiPrelievo" >
                <column name=" ID_PT_PRELIEVO" not-null="false" />
            </many-to-many>
        </set>
        <set name="analisiFallite" table="AREE_INTERD_ANALISI_PP_ASS"  fetch="select">
            <key>
                <column name="ID_AREE_INTERDETTE"  />
            </key>
            <many-to-many  entity-name="it.ipzs.acque.domain.balneazione.AnalisiPtPrelievo" >
                <column name=" ID_ANALISI_PP" not-null="false" />
            </many-to-many>
        </set>



        <many-to-one name="province" class="it.ipzs.acque.domain.balneazione.Province" fetch="select">
            <column name="COD_PRO" length="3" not-null="true" />
        </many-to-one>
        <property name="note" type="string">
            <column name="note" length="65535" />
        </property>


        <property name="nome" type="string">
            <column name="nome" length="150" not-null="true" />
        </property>
        <property name="anno" type="int">
            <column name="anno" not-null="true" />
        </property>
         <property name="punto_ini_costa" type="string">
            <column name="PUNTO_INI_COSTA" length="12" />
        </property>
         <property name="punto_fin_costa" type="string">
            <column name="PUNTO_FIN_COSTA" length="12" />
        </property>
        <property name="dataAcquisizione" type="java.sql.Date">
            <column name="DATA_ACQUISIZIONE"/>
        </property>
        <property name="dataInterdizione" type="java.sql.Date">
            <column name="dataInterdizione" not-null="true" />
        </property>
        <property name="dataRiapertura" type="java.sql.Date">
            <column name="dataRiapertura"  />
        </property>

        <set name="bollettini" table="BOLLETTINI" fetch="select" lazy="true" cascade="all, delete-orphan" inverse="true" >
            <key>
                <column name="AREA" not-null="true"/>
            </key>
            <one-to-many class="it.ipzs.acque.domain.balneazione.Bollettini"/>
        </set>

    </class>
</hibernate-mapping>