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
BODYPARTS
Bpid
Bodyside (Bodyside)
Innerouter (Innerouter)
Bodyregion (Bodyregion)
Instances when a body
part was affected by
any wounds or any
pathologies
The body part that healed from
a specific wound or pathology
HealStatus * (HealStatus)
Notes (HealNotes)
Date (HealDate)
WPAId
WPDId
WPRId
WPHId (WPHId)
WP_HEALUPDATES
The related
wound/
pathology
cluster
Specifics
about
this body
part
Quantity_Affecting_Part (Quantity_Affecting_Part)
Bodypart* (Bodypart)
WPDId
WPAId (WPAId)
WP_AFFECTEDPARTS
Heal updates for the wound or
pathology affecting this body part
The report where
these data were
recorded
Body parts affected in this cluster
InfectionSigns (InfectionSigns)
Notes (DetailNotes)
ImpairsLocomotion (ImpairsLocomotion)
MaxDimension (MaxDimension)
Cluster (Cluster)
WoundPathCode * (WoundPathCode)
WP_DETAILS
WPRId
WPDId (WPDId)
The observers
in this record
The wounds
and pathologies
recorded on
this report
ObserverComments (ObserverComments)
WP_REPORTS
WId (WId)
ReportState* (ReportState)
Date (ReportDate)
Grp (Grp)
Sname (Sname)
Time (ReportTime)
WPRId (WPRId)