Table Overview

The data in Babase are stored in tables. Tables can be visualized as grids, with rows and columns. Each row represents a single real-world thing or event, an entity, e.g. a baboon. Each cell in the row contains a single unit of information, e.g. a birth date, a name, and a sex. The row holds the entirety of the information belonging to the entity as an isolated thing, e.g. baboon database entities consist of a birth date, a name, and a sex. Each column contains one and only one kind of information, e.g. birth date.

Table 2.1 is an example of a database table that might be used to represent baboons, one baboon per row. Notice that each cell contains one and exactly one unit of information.

Table 2.1. A Simple Database Table

Birth Name Sex
May 23, 1707 Alice Female
February 12, 1809 Bob Male
July 22, 1822 Carol Female

Anyone working with Babase will require a familiarity with the database's tables. An understanding of the entity each row represents is critical when working with a table. The remainder of this section provides short definitions of the entities each table holds in its rows.

Some of the tables in Babase exist to define a vocabulary. These are the support tables. For lack of a better term, the remainder of the tables are labeled main tables in Table 2.2.

Warning

Tables which have names ending in _DATA should not be used, there is always a view of the data in these tables that may be used in their place. Tables ending in _DATA may change in future Babase minor releases, breaking queries and programs which use the table. Use of the corresponding views will ensure compatibility with future Babase releases.

Table 2.2. The Main Babase Tables

Group Membership and Life Events
Table One row for each
ALTERNATE_SNAMES rescinded sname
BIOGRAPH animal, including fetuses
CENSUS day each individual is (or is not) observed in a group
CONSORTDATES male who has a known first consortship
DEMOG mention of an individual's presence in a group within a field textual note
DISPERSEDATES male who has left his maternal study group
GROUPS group (including solitary males)
MATUREDATES individual who is sexually mature
RANKDATES individual[a] who has attained adult rank
 
Analyzed: Group Membership and Life Events
Table One row for each
DAD_DATA offspring having a paternity analysis
MEMBERS day each individual is alive
RANKS month each individual is ranked in each group
 
Sexual Cycles
Table One row for each
CYCGAPS female for each initiation or cessation of a continuous period of observation
CYCLES female's cycle (complete or not)
CYCPOINTS Mdate (menses), Tdate (turgesence onset), or Ddate (deturgesence onset) date of each female
PCSKINS PCS color of each female
PREGS time a female becomes pregnant
SEXSKINS sexskin measurement of each female
 
The Sexual Cycle Day-By-Day Tables
Table One row for each
CYCGAPDAYS female for each day within a period during which there is not continuous observation
CYCSTATS day each female is cycling -- by M, T and Ddates
MDINTERVALS day each female is cycling and is between M and Ddates
MMINTERVALS day each female is cycling -- by Mdates
REPSTATS day each female has a known reproductive state
 
Social and Multiparty Interactions
Table One row for each
ALLMISCS free form all-occurrences datum
CONSORTS multiparty dispute over a consortship
FPOINTS point observation of a mature female
INTERACT_DATA interaction between individuals
MPIS collection of multiparty interactions
MPI_DATA single dyadic interaction of a multiparty interaction collection
MPI_PARTS participant in a dyadic interaction of a multiparty interaction collection
PARTS participant in each interaction
POINT_DATA individual point observation
NEIGHBORS neighbor recorded in each point sample
SAMPLES all-occurrences sample
 
Darting
Table One row for each
ANESTHS time additional sedation is administered to a darted individual
BODYTEMPS body temperature measurement taken of a darted individual
CHESTS chest circumference measurement made of a darted individual
CROWNRUMPS crown to rump measurement made of a darted individual
DARTINGS darting of an animal when data was collected
DPHYS darting event during which physiological measurements were taken
DSAMPLES darting event during which tissue samples were taken
DTCULTURES darting event during which tissue samples were taken for culture
HUMERUSES humerous length measurement made of a darted individual
PCVS packed cell volume measurement taken from a darted individual
TEETH possible tooth site within the mouth on which data was collected for every darting event during which dentition data was collected
TESTES_ARC every testicle width/length measurement recorded, as measured along a portion of the circumference
TESTES_DIAM every testicle width/length measurement recorded, as measured along the diameter
TICKS darting event during which data on ticks and other parasites were recorded
ULNAS ulna length measurement made of a darted individual
 
SWERB Data (Group-level Geolocation Data)
Table One row for each
AERIALS aerial photo used for map quadrant specification
GPS_UNITS GPS device
QUAD_DATA SWERB map quadrant
SWERB_BES uninterrupted bout of group-level observation
SWERB_DATA event related to group-level geolocation
SWERB_DEPARTS_DATA departure from camp of a observation team which collected SWERB data
SWERB_GWS geolocated physical object (grove or waterhole)
SWERB_GW_LOC_DATA recorded location of a geolocated physical object (grove or waterhole)
SWERB_LOC_DATA observation of a group at a time at a geolocated physical object
SWERB_LOC_GPS observation of a group at a time at a geolocated physical object made using gps units and a protocol that requires 2 waypoint readings
SWERB_OBSERVERS departure from camp of an observer who drove or collected SWERB data
 
Weather Data
Table One row for each
RAINGAUGES rain gauge reading
RGSETUPS rain gauge installation
TEMPMAXS maximum temperature reading
TEMPMINS minimum temperature reading
WHAWKS weather reading reported by the WeatherHawk instruments
WREADINGS manually collected meteorological data collection event
 

[a] At this time of this writing only males have data entered into RANKDATES.


