From e71f2ee4099421f9b8a4a00a5b50a551976c0902 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Thu, 28 May 2026 13:04:55 +0000 Subject: [PATCH] With groom scans, start must equal stop --- db/schemas/sokwedb/tables/create/events.m4 | 3 +++ doc/src/tables/events.m4 | 5 +++++ 2 files changed, 8 insertions(+) diff --git a/db/schemas/sokwedb/tables/create/events.m4 b/db/schemas/sokwedb/tables/create/events.m4 index 608be3c..074f336 100644 --- a/db/schemas/sokwedb/tables/create/events.m4 +++ b/db/schemas/sokwedb/tables/create/events.m4 @@ -54,6 +54,9 @@ CREATE TABLE events ( CONSTRAINT "When the Behavior is (sdb_aggression) Start must equal Stop" CHECK (behavior <> 'sdb_aggression' OR start = stop) + CONSTRAINT "When the Behavior is (sdb_groom_scan) Start must equal Stop" + CHECK (behavior <> 'sdb_groom_scan' + OR start = stop) ); grant_priv(`EVENTS') diff --git a/doc/src/tables/events.m4 b/doc/src/tables/events.m4 index 6b8010b..44c9a06 100644 --- a/doc/src/tables/events.m4 +++ b/doc/src/tables/events.m4 @@ -222,6 +222,11 @@ The following table lists these rules and implications: This means that their |ROLES|.\ |ROLES.Participant| values must differ. + Both the |EVENTS|.\ |EVENTS.Start| and |EVENTS|.\ |EVENTS.Stop| + columns record the time of the scan when the grooming was observed. + This means the value of the EVENTS.\ |EVENTS.Start| column must + equal the value of the |EVENTS|.\ |EVENTS.Stop| column. + For grooming interval sampling events, the |EVENTS|.\ |EVENTS.Certainty| column is always |true|. -- 2.34.1