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
  • Follows
  • Events
• Code Tables
  • AGG_SEVERITIES (AGGression SEVERITIES)
  • ARRIVAL_SOURCES (Sources of Arrival and departure data)
  • CERTAINTIES
  • 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)
  • LE_CERTAINTIES (Lactation End CERTAINTIES)
  • FOOD_NAMES (FOOD sources)
  • FOOD_PARTS (Parts of Foods)
  • LOCATION_ORIGINS
  • 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
  • AGGRESSION_EVENT_LOG
  • AGGRESSIONS
  • ARRIVALS
  • ARRIVALS_A
  • ATTENDANCE
  • BIOGRAPHY_DATA
  • BIOGRAPHY_LOG
  • COMM_MEMBS
  • COMM_MEMB_LOG
  • SWELLING_SOURCES
  • EVENTS
  • FOLLOWS
  • FOLLOW_OBSERVERS
  • FOLLOW_STUDIES
  • FOOD_EVENTS
  • GROOM_SCANS_B
  • GROOMINGS
  • HUMANS
  • LOCATIONS_B (spatial LOCATIONS from B records)
  • PANTGRUNTS
  • ROLES
  • NON_BREC_SIGHTING_SOURCES
  • SPECIES_PRESENT
• Analyzed Tables
  • REPRO_STATES
  • SWELLING_STATES
  • SIGHTINGS
• Data Retrieval Views
  • BIOGRAPHY
• 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

Indices and tables

• Index

• Search Page

Page last generated: 2026-06-09 21:58:03 UTC