From 2372f73bc416eb29e3c1770d3bbb3356a8162b3a Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Mon, 1 Jun 2026 19:09:57 +0000 Subject: [PATCH] Update diagrams for event based attendance design Split ATTENDANCE table, creating ARRIVALS_A, an attendance arrival and departure event table. --- doc/diagrams/demography.svg | 385 ++++++--------- doc/diagrams/events.svg | 541 ++++++++++++++++---- doc/diagrams/follows.svg | 960 ++++++++++++++++++++++++++---------- 3 files changed, 1283 insertions(+), 603 deletions(-) diff --git a/doc/diagrams/demography.svg b/doc/diagrams/demography.svg index 7bfd81c..125d81f 100644 --- a/doc/diagrams/demography.svg +++ b/doc/diagrams/demography.svg @@ -812,6 +812,64 @@ + + + + + + + + + + + + + + + + membership + Individualattendingthe feedingstation + Records ofindividual'sfeedingstationatttendance + - - DepartureDegree - - + transform="translate(105.98751,128.00427)"> + y="51.995731" /> AtID + y="183.60001" /> AnimID + y="187.2" /> + y="84.452904" /> - Seq - - - Estrus - - - - Bananas - - - ArrivalDegree - - - BananaCount - - - - Start - - - - Stop - - - - Recorder - - - - Observer2 - - + + + + + + information + Feedingstationattendanceeventinformation detail + Feedingstationattendancedetail + + + ARRIVALS_A + + + EID + + Bananas ∅ + + ArAID + + ArrivalDegree ∅ + + Seq + + Swelling * + + + Observer2 * + + + CycleOld + + DepartureDegree ∅ + Seq + + + Swelling * + + + + Recorder * + + + EVENTS + x="28.637501" + y="21.762554" /> EID + x="28.637501" + y="25.362541" /> Behavior + id="tspan2100-9-1-3-1-7-9-3-2" + x="29.374866" + y="35.101742" + style="font-style:italic;font-variant:normal;font-weight:normal;font-stretch:normal;font-size:2.82223px;font-family:Sans;-inkscape-font-specification:'Sans, Italic';font-variant-ligatures:normal;font-variant-caps:normal;font-variant-numeric:normal;font-variant-east-asian:normal;stroke-width:0.264583px">AtID ∅ + x="28.637501" + y="32.458389" /> FID ∅ + x="28.637501" + y="28.962553" /> Start + id="tspan2100-9-1-3-1-5-0-2-2" + x="29.336201" + y="38.705582" + style="stroke-width:0.264583px">Behavior + x="28.637501" + y="36.058388" /> Stop + id="tspan2100-9-1-3-1-7-9-3-2-4-6" + x="29.374851" + y="42.301674" + style="stroke-width:0.264583px">Start + x="28.637501" + y="39.65839" /> Certainty + id="tspan2100-9-1-3-1-5-0-2-2-5-6" + x="29.336185" + y="45.905602" + style="stroke-width:0.264583px">Stop + x="28.637501" + y="43.258339" /> Notes + sodipodi:role="line">Certainty + x="28.637501" + y="46.858318" /> + Notes + diff --git a/doc/diagrams/follows.svg b/doc/diagrams/follows.svg index bcdcfe1..993018f 100644 --- a/doc/diagrams/follows.svg +++ b/doc/diagrams/follows.svg @@ -436,7 +436,7 @@ rx="0.65287793" ry="0.65784538" transform="scale(-1,1)" />FOLLOW_OBSERVERSDad ofindividualMom ofindividualChildrenof momChildrenof DadObserversconductingthe followFOLLOW_STUDIESIndividualfollowedRoles playedas an eventparticipantIndividualwhoparticipatedFollows ofIndividualEvent in whichparticpatedAttendance record ofparticipantPartcipitantsin an eventin eventFollow duringwhich eventoccurredEvents which occuredduring followFollowsscheduledfor thecommunityCommunityin whichfollow wasscheduledDadIDPubBIOGRAPHY_DATAAnimIDAnimIDNumAnimIDNumAnimNameBCCertaintySexMomIDDadStatusDadIDFirstBornBirthDateBDMinBDMaxBDDistEntryDateEntryType *DepartDateDepartType *FOLLOWSFIDFIDCommIDNotesNotesDateFocalFocalFOIDFOIDFIDFIDFSIDFSIDCode *FIDFIDOBS_Tiki *Period *OBS_Brec *Follow conductedby the observersFollow of thestudyStudies ofthe followCommIDEVENTSEIDEIDBehaviorAtID ∅FID ∅StartBehaviorStopStartCertaintyStopNotesCertaintyNotesROLESPIDRole *EIDParticipantAtID ∅Role individualplayed in agroomingevent + clip-path="none" />ATTENDANCEAtIDAnimIDDateCommID *Individualattendingthe feedingstationEvents of the feedingstation attendancerecordRecords ofindividual'sfeedingstationatttendanceThe event's feedingstation atttendancerecord -- 2.34.1