The significant aspects of the the support tables are: the Id column -- the name of the column holding the vocabulary term, which columns of which tables use the vocabulary, and what sort of vocabulary the table defines. Table 2.3 summarizes this information.

Note

The Id columns throughout Babase do not allow values that are NULL, or which are textual but contain no characters, or which consist solely of spaces.

Table 2.3. The Babase Support Tables

General Support Tables
Table Id Column Related Column(s) One entry for every possible choice of...
OBSERVERS Initials SAMPLES.Observer, WREADINGS.WRperson, RGSETUPS.RGSPerson, CROWNRUMPS.CRobserver, CHESTS.Chobserver, ULNAS.Ulobserver, HUMERUSES.Huobserver, SWERB_OBSERVERS.Observer person who records information
OBSERVER_ROLES Initials OBSERVERS.Role, OBSERVERS.SWERB_Observer_Role, OBSERVERS.SWERB_Driver_Role, SWERB_OBSERVERS.Role way in which a person can be involved in the data collection process
UNKSNAMES Unksname NEIGHBORS.Unksname and the SWERB_UPLOAD view problem in identifying neighbor of focal during point sampling or in identifying a lone male in a SWERB other group observation
 
Group Membership and Life Events
Table Id Column Related Column(s) One entry for every possible choice of...
BSTATUSES Bstatus BIOGRAPH.Bstatus birthday estimation accuracy
CONFIDENCES Dcauseconfidence BIOGRAPH.Dcauseconfidence, DISPERSEDATES.Dispconfidence, BIOGRAPH.Matgrpconfidence degree of certitude in cause of death, disperse date assignment, or maternal group assignment
DAD_SOFTWARE Software DAD_DATA.Software software package used to perform genetic paternity analysis
DCAUSES Dcause BIOGRAPH.Dcause cause of death
DEMOG_REFERENCES Reference DEMOG.Reference data source for demography notes
MSTATUSES Mstatus MATUREDATES.Matured, RANKDATES.Ranked maturity marker date estimation process
RNKTYPES Rnktype RANKS.Rnktype rank ordering assigned to subject and month
STATUSES Status BIOGRAPH.Status baboon alive at last observation
 
Social and Multiparty Interactions
Table Id Column Related Column(s) One entry for every possible choice of...
ACTIVITIES Activity POINT_DATA.Activity activity classification
ACTS Act INTERACT_DATA.Act interaction classification
DATA_STRUCTURES Data_Structure SETUPIDS.Data_Structure version of data structure produced by the palmtops which collect data
CONTEXT_TYPES Context_type MPIS.Context_type context in which a multiparty interaction occurs
FOODCODES Foodcode POINT_DATA.Foodcode name of a food item
FOODTYPES Ftype FOODCODES.Ftype food category
KIDCONTACTS Kidcontact FPOINTS.Kidcontact spatial relationship between mother and infant
MPIACTS Mpiact MPI_DATA.MPIAct multiparty interaction classification
NCODES Ncode NEIGHBORS.Ncode neighbor classification
PALMTOPS Palmtop SAMPLES.Palmtop hand-held computer used in the field
PARTUNKS Unksname MPI_PARTS.Unksname problem in identifying participant in a multiparty interaction
POSTURES Posture POINT_DATA.Posture designated posture
PROGRAMIDS Programid SAMPLES.Programid version of program used on the palmtops to collect data
SETUPIDS Setupid SAMPLES.Setupid setupfile used on the palmtops to collect data
SUCKLES Suckle FPOINTS.Kidsuckle infant suckling activity
 
Sexual Cycles and The Sexual Cycle Day-By-Day Tables
Table Id Column Related Column(s) One entry for every possible choice of...
PCSCOLORS Color PCSKINS.Color paracallosal skin coloration
 
Darting
Table Id Column Related Column(s) One entry for every possible choice of...
BODYPARTS Bodypart TICKS.Bodypart, BODYPARTS.Bodyregion part of the body examined for parasites when darting
DRUGS Drug DRUGS.Drug anesthetic drug
LYMPHSTATES Lymphstate DPHYS.Ringnode, DPHYS.Lingnode, DPHYS.Raxnode, DPHYS.Laxnode, DPHYS.Lsubmandnode, DPHYS.Rsubmandnode lymph node condition
PARASITES PARASITE TICKS.Tickkind parasite species, species developmental stage, or kind of parasite sign counted
TCONDITIONS Tcondition TEETH.Tcondition physical condition of a tooth
TICKSTATUSES Tickstatus TICKS.Tickstatus parasite count outcome category
TOOTHCODES Tooth TEETH.Tooth adult or deciduous tooth
TOOTHSITES Toothsite TOOTHCODES.Toothsite dental site within the mouth
TSTATES Tstate TEETH.Tstate tooth presence
 
SWERB Data (Group-level Geolocation Data)
Table Id Column Related Column(s) One entry for every possible ...
ADCODES ADCode SWERB_LOC_DATA.ADcode relationship between baboon groups and sleeping groves.
SWERB_LOC_CONFS (SWERB sleeping grove Confidences) Conf SWERB_LOC_DATA.Conf level of confidence in sleeping grove on record.
SWERB_TIME_SOURCES Source SWERB_BES.Bsource, SWERB_BES.Esource data source used to estimate beginning and ending of observation bouts
SWERB_XYSOURCES (SWERB Time Sources) Source SWERB_GW_LOC_DATA.XYSource data source used to obtain XY coordinates
 
Weather Data
Table Id Column Related Column(s) One entry for every possible choice of...
WSTATIONS Wstation WREADINGS.Wstation meteorological data collection location or device


Page generated: 2016-07-22T23:08:06-04:00.