From de643e8782c46055fb328fe13203cc84e408c44b Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Fri, 5 Jun 2026 20:08:52 +0000 Subject: [PATCH] Document the sdb_other_species event type's validation rules --- doc/src/tables/events.m4 | 20 +++++++++++++++++++- doc/src/tables/species_present.m4 | 4 ++-- 2 files changed, 21 insertions(+), 3 deletions(-) diff --git a/doc/src/tables/events.m4 b/doc/src/tables/events.m4 index 7bbec4b..5badfc2 100644 --- a/doc/src/tables/events.m4 +++ b/doc/src/tables/events.m4 @@ -347,7 +347,25 @@ The following table lists these rules and implications: .. _EVENTS_other_species_code: ``sdb_other_species`` (Other Species) - A row must exist on SPECIES_PRESENT and/or on HUMANS. + The EVENTS row must be associated with a follow. + This means the |EVENTS.FID| column must not be |null|. + + A related row should exist on either |SPECIES_PRESENT| or on + |HUMANS|. + This means, there should either be a row on |HUMANS| with an + |HUMANS|.\ |HUMANS.EID| value of the event's |EVENTS.EID|, or there + should be a row on |SPECIES_PRESENT| with a |SPECIES_PRESENT|.\ + |SPECIES_PRESENT.EID| value of the event's |EVENTS.EID|. + The system will generate a warning when there is neither a |HUMANS| + nor a |SPECIES_PRESENT| row related to this type of event. + There can be at most one of these related |HUMANS| or + |SPECIES_PRESENT| rows. + + There can be no |ROLES| rows related to the event. + + For other species events, the |EVENTS|.\ |EVENTS.Certainty| column + must be ``sdb_identity_certain``. + .. _EVENTS_pantgrunt_code: diff --git a/doc/src/tables/species_present.m4 b/doc/src/tables/species_present.m4 index db94093..bbd823c 100644 --- a/doc/src/tables/species_present.m4 +++ b/doc/src/tables/species_present.m4 @@ -31,8 +31,8 @@ SPECIES_PRESENT The related |EVENTS| row must must be one that records the presence of other species; the |EVENTS| row with an |EVENTS.EID| value that -matches the SPECIES_PRESENT row's |SPECIES_PRESENT.EID| value must have an |EVENTS|\ -.|EVENTS.Behavior| value of ``sdb_other_species``. +matches the SPECIES_PRESENT row's |SPECIES_PRESENT.EID| value must +have an |EVENTS|\ .|EVENTS.Behavior| value of ``sdb_other_species``. .. contents:: :depth: 2 -- 2.34.1