←
Entity Relationship Diagrams
Demography
→
Key
¶
Key to the Entity Relationship Diagrams
¶
Page last generated: 2026-06-12 16:40:37 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
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
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
WATCHES
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
HOME
Related Topics
Documentation overview
Entity Relationship Diagrams
Previous:
Entity Relationship Diagrams
Next:
Demography
Quick search
