The record
from this
observer
(or these
observers)
* CONCAT_OBSERVERS is a
subquery from WP_OBSERVERS,
in which all Observer rows for a
WPRId are concatenated
(separated by a "/") into a
single string. It does not appear
anywhere as an independent
entity.
CONCAT_OBSERVERS*
STRING_AGG(observer, '/'
ORDER BY wpoid)
(Observers)
WPRId
WP_OBSERVERS
HealStatus * (HealStatus)
Notes (HealNotes)
Date (HealDate)
WPAId
WPDId
WPRId
WPHId (WPHId)
WP_HEALUPDATES
The record
being updated
The observers
in this record
The heal
updates
for this
record
ObserverComments (ObserverComments)
WP_REPORTS
WId (WId)
ReportState* (ReportState)
Date (ReportDate)
Grp (Grp)
Sname (Sname)
Time (ReportTime)
WPRId (WPRId)