←
Entity Relationship Diagrams
Demography
→
Key
¶
Key to the Entity Relationship Diagrams
¶
Page last generated: 2026-08-19 21:06:34 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 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
HOME
Related Topics
Documentation overview
Entity Relationship Diagrams
Previous:
Entity Relationship Diagrams
Next:
Demography
Quick search
