vendor/doctrine/orm/tests/Doctrine/Tests/ORM/Mapping/yaml/Doctrine.Tests.Models.Company.CompanyPerson.dcm.yml

   1 Doctrine\Tests\Models\Company\CompanyPerson:
   2   type: entity
   3   table: company_persons
   4   inheritanceType: JOINED
   5   discriminatorMap:
   6     person: CompanyPerson
   7     manager: CompanyManager
   8     employee: CompanyEmployee
   9   namedNativeQueries:
  10     fetchAllWithResultClass:
  11       resultClass: __CLASS__
  12       query: SELECT id, name, discr FROM company_persons ORDER BY name
  13     fetchAllWithSqlResultSetMapping:
  14       name: fetchAllWithSqlResultSetMapping
  15       resultSetMapping: mappingFetchAll
  16       query: SELECT id, name, discr AS discriminator FROM company_persons ORDER BY name
  17
  18   sqlResultSetMappings:
  19     mappingFetchAll:
  20       entityResult:
  21         0:
  22           entityClass: __CLASS__
  23           discriminatorColumn: discriminator
  24           fieldResult:
  25             0:
  26               name: id
  27             1:
  28               name: name
  29   id:
  30     id:
  31       type: integer
  32       generator:
  33         strategy: AUTO
  34   fields:
  35     name:
  36       type: string
  37       length: 255
  38     username:
  39       type: string
  40       length: 255
  41       unique: true
  42     status:
  43       type: string
  44       length: 50
  45       unique: true
  46   oneToOne:
  47     address:
  48       targetEntity: CmsAddress
  49       orphanRemoval: true
  50       inversedBy: user
  51       joinColumn:
  52         name: address_id
  53         referencedColumnName: id
  54       cascade: [ persist ]
  55   oneToOne:
  56     email:
  57       targetEntity: CmsEmail
  58       orphanRemoval: true
  59       inversedBy: user
  60       joinColumn:
  61         nullable: true
  62         referencedColumnName: id
  63       cascade: [ persist ]
  64   manyToMany:
  65     groups:
  66       targetEntity: CmsGroup
  67       joinTable:
  68         name: cms_users_groups
  69         joinColumns:
  70           user_id:
  71             referencedColumnName: id
  72         inverseJoinColumns:
  73           group_id:
  74             referencedColumnName: id
  75       cascade: [ persist , detach, merge]