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