• ← 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
  • FOLLOWS
    • FID (Follow ID)
    • Focal (Focal animal id)
    • Community
    • Date
    • Notes
  • FOLLOW_ARRIVALS
    • FAID (Follow Arrivals ID)
    • FID (Follow IDentifier)
    • AnimID (Animal ID)
    • Seq (Sequence Number)
    • Start
    • End
    • Certainty
    • NestStart
    • NestEnd
    • Cycle
    • DataSource
  • 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

Page last generated: 2025-04-12 18:47:18 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)
    • 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
    • Previous: Code Tables
    • Next: BIOGRAPHY_DATA

Quick search

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