<xsd:complexType name="EmployeeWithSecurityCard">
    <xsd:sequence>
      <xsd:element name="id" type="xsd:int">
        <xsd:annotation><xsd:appinfo source="teneo.jpa">@Id @GeneratedValue</xsd:appinfo></xsd:annotation>
      </xsd:element>
      <xsd:element name="firstName" type="xsd:string" />
      <xsd:element name="lastName" type="xsd:string" />
      <xsd:element name="securityCard" type="SecurityAccessCard" minOccurs="0" maxOccurs="1">
        <xsd:annotation><xsd:appinfo source="teneo.jpa">
          @OneToOne @JoinColumn(name="security_card", unique=true)
        </xsd:appinfo></xsd:annotation>
      </xsd:element>
    </xsd:sequence>
  </xsd:complexType>

  <xsd:complexType name="SecurityAccessCard">
    <xsd:sequence>
      <xsd:element name="accessCode" type="xsd:string" />
      <xsd:element name="expirationDate" type="xsd:dateTime" />
      <xsd:element name="id" type="xsd:int">
        <xsd:annotation><xsd:appinfo source="teneo.jpa">@Id @GeneratedValue</xsd:appinfo></xsd:annotation>
      </xsd:element>
      <xsd:element name="employee" type="EmployeeWithSecurityCard" ecore:opposite="securityCard" minOccurs="0" maxOccurs="1">
        <xsd:annotation><xsd:appinfo source="teneo.jpa">
          @OneToOne(mappedBy="securityCard")
        </xsd:appinfo></xsd:annotation>
      </xsd:element>
    </xsd:sequence>
  </xsd:complexType>

  <class entity-name="EmployeeWithSecurityCardDT3231" abstract="false" lazy="false" table="`employeewithsecuritycard`">
    <meta attribute="eclassName" inherit="false">EmployeeWithSecurityCardDT3231</meta>
    <meta attribute="epackage" inherit="false">urn:teneo:test:EntityMappingsProviderTest</meta>
    <id name="id" type="int" unsaved-value="0">
      <column not-null="true" unique="false" name="`id`"/>
      <generator class="native"/>
    </id>
    <property name="firstName" lazy="false" insert="true" update="true" not-null="true" unique="false" type="java.lang.String">
      <column not-null="true" unique="false" name="`firstname`"/>
    </property>
    <property name="lastName" lazy="false" insert="true" update="true" not-null="true" unique="false" type="java.lang.String">
      <column not-null="true" unique="false" name="`lastname`"/>
    </property>
    <many-to-one name="securityCard" entity-name="SecurityAccessCardDT3247" cascade="all" not-null="false" lazy="false" insert="true" update="true">
      <column not-null="false" unique="true" name="`security_card`"/>
    </many-to-one>
  </class>

  <class entity-name="SecurityAccessCardDT3247" abstract="false" lazy="false" table="`securityaccesscard`">
    <meta attribute="eclassName" inherit="false">SecurityAccessCardDT3247</meta>
    <meta attribute="epackage" inherit="false">urn:teneo:test:EntityMappingsProviderTest</meta>
    <id name="id" type="int" unsaved-value="0">
      <column not-null="true" unique="false" name="`id`"/>
      <generator class="native"/>
    </id>
    <property name="accessCode" lazy="false" insert="true" update="true" not-null="true" unique="false" type="java.lang.String">
      <column not-null="true" unique="false" name="`accesscode`"/>
    </property>
    <property name="expirationDate" lazy="false" insert="true" update="true" not-null="true" unique="false" type="org.eclipse.emf.teneo.hibernate.mapping.XSDDateTime">
      <column not-null="true" unique="false" name="`expirationdate`"/>
    </property>
    <one-to-one name="employee" entity-name="EmployeeWithSecurityCardDT3231" cascade="all" lazy="false" property-ref="securityCard"/>
  </class>