From 6da1cd32cfa614ed15fb0283ff3e5b24e0ce1aa9 Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Wed, 13 May 2026 22:07:03 +0000 Subject: [PATCH] Explicitly document that SIGHTINGS.AnimID and Date pair must be unique --- doc/src/analyzed/sightings.m4 | 3 +++ 1 file changed, 3 insertions(+) diff --git a/doc/src/analyzed/sightings.m4 b/doc/src/analyzed/sightings.m4 index 4ba8f88..8f3dea4 100644 --- a/doc/src/analyzed/sightings.m4 +++ b/doc/src/analyzed/sightings.m4 @@ -39,6 +39,9 @@ The SIGHTINGS table is automatically constructed by the system and cannot be manually maintained. The table's rows are computed from the SokweDB tables' content. +The combination of |SIGHTINGS.Date| and |SIGHTINGS.AnimID| must be +unique. + The |NON_BREC_SIGHTING_SOURCES| table is used to add additional records of daily sightings into SIGHTINGS, records from "external" data sources, when the other parts of SokweDB do not indicate that an -- 2.34.1