19 lines
981 B
Plaintext
19 lines
981 B
Plaintext
@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
|
|
inner 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
|
|
}
|