From 869ca4edc180f2d920254bec7b68faef6ae3c18c Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Wed, 1 Jul 2026 22:46:56 +0000 Subject: [PATCH] BRECORD_NOTES.Observation cannot be empty or have terminal spaces --- db/schemas/sokwedb/tables/create/brecord_notes.m4 | 3 ++- doc/src/tables/brecord_notes.m4 | 3 ++- 2 files changed, 4 insertions(+), 2 deletions(-) diff --git a/db/schemas/sokwedb/tables/create/brecord_notes.m4 b/db/schemas/sokwedb/tables/create/brecord_notes.m4 index fefd9a6..7a1aed3 100644 --- a/db/schemas/sokwedb/tables/create/brecord_notes.m4 +++ b/db/schemas/sokwedb/tables/create/brecord_notes.m4 @@ -27,7 +27,8 @@ CREATE TABLE brecord_notes ( eid INTEGER NOT NULL REFERENCES events ,observation TEXT NOT NULL - emptytext_check(`Observation') + notonlyspaces_check(`Observation') + trimmedofspaces_check(`Observation') ,comments TEXT NOT NULL emptytext_check(`Comments') ,observer TEXT NOT NULL diff --git a/doc/src/tables/brecord_notes.m4 b/doc/src/tables/brecord_notes.m4 index 9d0a8ba..48e8bf0 100644 --- a/doc/src/tables/brecord_notes.m4 +++ b/doc/src/tables/brecord_notes.m4 @@ -69,7 +69,8 @@ Observation A narrative account of the focal chimp’s behavior and interactions with others. -|notonlyspaces| +|emptytext| +|trimmedofspaces| |notnull| -- 2.34.1