←
Entity Relationship Diagrams
Demography
→
Key
¶
Key to the Entity Relationship Diagrams
¶
Page last generated: 2026-07-26 00:00:49 UTC
←
Entity Relationship Diagrams
Demography
→
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
Views
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
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
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)
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
Entity Relationship Diagrams
Previous:
Entity Relationship Diagrams
Next:
Demography
Quick search
