From a09ae292403af3b7f0b5657e625729273b5092a6 Mon Sep 17 00:00:00 2001
From: "Karl O. Pinc kop@karlpinc.com" <kop@karlpinc.com>
Date: Fri, 5 Jun 2026 19:41:14 +0000
Subject: [PATCH] Remove the HUMANS.HuID column and use EID as the primary key

---
 db/schemas/sokwedb/tables/create/humans.m4 |  5 ++--
 doc/diagrams/events.svg                    | 30 ++++------------------
 doc/src/epilog.inc.m4                      |  2 --
 doc/src/tables/humans.m4                   | 12 +--------
 4 files changed, 9 insertions(+), 40 deletions(-)

diff --git a/db/schemas/sokwedb/tables/create/humans.m4 b/db/schemas/sokwedb/tables/create/humans.m4
index cffe096..a0a136d 100644
--- a/db/schemas/sokwedb/tables/create/humans.m4
+++ b/db/schemas/sokwedb/tables/create/humans.m4
@@ -24,8 +24,7 @@ include(`grants.m4')dnl
 dnl
 
 CREATE TABLE humans (
-   key_column(`HUMANS', `HID', `INTEGER')
-  ,eid INTEGER NOT NULL
+   eid INTEGER NOT NULL
        REFERENCES events
   ,researchers INTEGER NOT NULL
      nonnegative_check(`Researchers')
@@ -36,4 +35,6 @@ CREATE TABLE humans (
     CHECK ((researchers > 0) OR (nonresearchers > 0))
 );
 
+eid_primary_key(`HUMANS')
+
 grant_priv(`HUMANS')
diff --git a/doc/diagrams/events.svg b/doc/diagrams/events.svg
index 3d88b1b..0cb7f89 100644
--- a/doc/diagrams/events.svg
+++ b/doc/diagrams/events.svg
@@ -821,8 +821,8 @@
      inkscape:pageopacity="0.0"
      inkscape:pageshadow="2"
      inkscape:zoom="3.6096384"
-     inkscape:cx="242.68359"
-     inkscape:cy="903.27607"
+     inkscape:cx="643.8318"
+     inkscape:cy="615.15857"
      inkscape:document-units="mm"
      inkscape:current-layer="layer3"
      inkscape:document-rotation="0"
@@ -1483,12 +1483,12 @@
        xml:space="preserve"
        style="font-style:normal;font-variant:normal;font-weight:bold;font-stretch:normal;font-size:2.82223px;line-height:125%;font-family:Sans;-inkscape-font-specification:'Sans, Bold';font-variant-ligatures:normal;font-variant-caps:normal;font-variant-numeric:normal;font-variant-east-asian:normal;text-align:start;letter-spacing:0px;word-spacing:0px;writing-mode:lr-tb;text-anchor:start;display:inline;fill:#000000;fill-opacity:1;stroke:none;stroke-width:0.264583px;stroke-linecap:butt;stroke-linejoin:miter;stroke-opacity:1"
        x="142.56032"
-       y="158.79703"
+       y="162.50114"
        id="text2064-6-17-7"><tspan
          sodipodi:role="line"
          id="tspan2062-0-2-3"
          x="142.56032"
-         y="158.79703"
+         y="162.50114"
          style="font-style:normal;font-variant:normal;font-weight:bold;font-stretch:normal;font-size:2.82223px;font-family:Sans;-inkscape-font-specification:'Sans, Bold';font-variant-ligatures:normal;font-variant-caps:normal;font-variant-numeric:normal;font-variant-east-asian:normal;stroke-width:0.264583px">HUMANS</tspan></text>
     <rect
        style="display:inline;fill:#ff2a2a;fill-opacity:0.000380632;stroke:#000000;stroke-width:0.214388;stroke-miterlimit:4;stroke-dasharray:none;stroke-dashoffset:0;stroke-opacity:0.98995"
@@ -1496,7 +1496,7 @@
        width="30.458927"
        height="3.6260581"
        x="142.10724"
-       y="156.08682"
+       y="159.79094"
        inkscape:connector-avoid="true" />
     <rect
        style="display:inline;fill:#ff2a2a;fill-opacity:0.000380632;stroke:#000000;stroke-width:0.214329;stroke-miterlimit:4;stroke-dasharray:none;stroke-dashoffset:0;stroke-opacity:0.98995"
@@ -1522,14 +1522,6 @@
        x="142.10713"
        y="170.46109"
        inkscape:connector-avoid="true" />
-    <rect
-       style="display:inline;fill:#ff2a2a;fill-opacity:0.000380632;stroke:#000000;stroke-width:0.21378;stroke-miterlimit:4;stroke-dasharray:none;stroke-dashoffset:0;stroke-opacity:0.98995"
-       id="rect2104-6-3-9-35-6-5"
-       width="30.449526"
-       height="3.6066427"
-       x="142.11691"
-       y="159.69652"
-       inkscape:connector-avoid="true" />
     <text
        xml:space="preserve"
        style="font-style:normal;font-variant:normal;font-weight:bold;font-stretch:normal;font-size:2.81672px;line-height:125%;font-family:Sans;-inkscape-font-specification:'Sans, Bold';font-variant-ligatures:normal;font-variant-caps:normal;font-variant-numeric:normal;font-variant-east-asian:normal;text-align:start;letter-spacing:0px;word-spacing:0px;writing-mode:lr-tb;text-anchor:start;fill:#000000;fill-opacity:1;stroke:none;stroke-width:0.264067px;stroke-linecap:butt;stroke-linejoin:miter;stroke-opacity:1"
@@ -2125,18 +2117,6 @@
          x="143.28693"
          y="151.09801"
          style="stroke-width:0.264205px;-inkscape-font-specification:'Sans, Normal';font-family:Sans;font-weight:normal;font-style:normal;font-stretch:normal;font-variant:normal;font-size:2.81820024px;font-variant-ligatures:normal;font-variant-caps:normal;font-variant-numeric:normal;font-variant-east-asian:normal">Species *</tspan></text>
-    <text
-       xml:space="preserve"
-       style="font-style:italic;font-variant:normal;font-weight:normal;font-stretch:normal;font-size:2.8182px;line-height:125%;font-family:Sans;-inkscape-font-specification:'Sans, Italic';font-variant-ligatures:normal;font-variant-caps:normal;font-variant-numeric:normal;text-align:start;letter-spacing:0px;word-spacing:0px;writing-mode:lr-tb;text-anchor:start;display:inline;fill:#000000;fill-opacity:1;stroke:none;stroke-width:0.264205px;stroke-linecap:butt;stroke-linejoin:miter;stroke-opacity:1;font-variant-east-asian:normal"
-       x="143.19742"
-       y="162.29033"
-       id="text2102-5-2-4-5-170-2-29-3-4-6"
-       transform="scale(0.99848529,1.001517)"><tspan
-         sodipodi:role="line"
-         id="tspan2100-9-1-3-1-6-5-9-5-9-4"
-         x="143.19742"
-         y="162.29033"
-         style="stroke-width:0.264205px;-inkscape-font-specification:'Sans, Italic';font-family:Sans;font-weight:normal;font-style:italic;font-stretch:normal;font-variant:normal;font-size:2.81820024px;font-variant-ligatures:normal;font-variant-caps:normal;font-variant-numeric:normal;font-variant-east-asian:normal">HID</tspan></text>
     <text
        xml:space="preserve"
        style="font-style:italic;font-variant:normal;font-weight:normal;font-stretch:normal;font-size:2.8182px;line-height:125%;font-family:Sans;-inkscape-font-specification:'Sans, Italic';font-variant-ligatures:normal;font-variant-caps:normal;font-variant-numeric:normal;text-align:start;letter-spacing:0px;word-spacing:0px;writing-mode:lr-tb;text-anchor:start;display:inline;fill:#000000;fill-opacity:1;stroke:none;stroke-width:0.264205px;stroke-linecap:butt;stroke-linejoin:miter;stroke-opacity:1;font-variant-east-asian:normal"
diff --git a/doc/src/epilog.inc.m4 b/doc/src/epilog.inc.m4
index c5794da..8ed555b 100644
--- a/doc/src/epilog.inc.m4
+++ b/doc/src/epilog.inc.m4
@@ -447,8 +447,6 @@ sdb_generated_rst()dnl
    :ref:`ExtractedBy <GROOMINGS.ExtractedBy>`
 
 .. |HUMANS| replace:: :ref:`HUMANS <HUMANS>`
-.. |HUMANS.HID| replace::
-   :ref:`HID <HUMANS.HID>`
 .. |HUMANS.EID| replace::
    :ref:`EID <HUMANS.EID>`
 .. |HUMANS.Researchers| replace::
diff --git a/doc/src/tables/humans.m4 b/doc/src/tables/humans.m4
index ae576df..dd74e04 100644
--- a/doc/src/tables/humans.m4
+++ b/doc/src/tables/humans.m4
@@ -39,17 +39,6 @@ matches the HUMANS row's |HUMANS.EID| value must have an |EVENTS|\
    :depth: 2
 
 
-.. _HUMANS.HID:
-
-HID (Humans ID)
-```````````````
-
-.. |HUMANS.HID_summary| replace::
-   |idcol|
-
-|HUMANS.HID_summary| |notnull|
-
-
 .. _HUMANS.EID:
 
 EID (Event IDentifier)
@@ -58,6 +47,7 @@ EID (Event IDentifier)
 .. |HUMANS.EID_summary| replace::
    The |EVENTS|.\ |EVENTS.EID| that identifies the event which records the
    presence of non-chimpanzee species.
+   |idcol|
 
 |HUMANS.EID_summary| |notnull|
 
-- 
2.34.1