<?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="tippspiel.Mitspieler" table="MITSPIELER">

        <!-- ID generieren -->
        <id name="id" type="long" unsaved-value="null">
         <column name="ID" sql-type="bigint(20)" not-null="true"/>
         <generator class="native"/>
      </id>
        <!-- Name, email, passwort Mapping -->
        <property name="name">
            <column name="NAME" length="16" not-null="true"/>
        </property>
        <property name="email">
          <column name="EMAIL" length="16" not-null="true"/>
        </property>      
      <property name="passwort">
          <column name="PASSWORT" length="16" not-null="true"/>
        </property>
      
            
       <set name="tippgemeinschaften" inverse="true" lazy="true" cascade="all-delete-orphan">
            <key column="ADMIN_ID"/>
            <one-to-many class="Tippgemeinschaft"/>
         </set>
   </class>