SokweDB

Technical Documentation

• Introduction
  • About This Document
  • System Design
• System Architecture
  • Databases
  • Special Data Values
  • Dates and Times
  • Database Permission Levels
  • Logins
  • Schemas
• Entity Relationship Diagrams
  • Key
  • Demography
  • Female Reproduction
  • Watches
  • Events
  • Additional Events
• Views and SokweDB’s Structure
• Data Retrieval Views
  • BIOGRAPHY
  • BREC_NOTES_VIEW (BRECord NOTES VIEW)
• Data Modification Views
  • OBS (OBservationS)
  • DYADS
  • PANTGRUNTS_VIEW
• Data Tables
  • AGGRESSIONS
  • ARRIVALS
  • ARRIVALS_A
  • BIOGRAPHY_DATA
  • BRECORD_NOTES
  • COLOBUS (COLOBUS encounters)
  • COMM_MEMBS
  • EVENTS
  • FOLLOW_OBSERVERS
  • FOLLOW_STUDIES
  • FOOD_EVENTS
  • GROOM_SCANS_B
  • GROOMINGS
  • HUMANS
  • LOCATIONS_PAPER (spatial LOCATIONS in map numbers)
  • LOCATIONS_UTM (spatial LOCATIONS in UTM coordinates)
  • MATINGS
  • NON_BREC_SIGHTING_SOURCES
  • PANTGRUNTS
  • ROLES
  • SPECIES_PRESENT
  • SWELLING_SOURCES
  • WATCHES
• Analyzed Tables
  • ELO_RANKS_DAILY_KK_F
  • ELO_RANKS_DAILY_KK_M
  • ELO_RANKS_DAILY_MT_F
  • ELO_RANKS_DAILY_MT_M
  • FERTILITY
  • REPRO_STATES
  • SWELLING_STATES
  • SIGHTINGS
• Housekeeping Tables
  • AGGRESSION_EVENT_LOG
  • BIOGRAPHY_LOG
  • CHIMPS_ON_TIKIS
  • COMM_MEMB_LOG
  • FOOD_VARIATIONS
  • PANTGRUNT_EVENT_LOG
  • SIV_STATUS_BOUT
  • SUBADULT_ARRIVALS_LOG
  • TLK_BRECORD_NOTES_CODES
• Code Tables
  • AGG_SEVERITIES (AGGression SEVERITIES)
  • ARRIVAL_SOURCES (Sources of Arrival and departure data)
  • CERTAINTIES
  • COLOBUS_GROUP_SIZES
  • COMM_IDS (Community IDentifiers)
  • COMM_MEMBS_SOURCES (COMMunity MEMBershipS SOURCES)
  • CYCLE_STATES
  • DAD_STATUSES (Dad ID Statuses)
  • DEPARTTYPES (community Departure reasons)
  • ED_CERTAINTIES (Estrus Day CERTAINTIES)
  • ENTRYTYPES (community Entry reasons)
  • FOOD_NAMES (FOOD sources)
  • FOOD_PARTS (Parts of Foods)
  • FERTILITY_STARTS (FERTILITY START states)
  • FERTILITY_STOPS (FERTILITY STOP states)
  • LE_CERTAINTIES (Lactation End CERTAINTIES)
  • LOCATION_ORIGINS
  • MATING_SOURCES
  • OBS_PERIODS (Observation Periods)
  • PARITIES (PARITy categorizations)
  • PEOPLE
  • PG_SOURCES (PantGrunt SOURCES)
  • REPRO_STATE_CHANGE_SOURCES
  • ROLE_CODES
  • SIGHTING_CONTROLS
  • SIGHTING_RECORDS
  • SPECIES
  • STUDIES (Studies that follows are part of)
• SQL Functions
  • build_arrivals_seq() – Rebuild the ARRIVALS.Seq column
  • build_sightings() – Rebuild the SIGHTINGS table
  • build_swelling_states() – Rebuild the SWELLING_STATES table
  • julian() – Convert a date to an integer which counts up by day
  • julian_to() – Convert an integer which counts days to a date
• Control Tables
  • SIGHTING_CONTROLS
• APPENDIXES
  • Restrictions: Things Not To Do
  • Technologies Used

Indices and tables

• Index

• Search Page

Page last generated: 2026-08-19 21:06:34 UTC