←
Entity Relationship Diagrams
Demography
→
Key
¶
Key to the Entity Relationship Diagrams
¶
Page last generated: 2025-09-21 23:28:01 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
COMM_IDS (Community IDentifiers)
COMM_MEMBS_SOURCES (COMMunity MEMBershipS SOURCES)
DEPARTTYPES (community Departure reasons)
ENTRYTYPES (community Entry reasons)
CERTAINTIES
CYCLE_STATES
OBS_PERIODS (Obsevervation Periods)
PEOPLE
ROLE_CODES
SPECIES
STUDIES (Studies that follows are part of)
Data Tables
BIOGRAPHY_DATA
BIOGRAPHY_LOG
COMM_MEMBS
COMM_MEMB_LOG
EVENTS
FOLLOWS
FOLLOW_OBSERVERS
FOLLOW_STUDIES
HUMANS
ROLES
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
