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)
  • 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

Indices and tables

• Index

• Search Page

Page last generated: 2025-04-01 22:52:03 UTC