@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Stargazing nights of the observatory'
define view entity {{P}}I_STAR_NIGHT
  as select from {{p}}night as night
    left outer join {{p}}dome as dome on dome.dome_id = night.dome_id
    inner join {{p}}scope as scope on scope.scope_id = night.scope_id
{
  key night.night_id                                as night_id,
      night.dome_id                                 as dome_id,
      dome.dome_name                                as dome_name,
      dome.city                                     as dome_city,
      night.scope_id                                as scope_id,
      scope.scope_name                              as scope_name,
      scope.aperture_mm                             as aperture_mm,
      night.visitors                                as visitors,
      night.night_date                              as night_date,
      dome.capacity - night.visitors                as free_seats
}