• ← SIGHTINGS
  • AGGRESSION_EVENT_LOG →

Housekeeping TablesΒΆ

The tables listed are used to track data entry history and other administrative operations.

The tables in this section are all in the housekeeping schema.

  • AGGRESSION_EVENT_LOG
    • ID (IDentifier)
    • Year
    • CommID
    • BRecEnglish
    • ARecSwahili
    • ARecEnglishNotes
    • ARecBookExtract
    • BRecSwahili
    • BRecBookExtract
    • MaInfBookExtract
    • MaInf
    • Schroepfer
    • Notes
  • BIOGRAPHY_LOG
    • BLID (Biography Log IDentifier)
    • DateOfUpdate
    • AnimID (Animal IDentifier)
    • Description
    • Rationale
    • MadeBy
  • CHIMPS_ON_TIKIS
    • ID (IDentifier)
    • AnimID
    • CommID
    • TikiCreationDate
    • TikiDeploymentDate
    • Newcomer
  • FOOD_VARIATIONS
    • ID (IDentifier)
    • Variant
    • LocalName
  • COMMUNITY_MEMBERSHIP_UPDATE_LOG
    • ID (IDentifier)
    • DateOfUpdate
    • AnimID
    • Description
    • Rationale
    • MadeBy
  • PANTGRUNT_EVENT_LOG
    • ID (IDentifier)
    • Year
    • ARecSwahili
    • ARecEnglishNotes
    • ARecASR
    • BRecEnglish
    • BRecASRExtractions
    • MAINFASRExtractions
    • MAINF
    • AdolescentStudyTalliesPusey
    • Greengrass
    • Murray
    • OMally
    • Heintz
    • OBryan
    • Schroepfer
    • Notes
  • SIV_STATUS_BOUT
    • ID (IDentifier)
    • AnimID
    • StartDate
    • EndDate
    • SIVStatus
    • FirstTestDate
    • LastTestDate
    • BoutNumber
    • NamesUsed
    • InBioTable
    • Notes
  • SUBADULT_ARRIVALS_LOG
    • ID (IDentifier)
    • AnimID
    • FirstTikiDate
    • Notes
  • TLK_BRECORD_NOTES_CODES
    • ID (IDentifier)
    • Abbreviation
    • Meaning

Page last generated: 2026-07-20 23:28:52 UTC

 
  • ← SIGHTINGS
  • AGGRESSION_EVENT_LOG →

SokweDB Technical Documentation

Navigation

  • 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
  • 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 (Obsevervation Periods)
    • PARITIES (PARITy categorizations)
    • PEOPLE
    • PG_SOURCES (PantGrunt SOURCES)
    • REPRO_STATE_CHANGE_SOURCES
    • ROLE_CODES
    • SIGHTING_RECORDS
    • SPECIES
    • STUDIES (Studies that follows are part of)
  • Data Tables
    • AGGRESSIONS
    • ARRIVALS
    • ARRIVALS_A
    • BIOGRAPHY_DATA
    • BRECORD_NOTES
    • COLOBUS (COLOBUS encounters)
    • COMM_MEMBS
    • COMM_MEMB_LOG
    • SWELLING_SOURCES
    • EVENTS
    • FOLLOW_OBSERVERS
    • FOLLOW_STUDIES
    • FOOD_EVENTS
    • GROOM_SCANS_B
    • GROOMINGS
    • HUMANS
    • LOCATIONS_UTM (spatial LOCATIONS in UTM coordinates)
    • LOCATIONS_PAPER (spatial LOCATIONS in map numbers)
    • MATINGS
    • PANTGRUNTS
    • ROLES
    • NON_BREC_SIGHTING_SOURCES
    • SPECIES_PRESENT
    • 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
    • FOOD_VARIATIONS
    • COMMUNITY_MEMBERSHIP_UPDATE_LOG
    • PANTGRUNT_EVENT_LOG
    • SIV_STATUS_BOUT
    • SUBADULT_ARRIVALS_LOG
    • TLK_BRECORD_NOTES_CODES
  • Data Retrieval Views
    • BIOGRAPHY
  • Data Modification Views
    • DYADS
    • OBS (OBservationS)
    • PANTGRUNTS_VIEW
  • SQL Functions
    • build_arrivals_seq() – Rebuild the ARRIVALS.Seq column
    • julian() – Convert a date to an integer which counts up by day
    • julian_to() – Convert an integer which counts days to a date
  • APPENDIXES
    • Restrictions: Things Not To Do
    • Technologies Used

  • HOME

Related Topics

  • Documentation overview
    • Previous: SIGHTINGS
    • Next: AGGRESSION_EVENT_LOG

Quick search

©2019, 2023 The Meme Factory, Inc.. | Powered by Sphinx 7.1.0 & Alabaster 0.7.13