Raphaël G. Git Repositories - airbundle/blob - Resources/config/doctrine/Session.orm.yml

   1 Rapsys\AirBundle\Entity\Session:
   2     type: entity
   3     repositoryClass: Rapsys\AirBundle\Repository\SessionRepository
   4     table: sessions
   5     id:
   6         id:
   7             type: integer
   8             generator:
   9                 strategy: AUTO
  10             options:
  11                 unsigned: true
  12     fields:
  13         date:
  14             type: date
  15         begin:
  16             type: time
  17             nullable: true
  18         length:
  19             type: time
  20             nullable: true
  21         premium:
  22             type: boolean
  23         rainfall:
  24             type: float
  25             nullable: true
  26         rainrisk:
  27             type: float
  28             nullable: true
  29         realfeel:
  30             type: float
  31             nullable: true
  32         realfeelmin:
  33             type: float
  34             nullable: true
  35         realfeelmax:
  36             type: float
  37             nullable: true
  38         temperature:
  39             type: float
  40             nullable: true
  41         temperaturemin:
  42             type: float
  43             nullable: true
  44         temperaturemax:
  45             type: float
  46             nullable: true
  47         locked:
  48             type: datetime
  49             nullable: true
  50         created:
  51             type: datetime
  52         updated:
  53             type: datetime
  54     oneToOne:
  55         application:
  56             targetEntity: Rapsys\AirBundle\Entity\Application
  57     manyToOne:
  58         location:
  59             targetEntity: Rapsys\AirBundle\Entity\Location
  60             inversedBy: sessions
  61         slot:
  62             targetEntity: Rapsys\AirBundle\Entity\Slot
  63             inversedBy: sessions
  64     oneToMany:
  65         applications:
  66             targetEntity: Rapsys\AirBundle\Entity\Application
  67             mappedBy: session
  68     uniqueConstraints:
  69         date_location_slot:
  70             columns: [ date, location_id, slot_id ]
  71     indexes:
  72         #XXX: used in SessionRepository::findAllPendingApplication
  73         locked_date_begin_created:
  74             columns: [ locked, date, begin, created ]
  75         #XXX: used in SessionRepository::findBestApplicationById(s3)
  76         application_locked_date_begin_slot_created:
  77             columns: [ application_id, locked, date, begin, slot_id, created ]
  78         #XXX: candidated in findAllPendingDailyWeather and findAllPendingHourlyWeather
  79         location_date_begin_length_slot:
  80             columns: [ location_id, date, begin, length, slot_id ]
  81 #        #XXX: tried for SessionRepository::findBestApplicationById(s2)
  82 #        location_slot_application_locked_date_begin:
  83 #            columns: [ location_id, slot_id, application_id, locked, date ]
  84 #        #XXX: tried for SessionRepository::findBestApplicationById(s3)
  85 #        application_locked_date:
  86 #            columns: [ application_id, locked, date ]
  87 #        #XXX: tried for SessionRepository::findBestApplicationById(s4)
  88 #        location_application_locked_date:
  89 #            columns: [ location_id, application_id, locked, date ]