Introduction
→
SokweDB
¶
Technical Documentation
¶
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
Indices and tables
¶
Index
Search Page
Page last generated: 2025-09-21 23:28:01 UTC
Introduction
→
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
Next:
Introduction
Quick search