←
Entity Relationship Diagrams
Demography
→
Key
¶
Key to the Entity Relationship Diagrams
¶
Page last generated: 2025-04-12 18:47:18 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)
DATA_SOURCES (Sources of follow arrival Data)
DEPARTTYPES (community Departure reasons)
ENTRYTYPES (community Entry reasons)
CYCLE_STATES
FA_CERTAINTIES (Follow Arrival Certainties)
OBS_PERIODS (Obsevervation Periods)
PEOPLE
STUDIES (Studies that follows are part of)
Data Tables
BIOGRAPHY_DATA
BIOGRAPHY_LOG
COMM_MEMBS
COMM_MEMB_LOG
FOLLOWS
FOLLOW_ARRIVALS
FOLLOW_OBSERVERS
FOLLOW_STUDIES
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
