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