Model.Entity.CompetencySet.dcm.xml

<?xml version="1.0" encoding="utf-8"?>
<doctrine-mapping xmlns="http://doctrine-project.org/schemas/orm/doctrine-mapping" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://doctrine-project.org/schemas/orm/doctrine-mapping http://doctrine-project.org/schemas/orm/doctrine-mapping.xsd">
  <entity repository-class="Model\Repository\CompetencySetRepository" name="Model\Entity\CompetencySet" table="competency_sets">
    <id name="id" type="integer" column="id">
      <generator strategy="IDENTITY"/>
    </id>
    <field name="name" type="string" column="name" precision="0" scale="0" nullable="false"/>
    <field name="description" type="string" column="description" precision="0" scale="0" nullable="false"/>
    <many-to-many field="competencies" target-entity="Model\Entity\Competency" fetch="LAZY">
      <join-table name="competencyset_competency">
        <join-columns>
          <join-column name="competencyset_id" referenced-column-name="id" on-delete="CASCADE"/>
        </join-columns>
        <inverse-join-columns>
          <join-column name="competency_id" referenced-column-name="id" on-delete="CASCADE"/>
        </inverse-join-columns>
      </join-table>
    </many-to-many>
  </entity>
</doctrine-mapping>