• ← Code Tables
  • BIOGRAPHY_DATA →

Data Tables¶

  • BIOGRAPHY_DATA
    • AnimID (Animal IDentifier)
    • AnimIDNum (Animal IDentifier Number)
    • AnimName (Animal Name)
    • BirthComm (Birth Community)
    • BCCertainty (Birth Community Certainty)
    • Sex
    • MomID (Mother’s AnimID)
    • DadID (Father’s AnimID)
    • DadPrelim (Is Paternity Preliminary?)
    • DadIDPub (Publication of Paternity)
    • FirstBorn
    • BirthDate
    • BDMin (Minimum Birth Date)
    • BDMin (Maximum Birth Date)
    • BDDist (Birth Date Distribution)
    • EntryDate
    • EntryType
    • DepartDate
    • DepartType
  • BIOGRAPHY_LOG
    • BLID (Biography Log IDentifier)
    • DateOfUpdate
    • AnimID (Animal IDentifier)
    • Description
    • Rationale
    • MadeBy
  • COMM_MEMBS
    • CommMID (Community Memberships IDentifier)
    • AnimID (Animal IDentifier)
    • StartDate
    • EndDate
    • CommID (Community IDentifier)
    • StartSource
    • EndSource
  • COMM_MEMB_LOG
    • CommMLID (Community Membership Log IDentifier)
    • DateOfUpdate
    • AnimID (Animal IDentifier)
    • Description
    • Rationale
    • MadeBy
  • EVENTS
    • EID (Event ID)
    • FID (Follow IDentifier)
    • Behavior
    • Start
    • Stop
    • Certainty
    • Notes
  • FOLLOWS
    • FID (Follow ID)
    • Focal (Focal animal id)
    • Community
    • Date
    • Notes
  • FOLLOW_OBSERVERS
    • FOID (Follow Observers ID)
    • FID (Follow IDentifier)
    • Period
    • OBS_BRec (Observation’s BRec)
    • OBS_Tiki (Observation’s Tiki)
  • FOLLOW_STUDIES
    • FSID (Follow Studies ID)
    • FID (Follow IDentifier)
    • Code
  • HUMANS
    • HID (Humans ID)
    • EID (Event IDentifier)
    • Researchers
    • NonResearchers
  • ROLES
    • PID (Participant ID)
    • EID (Event ID)
    • Role
    • Participant
  • SPECIES_PRESENT
    • OSID (Other Species ID)
    • EID (Event IDentifier)
    • Species

Page last generated: 2025-09-21 23:28:01 UTC

 
  • ← Code Tables
  • BIOGRAPHY_DATA →

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
    • Previous: Code Tables
    • Next: BIOGRAPHY_DATA

Quick search

©2019, 2023 The Meme Factory, Inc.. | Powered by Sphinx 7.1.0 & Alabaster 0.7.13