<?xml version="1.0"?>
<!DOCTYPE hibernate-mapping
    PUBLIC "-//Hibernate/Hibernate Mapping DTD//EN"
    "http://hibernate.sourceforge.net/hibernate-mapping-2.0.dtd">

<hibernate-mapping>

    <class name="SupportClient" table="SupportClient">

        <id name="numeroSupport" type="int">
            <column name="numerosupport" sql-type="smallint" not-null="true"/>
            <generator class="uuid.hex"/>
        </id>
       
        <property name="numeroClient"  type="int">
            <column name="numeroclient" sql-type="smallint"/>
        </property>

        <property name="numeroDevis"  type="int">
            <column name="numerodevis" sql-type="smallint"/>
        </property>
       
        <property name="observation"  type="string">
            <column name="observation" sql-type="varchar(255)"/>
        </property>
       
        <many-to-one name="typeSupport" class="TypeSupport" column="support"/>
       
    </class>
   
    <class name="TypeSupport" table="TypeSupport">

        <id name="code" type="int">
            <column name="codetypesupport" sql-type="smallint" not-null="true"/>
            <generator class="native"/>
        </id>
       
        <property name="designation"  type="string">
            <column name="libelletypesupport" sql-type="varchar(50)"/>
        </property>
       
    </class>

</hibernate-mapping>