projects
/
sokwedb
/ shortlog
commit
grep
author
committer
pickaxe
?
search:
re
summary
| shortlog |
log
|
commit
|
commitdiff
|
tree
first ⋅ prev ⋅
next
sokwedb
10 days ago
Karl O. Pinc...
Fix broken link and improve date and time docs
master
commit
|
commitdiff
|
tree
|
snapshot
10 days ago
Karl O. Pinc...
Make ESTRUS_STATES table and indexes
commit
|
commitdiff
|
tree
|
snapshot
10 days ago
Karl O. Pinc...
Create ESTRUS_SOURCES table and indexes
commit
|
commitdiff
|
tree
|
snapshot
10 days ago
Karl O. Pinc...
Create SIGHTING_RECORDS table and indexes
commit
|
commitdiff
|
tree
|
snapshot
10 days ago
Karl O. Pinc...
Add ARRIVALS.Seq column to DDL
commit
|
commitdiff
|
tree
|
snapshot
10 days ago
Karl O. Pinc...
Initial ESTRUS_STATES design
commit
|
commitdiff
|
tree
|
snapshot
10 days ago
Karl O. Pinc...
New ESTRUS_SOURCES table to support non-SokweDB estrus...
commit
|
commitdiff
|
tree
|
snapshot
10 days ago
Karl O. Pinc...
Update SIGHTING_SOURCES to support estrus data
commit
|
commitdiff
|
tree
|
snapshot
10 days ago
Karl O. Pinc...
SIGHTING_SOURCES contains old BRec data
commit
|
commitdiff
|
tree
|
snapshot
10 days ago
Karl O. Pinc...
Note problems with per-page HTML when file names are...
commit
|
commitdiff
|
tree
|
snapshot
10 days ago
Karl O. Pinc...
Clarify when CYCLE_STATES.AsNum should be NULL
commit
|
commitdiff
|
tree
|
snapshot
10 days ago
Karl O. Pinc...
Add missing substitution reference for CYCLE_STATES...
commit
|
commitdiff
|
tree
|
snapshot
10 days ago
Karl O. Pinc...
Move date restriction rule from analysis results to...
commit
|
commitdiff
|
tree
|
snapshot
10 days ago
Karl O. Pinc...
Tweak wording
commit
|
commitdiff
|
tree
|
snapshot
10 days ago
Karl O. Pinc...
Create a separate section for tables populated automati...
commit
|
commitdiff
|
tree
|
snapshot
10 days ago
Karl O. Pinc...
Alphabetize
commit
|
commitdiff
|
tree
|
snapshot
10 days ago
Karl O. Pinc...
SIGHTINGS does not contain estrus information
commit
|
commitdiff
|
tree
|
snapshot
10 days ago
Karl O. Pinc...
Spelling: estrous -> estrus
commit
|
commitdiff
|
tree
|
snapshot
10 days ago
Karl O. Pinc...
Support local m4 include files
commit
|
commitdiff
|
tree
|
snapshot
10 days ago
Karl O. Pinc...
Produce the "drop notices" when dropping -- use correct...
commit
|
commitdiff
|
tree
|
snapshot
10 days ago
Karl O. Pinc...
Ensure gen_func_comment_tmpl() is installed for recreat...
commit
|
commitdiff
|
tree
|
snapshot
10 days ago
Karl O. Pinc...
Install gen_func_comment_tmpl() only when comments...
commit
|
commitdiff
|
tree
|
snapshot
10 days ago
Karl O. Pinc...
Update docs with new view code regardless of db DDL...
commit
|
commitdiff
|
tree
|
snapshot
10 days ago
Karl O. Pinc
Add ESTRUS_STATES and ESTRUS_SOURCES to diagram
commit
|
commitdiff
|
tree
|
snapshot
10 days ago
Karl O. Pinc
Remove estrus columns from SIGHTINGS
commit
|
commitdiff
|
tree
|
snapshot
10 days ago
Karl O. Pinc
Add NON_BREC_SIGHTING_SOURCES to diagram
commit
|
commitdiff
|
tree
|
snapshot
2026-02-10
Karl O. Pinc...
Initial design of SIGHTINGS
commit
|
commitdiff
|
tree
|
snapshot
2025-11-10
Karl O. Pinc...
Add arrival warning of contiguous time periods
commit
|
commitdiff
|
tree
|
snapshot
2025-11-10
Karl O. Pinc...
Document that event start and stop times are inclusive
commit
|
commitdiff
|
tree
|
snapshot
2025-11-10
Karl O. Pinc...
Note that there is a warning only when "certain" arriva...
commit
|
commitdiff
|
tree
|
snapshot
2025-11-10
Karl O. Pinc...
Remove redundant arrivals warnings
commit
|
commitdiff
|
tree
|
snapshot
2025-11-10
Karl O. Pinc...
Add CYCLE_STATES.AsNum column
commit
|
commitdiff
|
tree
|
snapshot
2025-11-10
Karl O. Pinc...
Add a "double precision" replacement text
commit
|
commitdiff
|
tree
|
snapshot
2025-11-01
Karl O. Pinc...
Put a TOC in each table's docs above the column docs
commit
|
commitdiff
|
tree
|
snapshot
2025-11-01
Karl O. Pinc...
Actually use the FOLLOW_STUDIES summary in the docs
commit
|
commitdiff
|
tree
|
snapshot
2025-11-01
Karl O. Pinc...
Add verbage describing code tables; move TOC to below...
commit
|
commitdiff
|
tree
|
snapshot
2025-11-01
Karl O. Pinc...
Document ARRIVALS.Seq
commit
|
commitdiff
|
tree
|
snapshot
2025-11-01
Karl O. Pinc...
Add warnings regarding strange ARRIVALS rows
commit
|
commitdiff
|
tree
|
snapshot
2025-11-01
Karl O. Pinc...
Fix markup
commit
|
commitdiff
|
tree
|
snapshot
2025-10-27
Karl O. Pinc...
Remove trailing spaces from follow_arrival.fa_fol_b_foc...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-24
Karl O. Pinc...
Fix lateral joins
commit
|
commitdiff
|
tree
|
snapshot
2025-10-24
Karl O. Pinc...
Update nesting state in clean during conversion; Proble...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-24
Karl O. Pinc...
Updated community membership rules
commit
|
commitdiff
|
tree
|
snapshot
2025-10-24
Karl O. Pinc...
Adjust conversion for BIOGRAPHY_DATA.DadPrelim -> DadSt...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-24
Karl O. Pinc...
Change BIOGRAPHY_DATA.DadPrelim to DadStatus, update...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-24
Karl O. Pinc...
Create and document the DAD_STATUSES support table
commit
|
commitdiff
|
tree
|
snapshot
2025-10-24
Karl O. Pinc...
Solve conversion problem #51, codes in db are ok to use
commit
|
commitdiff
|
tree
|
snapshot
2025-10-24
Karl O. Pinc...
Solve conversion problem #50; females with n/a cycle...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-23
Stevan Earl
docs(schema): clarify that biography_log.dateofudpate...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-23
Stevan Earl
docs(erd): show nullability and quoted identifiers...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-15
Karl O. Pinc...
Cannot be too old or too young when the cycle code...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-13
Karl O. Pinc...
Support converting a single table using multiple, seria...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-12
Karl O. Pinc...
Add additional conditions to avoid unnecessary queries...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-12
Karl O. Pinc...
Fix code comments describing too-early birth
commit
|
commitdiff
|
tree
|
snapshot
2025-10-12
Karl O. Pinc...
Fix maximum female adolescent swelling (sdb_adolsecent_...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-12
Karl O. Pinc...
Fix test for minimum adolescent U swelling code
commit
|
commitdiff
|
tree
|
snapshot
2025-10-12
Karl O. Pinc...
Adjust female adolescent age limits
commit
|
commitdiff
|
tree
|
snapshot
2025-10-11
Karl O. Pinc...
Cleanup of problem #31 and #32 taken care of in clean...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-11
Karl O. Pinc...
Split load_data.sql into multiple files to support...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-11
Karl O. Pinc...
Standardize error messages in triggers
commit
|
commitdiff
|
tree
|
snapshot
2025-10-10
Karl O. Pinc
Add ARRIVALS.Seq column to diagram
commit
|
commitdiff
|
tree
|
snapshot
2025-10-10
Karl O. Pinc...
Initial converson of follow_arrival table
commit
|
commitdiff
|
tree
|
snapshot
2025-10-09
Karl O. Pinc...
Fix reporting of ROLES.PID in error messages
commit
|
commitdiff
|
tree
|
snapshot
2025-10-09
Karl O. Pinc...
Fix the ARRIVALS trigger to correct Cycle column name
commit
|
commitdiff
|
tree
|
snapshot
2025-10-09
Karl O. Pinc...
Fix problems #31 and #32 by trimming spaces and upper...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-09
Karl O. Pinc...
There can be at most one arrival per event
commit
|
commitdiff
|
tree
|
snapshot
2025-10-09
Karl O. Pinc...
An ARRIVALS row must be related to an event with Behavi...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-09
Karl O. Pinc...
Use mixed-case people where possible; conversion proble...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-09
Karl O. Pinc...
Resolve problem #37
commit
|
commitdiff
|
tree
|
snapshot
2025-10-09
Karl O. Pinc...
Note what solves conversion problem #38
commit
|
commitdiff
|
tree
|
snapshot
2025-10-09
Karl O. Pinc...
Change so sdb_male_swelling cannot be assigned to females
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Mark PEOPLE with "/" in their name inactive; conversion...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Change minimum age of first birth from 8 to 10 years
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Validate the use of CYCLE_STATES codes
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Prevent ARRIVALS.ArID from changing
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Prevent ROLES.Participant from changing
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
ROLES.Participant must be under study
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Prevent EVENTS.FID from changing
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Create and document the ARRIVALS table
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Add substitution reference for "tri-valued logic"
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Enforce single-ROLE row restrction for arrival events
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Prevent ROLES.EID from changing
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Prevent EVENTS.Behavior from changing
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
More documentation of EVENTS.Behavior related rules
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Implement Start and Stop column constraints on EVENTS
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Initial trigger on ROLES, prevent PID change
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Initial trigger on EVENTS, prevent EID change
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Add ARRIVAL_SOURCES table; codes for arrvial/departure...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Index ROLES
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Index EVENTS
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Convert FOLLOW_STUDIES
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Index FOLLOW_STUDIES
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Index FOLLOW_OBSERVERS
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Make ROLE_CODES.Role unique when ignoring case
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Make PEOPLE.Person unique when ignoring case
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Make OBS_PERIODS.Period unique when ignoring case
commit
|
commitdiff
|
tree
|
snapshot
2025-10-08
Karl O. Pinc...
Make CYCLE_STATES.Code unique when ignoring case
commit
|
commitdiff
|
tree
|
snapshot
2025-10-03
Karl O. Pinc...
Make COMM_MEMBS_SOURCES.CommMembSource unique when...
commit
|
commitdiff
|
tree
|
snapshot
2025-10-03
Karl O. Pinc...
Make COMM_IDS.Name unique when ignoring case
commit
|
commitdiff
|
tree
|
snapshot
2025-10-03
Karl O. Pinc...
Make comm_ids.CommID unique when ignoring case
commit
|
commitdiff
|
tree
|
snapshot
next