kop_sokwedb
11 days ago Karl O. Pinc... Use macro to enforce Certainty = sdb_identity_certain
11 days ago Karl O. Pinc... Use macro to enforce Start = Stop
12 days ago Karl O. Pinc... Shorten EVENTS.Behavior constraint name to fit within...
12 days ago Karl O. Pinc... Allow the EVENT.Behavior to be sdb_groom_scan
12 days ago Karl O. Pinc... Give time precision docs their own section
12 days ago Karl O. Pinc... Hyperlink to tables that have been documented
12 days ago Karl O. Pinc... Move docs of sdb_actor, sdb_actee, and sdb_mutual into...
13 days ago Karl O. Pinc... Update copyright date
13 days ago Karl O. Pinc... Grammar
13 days ago Karl O. Pinc... Make sdb_mutual (Mutual) a special ROLE_CODES.Role...
2026-05-29 Karl O. Pinc... Allow EVENTS and ATTENDANCE to relate, add EVENTS.AtID...
2026-05-28 Karl O. Pinc... New null_xor_null() macro: exactly one of 2 columns...
2026-05-28 Karl O. Pinc... EVENTS is to reference ATTENDANCE, so create ATTENDANCE...
2026-05-28 Karl O. Pinc... Convert the follow_map_time_problems table into the...
2026-05-28 Karl O. Pinc... With groom scans, start must equal stop
2026-05-28 Karl O. Pinc... Change table name GROOM_SCANS -> GROOM_SCANS_B
2026-05-28 Karl O. Pinc... Replace "estrus" with "swelling", FEMALE_STATES ->...
2026-05-28 Karl O. Pinc... Change "estrus" to "swelling" in ESTRUS_STATES names
2026-05-28 Karl O. Pinc... Talk about "swelling" not "estrus" in the CYCLE_STATES...
2026-05-28 Karl O. Pinc... Change global constant name sdb_manual_estrus -> sdb_ma...
2026-05-28 Karl O. Pinc... Change "estrus" to "swelling" in ESTRUS_SOURCES names
2026-05-27 Karl O. Pinc... Fix so FOLLOWS.CommID is validated against COMM_IDS
2026-05-27 Karl O. Pinc... Change column name: FOLLOWS.Community -> CommID
2026-05-27 Karl O. Pinc... Fix copyright dates
2026-05-27 Karl O. Pinc... Change column name: AGGRESSIONS.Community ->CommID
2026-05-27 Karl O. Pinc... Change column name: AGGRESSION_EVENT_LOG.Community...
2026-05-27 Karl O. Pinc... Create, document, index, and trigger ATTENDANCE
2026-05-26 Karl O. Pinc... Increase maximum FOOD_EVENTS per EVENTS row
2026-05-25 Karl O. PincAdd ATTENDANCE to demography ER diagram
2026-05-25 Karl O. PincRemove estrus tables from demography ER diagram
2026-05-25 Karl O. Pinc... Table qualify column names for clarity
2026-05-25 Karl O. Pinc... Create, document, index, and trigger GROOM_SCANS
2026-05-25 Karl O. Pinc... Typos
2026-05-25 Karl O. Pinc... EVENTS.Start and Stop have semantics that depend on...
2026-05-25 Karl O. Pinc... Link to the detailed description of behavior codes
2026-05-25 Karl O. PincAdd GROOM_SCANS to the Events ER diagram
2026-05-25 Karl O. Pinc... Adjust data integrity rules to allow "other" grooming...
2026-05-25 Karl O. Pinc... Removed dropped GROOMINGS.Other column
2026-05-25 Karl O. Pinc... Remove index from dropped columns
2026-05-25 Karl O. Pinc... Generalize EVENTS.Certainty description
2026-05-25 Karl O. Pinc... Document Observer check on transaction commit
2026-05-25 Karl O. Pinc... Add female reproductive ER diagram to docs
2026-05-25 Karl O. PincA ER diagram related to female sexual cycling
2026-05-24 Karl O. PincDrop GROOMINGS.Other column
2026-05-24 Karl O. Pinc... Create, document, index, and trigger GROOMINGS
2026-05-23 Karl O. Pinc... The ROLES.Role of sdb_actor and sdb_actee must occur...
2026-05-21 Karl O. Pinc... Remove hardcoding of aggression event
2026-05-21 Karl O. Pinc... Prevent updates to ROLES.Role
2026-05-21 Karl O. Pinc... There can only be one individual related to a food...
2026-05-20 Karl O. Pinc... The individual consuming the food must be the focal
2026-05-20 Karl O. Pinc... Declare variables needed to to check focal participanti...
2026-05-20 Karl O. Pinc... Place an upper limit (2) on the foods consumed per...
2026-05-18 Karl O. Pinc... Fix markup
2026-05-18 Karl O. Pinc... Give unique indexes descriptive names
2026-05-18 Karl O. Pinc... An individual can only appear in an event once
2026-05-18 Karl O. Pinc... Correct markup, improve text of "participant must be...
2026-05-17 Karl O. Pinc... Move the "not there" warning from AGGRESSIONS to ROLES
2026-05-17 Karl O. Pinc... Change GROOMINS.Others -> Other in ER diagram
2026-05-16 Karl O. Pinc... Remove extra words
2026-05-16 Karl O. Pinc... Improve AGGRESSIONS docs
2026-05-16 Karl O. Pinc... Allow aggression event logs back to 1960
2026-05-15 Karl O. PincRemove GROOMINGS.TimeCertainty and Duplicate columns...
2026-05-14 Karl O. PincAdd new columns to AGGRESSIONS ER diagram
2026-05-14 Karl O. Pinc... Create, document, index, and trigger FOOD_EVENTS
2026-05-14 Karl O. Pinc... Fix "must" v.s. "should" wording
2026-05-14 Karl O. Pinc... Document the transaction concept
2026-05-14 Karl O. Pinc... Better handle :ref:s that show up in sentences
2026-05-14 Karl O. Pinc... Fix hyperlink
2026-05-14 Karl O. Pinc... Create, document, and index FOOD_NAMES table
2026-05-14 Karl O. Pinc... Create, document, and index FOOD_PARTS table
2026-05-14 Karl O. Pinc... New macro: positive_check() Checks a column is a posit...
2026-05-14 Karl O. Pinc... Get rid of trailing spaces
2026-05-14 Karl O. Pinc... Alphabetize by code table name
2026-05-14 Karl O. Pinc... Re-arrange the overview paragraphs
2026-05-14 Karl O. Pinc... Better docs regards EVENTS.Behavior codes and the event...
2026-05-14 Karl O. Pinc... Index AGGRESSIONS
2026-05-14 Karl O. Pinc... Change note regarding extracted text into a sidebar
2026-05-14 Karl O. Pinc... Index SIGHTINGS
2026-05-14 Karl O. Pinc... Explicitly document that SIGHTINGS.AnimID and Date...
2026-05-14 Karl O. Pinc... Fix SIGHTINGS.Date link text in RST references
2026-05-14 Karl O. Pinc... Create SIGHTINGS trigger
2026-05-13 Karl O. Pinc... Put lower bound on SIGHTINGS.Date
2026-05-13 Karl O. Pinc... Add note documenting relations between extracted AGGRES...
2026-05-13 Karl O. Pinc... Add the AGGRESSIONS.RecipientBehavior column
2026-05-13 Karl O. Pinc... Add the AGGRESSIONS.AggressorBehavior column
2026-05-13 Karl O. Pinc... Add the AGGRESSIONS.FullAccount column
2026-05-13 Karl O. Pinc... Fix AGGRESSIONS substituition references' anchors
2026-05-13 Karl O. Pinc... Fix RST syntax
2026-05-13 Karl O. Pinc... Have AGGRESSIONS.Severity validate off the AGG_SEVERITI...
2026-05-13 Karl O. Pinc... Create and document the AGG_SEVERITIES table
2026-05-13 Karl O. Pinc... For aggressions, EVENTS.Certainty is the certainty...
2026-05-13 Karl O. Pinc... Use better SQL literal syntax
2026-05-13 Karl O. Pinc... Spelling
2026-05-13 Karl O. Pinc... Produce warning when AGGRESSIONS.Community <> FOLLOWS...
2026-05-13 Karl O. Pinc... Create SIGHTINGS table
2026-05-13 Karl O. Pinc... Create the NON_BREC_SIGHTING_SOURCES table
2026-05-13 Karl O. Pinc... Load aggression comments into EVENTS.notes
2026-05-13 Karl O. Pinc... Fix permissions on AGGRESSIONS table
2026-05-13 Karl O. Pinc... Fix for problem #68
2026-05-13 Karl O. Pinc... Fix for problem #67
next