←
Entity Relationship Diagrams
Demography
→
Key
¶
Key to the Entity Relationship Diagrams
¶
Page last generated: 2026-02-10 22:26:46 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
Follows
Events
Code Tables
ARRIVAL_SOURCES (Sources of Arrival and departure data)
COMM_IDS (Community IDentifiers)
COMM_MEMBS_SOURCES (COMMunity MEMBershipS SOURCES)
DEPARTTYPES (community Departure reasons)
ENTRYTYPES (community Entry reasons)
CERTAINTIES
CYCLE_STATES
DAD_STATUSES (Dad ID Statuses)
OBS_PERIODS (Obsevervation Periods)
PEOPLE
ROLE_CODES
SIGHTING_RECORDS
SPECIES
STUDIES (Studies that follows are part of)
Data Tables
ARRIVALS
BIOGRAPHY_DATA
BIOGRAPHY_LOG
COMM_MEMBS
COMM_MEMB_LOG
EVENTS
FOLLOWS
FOLLOW_OBSERVERS
FOLLOW_STUDIES
HUMANS
ROLES
NON_BREC_SIGHTING_SOURCES
SIGHTINGS
SPECIES_PRESENT
Data Retrieval Views
BIOGRAPHY
SQL Functions
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
