projects / sokwedb / commit
? search:
summary | shortlog | log | commit | commitdiff | tree
(parent: 474e831) | patch
Prevent EVENTS.FID from changing
authorKarl O. Pinc kop@karlpinc.com <kop@karlpinc.com>
Sun, 5 Oct 2025 15:54:42 +0000 (15:54 +0000)
committerKarl O. Pinc kop@karlpinc.com <kop@karlpinc.com>
Wed, 8 Oct 2025 16:26:56 +0000 (16:26 +0000)
commit9f3ddf06b4786abc651fa83102ac7f71d35727ad
tree553207cc1a64ee4d3ddd66f5f483dba029a50c5ctree | snapshot
parent474e831b74f3d2f2a477d7c7203cb886528ce109commit | diff
Prevent EVENTS.FID from changing

If the FID is allowed to change, at minimum -- there may be other
cases, the check that ROLES.Participant must be under study
becomes complicated.  It would require code in the triggers
to trace the BIOGRAPHY_DATA.Animid <- ROLES.Participant ->
EVENTS.EID --> FOLLOWS.FID chain to check FOLLOWS.Date
against biography.  Simpler to dis-allow change.
db/schemas/lib/triggers/create/events.m4 diff | blob | history
doc/src/tables/events.m4 diff | blob | history
SokweDB master source code repository