| 2026-06-07 |
Karl O. Pinc... | Create, document, index, and trigger REPRO_STATES |
commit | commitdiff | tree | snapshot |
| 2026-06-07 |
Karl O. Pinc... | Fix animid_column() macro so column cannot be NULL |
commit | commitdiff | tree | snapshot |
| 2026-06-06 |
Karl O. Pinc... | Use eid_primary_key() macro |
commit | commitdiff | tree | snapshot |
| 2026-06-06 |
Karl O. Pinc... | Correctly invoke animid_column() macro |
commit | commitdiff | tree | snapshot |
| 2026-06-06 |
Karl O. Pinc... | Invoke animid_column() macro with parenthesis |
commit | commitdiff | tree | snapshot |
| 2026-06-06 |
Karl O. Pinc... | Alphabetize by table name |
commit | commitdiff | tree | snapshot |
| 2026-06-06 |
Karl O. Pinc... | Create REPRO_STATE_CHANGE_SOURCES code table |
commit | commitdiff | tree | snapshot |
| 2026-06-06 |
Karl O. Pinc... | Create PARITIES code table |
commit | commitdiff | tree | snapshot |
| 2026-06-06 |
Karl O. Pinc... | Create LE_CERTAINTIES code table |
commit | commitdiff | tree | snapshot |
| 2026-06-06 |
Karl O. Pinc... | Create ED_CERTAINTIES code table |
commit | commitdiff | tree | snapshot |
| 2026-06-06 |
Karl O. Pinc... | Correct copyright date |
commit | commitdiff | tree | snapshot |
| 2026-06-06 |
Karl O. Pinc... | Remove the ARRIVALS_A.ArAID column and use EID as the... |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Index and trigger SPECIES_PRESENT |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Fix hyperlinks |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Remove the SPECIES_PRESENT.OSID column and use EID... |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | EVENTS with Behavior = sdb_other_species cannot be... |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | sdb_other_species events must be "certain" |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | sdb_other_species events must have a related FOLLOWS row |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Write triggers for HUMANS |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Document the sdb_other_species event type's validation... |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Fix hyperlink |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Remove the HUMANS.HuID column and use EID as the primar... |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Remove the GROOM_SCANS_B.GsID column and use EID as... |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Remove GROOMINGS.GrID and use EID as the primary key |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Remove FOOD_EVENTS.FEID and use EID as the primary key |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Remove AGGRESSIONS.AgID and use EID as the primary key |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Add triggers for SWELLING_SOURCES |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Correct "ATTENDANCE after under study" error message |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Fix inequality that broke ATTENDANCE under-study check |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Spelling |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | A shorter and more clear error message |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Index the swelling sources on SWELLING_STATES |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | New build_arrivals_seq() function, in case the auto... |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Automatically maintain ARRIVALS.Seq |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Clarify ARRIVALS.Seq ordering in the docs |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Require an ARRIVALS row have a related ROLES row |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | Remove ARRIVALS.ArID and use EID as the primary key |
commit | commitdiff | tree | snapshot |
| 2026-06-05 |
Karl O. Pinc... | New table macro eid_primary_key() |
commit | commitdiff | tree | snapshot |
| 2026-06-04 |
Karl O. Pinc... | Fix and use correct key column name |
commit | commitdiff | tree | snapshot |
| 2026-06-04 |
Karl O. Pinc... | Remove accidental leftover graphic elements |
commit | commitdiff | tree | snapshot |
| 2026-06-04 |
Karl O. Pinc... | Simplify because events only fire on update |
commit | commitdiff | tree | snapshot |
| 2026-06-01 |
Karl O. Pinc... | Support groom scanning at the feeding station as an... |
commit | commitdiff | tree | snapshot |
| 2026-06-01 |
Karl O. Pinc... | Create, document, index, and trigger ARRIVALS_A |
commit | commitdiff | tree | snapshot |
| 2026-06-01 |
Karl O. Pinc... | Remove arrival related information from ATTENDANCE |
commit | commitdiff | tree | snapshot |
| 2026-06-01 |
Karl O. Pinc... | Fix check for unique roles per event |
commit | commitdiff | tree | snapshot |
| 2026-06-01 |
Karl O. Pinc... | Update roles docs to note that roles apply to feeding... |
commit | commitdiff | tree | snapshot |
| 2026-06-01 |
Karl O. Pinc... | Update diagrams for event based attendance design |
commit | commitdiff | tree | snapshot |
| 2026-06-01 |
Karl O. Pinc... | Grammer |
commit | commitdiff | tree | snapshot |
| 2026-06-01 |
Karl O. Pinc... | Use macro to enforce Certainty = sdb_identity_certain |
commit | commitdiff | tree | snapshot |
| 2026-06-01 |
Karl O. Pinc... | Use macro to enforce Start = Stop |
commit | commitdiff | tree | snapshot |
| 2026-06-01 |
Karl O. Pinc... | Shorten EVENTS.Behavior constraint name to fit within... |
commit | commitdiff | tree | snapshot |
| 2026-06-01 |
Karl O. Pinc... | Allow the EVENT.Behavior to be sdb_groom_scan |
commit | commitdiff | tree | snapshot |
| 2026-06-01 |
Karl O. Pinc... | Give time precision docs their own section |
commit | commitdiff | tree | snapshot |
| 2026-05-31 |
Karl O. Pinc... | Hyperlink to tables that have been documented |
commit | commitdiff | tree | snapshot |
| 2026-05-31 |
Karl O. Pinc... | Move docs of sdb_actor, sdb_actee, and sdb_mutual into... |
commit | commitdiff | tree | snapshot |
| 2026-05-31 |
Karl O. Pinc... | Update copyright date |
commit | commitdiff | tree | snapshot |
| 2026-05-31 |
Karl O. Pinc... | Grammar |
commit | commitdiff | tree | snapshot |
| 2026-05-31 |
Karl O. Pinc... | Make sdb_mutual (Mutual) a special ROLE_CODES.Role... |
commit | commitdiff | tree | snapshot |
| 2026-05-29 |
Karl O. Pinc... | Allow EVENTS and ATTENDANCE to relate, add EVENTS.AtID... |
commit | commitdiff | tree | snapshot |
| 2026-05-28 |
Karl O. Pinc... | New null_xor_null() macro: exactly one of 2 columns... |
commit | commitdiff | tree | snapshot |
| 2026-05-28 |
Karl O. Pinc... | EVENTS is to reference ATTENDANCE, so create ATTENDANCE... |
commit | commitdiff | tree | snapshot |
| 2026-05-28 |
Karl O. Pinc... | Convert the follow_map_time_problems table into the... |
commit | commitdiff | tree | snapshot |
| 2026-05-28 |
Karl O. Pinc... | With groom scans, start must equal stop |
commit | commitdiff | tree | snapshot |
| 2026-05-28 |
Karl O. Pinc... | Change table name GROOM_SCANS -> GROOM_SCANS_B |
commit | commitdiff | tree | snapshot |
| 2026-05-28 |
Karl O. Pinc... | Replace "estrus" with "swelling", FEMALE_STATES ->... |
commit | commitdiff | tree | snapshot |
| 2026-05-28 |
Karl O. Pinc... | Change "estrus" to "swelling" in ESTRUS_STATES names |
commit | commitdiff | tree | snapshot |
| 2026-05-28 |
Karl O. Pinc... | Talk about "swelling" not "estrus" in the CYCLE_STATES... |
commit | commitdiff | tree | snapshot |
| 2026-05-28 |
Karl O. Pinc... | Change global constant name sdb_manual_estrus -> sdb_ma... |
commit | commitdiff | tree | snapshot |
| 2026-05-28 |
Karl O. Pinc... | Change "estrus" to "swelling" in ESTRUS_SOURCES names |
commit | commitdiff | tree | snapshot |
| 2026-05-27 |
Karl O. Pinc... | Fix so FOLLOWS.CommID is validated against COMM_IDS |
commit | commitdiff | tree | snapshot |
| 2026-05-27 |
Karl O. Pinc... | Change column name: FOLLOWS.Community -> CommID |
commit | commitdiff | tree | snapshot |
| 2026-05-27 |
Karl O. Pinc... | Fix copyright dates |
commit | commitdiff | tree | snapshot |
| 2026-05-27 |
Karl O. Pinc... | Change column name: AGGRESSIONS.Community ->CommID |
commit | commitdiff | tree | snapshot |
| 2026-05-27 |
Karl O. Pinc... | Change column name: AGGRESSION_EVENT_LOG.Community... |
commit | commitdiff | tree | snapshot |
| 2026-05-27 |
Karl O. Pinc... | Create, document, index, and trigger ATTENDANCE |
commit | commitdiff | tree | snapshot |
| 2026-05-26 |
Karl O. Pinc... | Increase maximum FOOD_EVENTS per EVENTS row |
commit | commitdiff | tree | snapshot |
| 2026-05-25 |
Karl O. Pinc | Add ATTENDANCE to demography ER diagram |
commit | commitdiff | tree | snapshot |
| 2026-05-25 |
Karl O. Pinc | Remove estrus tables from demography ER diagram |
commit | commitdiff | tree | snapshot |
| 2026-05-25 |
Karl O. Pinc... | Table qualify column names for clarity |
commit | commitdiff | tree | snapshot |
| 2026-05-25 |
Karl O. Pinc... | Create, document, index, and trigger GROOM_SCANS |
commit | commitdiff | tree | snapshot |
| 2026-05-25 |
Karl O. Pinc... | Typos |
commit | commitdiff | tree | snapshot |
| 2026-05-25 |
Karl O. Pinc... | EVENTS.Start and Stop have semantics that depend on... |
commit | commitdiff | tree | snapshot |
| 2026-05-25 |
Karl O. Pinc... | Link to the detailed description of behavior codes |
commit | commitdiff | tree | snapshot |
| 2026-05-25 |
Karl O. Pinc | Add GROOM_SCANS to the Events ER diagram |
commit | commitdiff | tree | snapshot |
| 2026-05-25 |
Karl O. Pinc... | Adjust data integrity rules to allow "other" grooming... |
commit | commitdiff | tree | snapshot |
| 2026-05-25 |
Karl O. Pinc... | Removed dropped GROOMINGS.Other column |
commit | commitdiff | tree | snapshot |
| 2026-05-25 |
Karl O. Pinc... | Remove index from dropped columns |
commit | commitdiff | tree | snapshot |
| 2026-05-25 |
Karl O. Pinc... | Generalize EVENTS.Certainty description |
commit | commitdiff | tree | snapshot |
| 2026-05-25 |
Karl O. Pinc... | Document Observer check on transaction commit |
commit | commitdiff | tree | snapshot |
| 2026-05-25 |
Karl O. Pinc... | Add female reproductive ER diagram to docs |
commit | commitdiff | tree | snapshot |
| 2026-05-25 |
Karl O. Pinc | A ER diagram related to female sexual cycling |
commit | commitdiff | tree | snapshot |
| 2026-05-24 |
Karl O. Pinc | Drop GROOMINGS.Other column |
commit | commitdiff | tree | snapshot |
| 2026-05-24 |
Karl O. Pinc... | Create, document, index, and trigger GROOMINGS |
commit | commitdiff | tree | snapshot |
| 2026-05-23 |
Karl O. Pinc... | The ROLES.Role of sdb_actor and sdb_actee must occur... |
commit | commitdiff | tree | snapshot |
| 2026-05-21 |
Karl O. Pinc... | Remove hardcoding of aggression event |
commit | commitdiff | tree | snapshot |
| 2026-05-21 |
Karl O. Pinc... | Prevent updates to ROLES.Role |
commit | commitdiff | tree | snapshot |
| 2026-05-21 |
Karl O. Pinc... | There can only be one individual related to a food... |
commit | commitdiff | tree | snapshot |
| 2026-05-20 |
Karl O. Pinc... | The individual consuming the food must be the focal |
commit | commitdiff | tree | snapshot |
| 2026-05-20 |
Karl O. Pinc... | Declare variables needed to to check focal participanti... |
commit | commitdiff | tree | snapshot |
| 2026-05-20 |
Karl O. Pinc... | Place an upper limit (2) on the foods consumed per... |
commit | commitdiff | tree | snapshot |
| next |
projects / sokwedb / shortlog