]> Raphaƫl G. Git Repositories - airbundle/blob - Resources/config/doctrine/Session.orm.yml
9631e932bcdb2d7dcb858d0d4b5b1814d87f589c
[airbundle] / 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 nullable: true
24 rainfall:
25 type: float
26 nullable: true
27 rainrisk:
28 type: float
29 nullable: true
30 realfeel:
31 type: float
32 nullable: true
33 realfeelmin:
34 type: float
35 nullable: true
36 realfeelmax:
37 type: float
38 nullable: true
39 temperature:
40 type: float
41 nullable: true
42 temperaturemin:
43 type: float
44 nullable: true
45 temperaturemax:
46 type: float
47 nullable: true
48 locked:
49 type: datetime
50 nullable: true
51 created:
52 type: datetime
53 updated:
54 type: datetime
55 oneToOne:
56 application:
57 targetEntity: Rapsys\AirBundle\Entity\Application
58 manyToOne:
59 location:
60 targetEntity: Rapsys\AirBundle\Entity\Location
61 inversedBy: sessions
62 slot:
63 targetEntity: Rapsys\AirBundle\Entity\Slot
64 inversedBy: sessions
65 oneToMany:
66 applications:
67 targetEntity: Rapsys\AirBundle\Entity\Application
68 mappedBy: session
69 uniqueConstraints:
70 date_location_slot:
71 columns: [ date, location_id, slot_id ]
72 indexes:
73 #XXX: used in SessionRepository::findAllPendingApplication
74 locked_date_begin_created:
75 columns: [ locked, date, begin, created ]
76 #XXX: used in SessionRepository::findBestApplicationById(s3)
77 application_locked_date_begin_slot_created:
78 columns: [ application_id, locked, date, begin, slot_id, created ]
79 #XXX: candidated in findAllPendingDailyWeather and findAllPendingHourlyWeather
80 location_date_begin_length_slot:
81 columns: [ location_id, date, begin, length, slot_id ]
82 # #XXX: tried for SessionRepository::findBestApplicationById(s2)
83 # location_slot_application_locked_date_begin:
84 # columns: [ location_id, slot_id, application_id, locked, date ]
85 # #XXX: tried for SessionRepository::findBestApplicationById(s3)
86 # application_locked_date:
87 # columns: [ application_id, locked, date ]
88 # #XXX: tried for SessionRepository::findBestApplicationById(s4)
89 # location_application_locked_date:
90 # columns: [ location_id, application_id, locked, date ]
91 lifecycleCallbacks:
92 preUpdate: ['preUpdate']