From fd49f80e772830c63260b6ba14d286a9036fea7c Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Sat, 28 Feb 2026 22:50:08 +0000 Subject: [PATCH] Update SIGHTING_SOURCES to support estrus data --- doc/src/code_tables.m4 | 21 ++++++++++++++++++--- include/global_constants.m4 | 2 ++ 2 files changed, 20 insertions(+), 3 deletions(-) diff --git a/doc/src/code_tables.m4 b/doc/src/code_tables.m4 index 37d2ac0..48870f3 100644 --- a/doc/src/code_tables.m4 +++ b/doc/src/code_tables.m4 @@ -712,10 +712,19 @@ The SIGHTING_RECORDS.\ |SIGHTING_RECORDS.Priority| value must be unique. Special Values `````````````` -The |SIGHTING_RECORDS.Code| value of ``sdb_sokwedb_source`` is special. -It indicates that the sighting is due to data held in SokweDB, aside -from the |NON_BREC_SIGHTING_SOURCES| table. +The following |SIGHTING_RECORDS.Code| values are special: +``sdb_sokwedb_source`` + Indicates that the sighting or estrus state value is due to data + held in SokweDB (aside from the |NON_BREC_SIGHTING_SOURCES| and + |ESTRUS_SOURCES| tables). + +``sdb_manual_estrus`` + Indicates that the estrus values given in the |ESTRUS_SOURCES| table + are to be used in instead of any other value. + + This value has no special meaning when used in + |NON_BREC_SIGHTING_SOURCES|. Column Descriptions ``````````````````` @@ -749,6 +758,12 @@ recorded in |SIGHTINGS|.\ |SIGHTINGS.Source|, when there are multiple sources recorded for a given individual on a given day in |NON_BREC_SIGHTING_SOURCES|. +|ESTRUS_STATES| uses a different method than |SIGHTINGS| does of +determining what to record when there are multiple sources of +information. +This means that the Priority value is *not* used to determine which +values in |ESTRUS_SOURCES| appear in |ESTRUS_STATES|. + |nonnegative| |notnull| diff --git a/include/global_constants.m4 b/include/global_constants.m4 index ea0312e..36a7faa 100644 --- a/include/global_constants.m4 +++ b/include/global_constants.m4 @@ -131,6 +131,8 @@ dnl SIGHTING_RECORDS dnl dnl Value used when the SokweDB tables indicate a sighting define(`sdb_sokwedb_source', `SOKWEDB') +dnl Value used to manually override all other estrus values +define(`sdb_manual_estrus', `MANUAL') dnl dnl Special sexual cycle values -- 2.34.1