From 4c9626b304399d0d8a69cac678866c0e4e61506d Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Sat, 12 Apr 2025 18:52:11 +0000 Subject: [PATCH] COMM_MEMB_LOG.AnimID does not have to reference BIOGRAPHY_DATA Fixes problem #17. --- db/schemas/sokwedb/tables/create/comm_memb_log.m4 | 2 +- doc/src/tables/comm_memb_log.m4 | 11 ++++++++--- 2 files changed, 9 insertions(+), 4 deletions(-) diff --git a/db/schemas/sokwedb/tables/create/comm_memb_log.m4 b/db/schemas/sokwedb/tables/create/comm_memb_log.m4 index 3340479..faa9b5a 100644 --- a/db/schemas/sokwedb/tables/create/comm_memb_log.m4 +++ b/db/schemas/sokwedb/tables/create/comm_memb_log.m4 @@ -30,7 +30,7 @@ CREATE TABLE comm_memb_log ( CHECK ('sdb_first_memb_log_date'::DATE <= dateofupdate) CONSTRAINT "DateOfUpdate may not be after today's date" CHECK (dateofupdate <= CURRENT_DATE) - ,animid_column(`animid', `AnimID', `NOT NULL') + ,not_animid_column() ,description TEXT NOT NULL emptytext_check(`Description') ,rationale TEXT NOT NULL diff --git a/doc/src/tables/comm_memb_log.m4 b/doc/src/tables/comm_memb_log.m4 index 85964cf..e0755f8 100644 --- a/doc/src/tables/comm_memb_log.m4 +++ b/doc/src/tables/comm_memb_log.m4 @@ -67,10 +67,15 @@ AnimID (Animal IDentifier) `````````````````````````` .. |COMM_MEMB_LOG.AnimID_summary| replace:: - The |BIOGRAPHY_DATA|.\ |BIOGRAPHY_DATA.AnimID| which identifies the - chimpanzee who's community membership was updated. + Information identifying the chimpanzee or chimpanzees who's + community membership was updated. + Most often this will be a |BIOGRAPHY_DATA|.\ + |BIOGRAPHY_DATA.AnimID| value, but this is not required. -|COMM_MEMB_LOG.AnimID_summary| |notnull| +|COMM_MEMB_LOG.AnimID_summary| |emptytext| |trimmedofspaces| |notnull| + +The system will generate a warning when the AnimID value is not a +|BIOGRAPHY_DATA|.\ |BIOGRAPHY_DATA.AnimID| value. .. _COMM_MEMB_LOG.Description: -- 2.34.1