←
Entity Relationship Diagrams
Demography
→
Key
¶
Key to the Entity Relationship Diagrams
¶
Page last generated: 2026-07-05 18:38:43 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
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)
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
AGGRESSION_EVENT_LOG
AGGRESSIONS
ARRIVALS
ARRIVALS_A
BIOGRAPHY_DATA
BIOGRAPHY_LOG
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
REPRO_STATES
SWELLING_STATES
SIGHTINGS
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
Entity Relationship Diagrams
Previous:
Entity Relationship Diagrams
Next:
Demography
Quick search
