object_type object_name object_comment schema babase The main schema. Everything documented in the tech specs is found here schema babase_history Contains history tables that archive past versions of data from tables in the babase schema table activities Support table for the POINT_DATA.Activity column table acts Support table for the POINTS.Act column table adcodes Support table for the SWERB_LOC_DATA.Adcode column table aerials Photos used for creation of the quad system used in early SWERB data table allmiscs Miscellaneous data (usually notes/comments) from focal samples table alternate_snames Cases where an individual was given one Sname and later had that Sname changed table anesths Each time additional sedation is administered to a darted individual. Tip: use the ANESTH_STATS view instead table behave_gaps Periods of time during which data for an indicated group are sparse, lacking, or lower than normal for some known reason table biograph Basic biographical info about every baboon, including stillbirths and fetal deaths/losses table bodyparts Support table for the TICKS.Bodypart and WP_AFFECTEDPARTS.Bodypart columns table bodytemps Body temperature measurements for darted individuals table bstatuses Support table for the BIOGRAPH.Bstatus column table census A record of which baboons were present (or not) in a group on dates when the group was observed table chests Chest circumference measurements for darted individuals table confidences Support table for the BIOGRAPH.DcauseNatureConfidence and DcauseAgentConfidence, DISPERSEDATES.Dispconfidence, BIOGRAPH.MatgrpConfidence columns table consortdates Date of male''s first consortship table consorts Consort-related info from multiparty interactions table context_types Support table for the MPIS.Context_type column table crownrumps Crown-to-rump measurements for darted individuals table cycgapdays Day-by-day record of days when a female is not under regular observation table cycgaps Indicates when continuous observation of an adult female''s cycling state ceased or resumed and dates when a female was observed within an observation gap table cycles Adult females'' sexual cycles, one row per cycle table cycpoints Adult females'' sexual cycles, one row per cycling event table cycstats Day-by-day record for cycling females, indicating which phase of cycling a female is in table dads_analyses Every paternity analysis performed, per individual table dads_completeness Support table for the DADS_CONSENSUS.Completeness column table dads_consensus All known paternities, based on the consensus of analyses table dads_evidence The data from all paternity analyses table dads_evidence_terms Support table for the DADS_EVIDENCE.Term column table dads_mismatches Support table for the DADS_Consensus.Mismatch column table dart_sample_cats Support table for the DART_SAMPLE_TYPES.DS_Cat column table dart_sample_types Support table for the DART_SAMPLES.DS_Type column table dart_samples Samples collected from darted individuals table dartings Basic info about every baboon darting table data_structures Support table for the SETUPIDS.Data_Structure column table dcauses Support table for the BIOGRAPH.Dcause column table deathnatures Support table for the DCAUSES.Nature column table demog Demography notes recording movements of members in and out of the group, demographically relevant behaviors, descriptions of new males, etc., as well as census information recorded for members of nonstudy groups or group members not recorded present in the census table demog_references Support table for the DEMOG.Reference column table digital_weather Hourly data automatically collected by electronic weather stations table dispersedates Date of male''s dispersal table dphys Physiological measurements from darted individuals table drugs Support table for the DARTINGS.Drug and ANESTHS.Drug columns table entrytypes Support table for the BIOGRAPH.Entrytype column table flow_cytometry Results from flow cytometric analyses of PBMCs collected during dartings table foodcodes Support table for the POINT_DATA.Foodcode column table foodtypes Support table for the FOODCODES.Ftype column table fpoints Data from focal points that are exclusive to adult female samples table gap_end_statuses Support table for the BEHAVE_GAPS.Gap_End_Status column table gps_units GPS units used for SWERB data collection table groups Basic info about every baboon group table hormone_ids Support table for the HORMONE_KITS.Hormone column table hormone_kits The kits or protocols used to assay hormone concentration table hormone_prep_data The hormone lab preps. Tip: use HORMONE_PREPS view table hormone_prep_procedures Support table for the HORMONE_PREP_DATA.Procedure column table hormone_prep_series The different series of hormone preps and assays table hormone_result_data The hormone assay results. Tip: lots of views to use instead of this table hormone_sample_data Hormone-specific info about hormone samples. Tip: use HORMONE_SAMPLES view table humeruses Humerus length measurements from darted individuals table hybridgene_analyses Each analysis performed to generate genetic hybrid scores table hybridgene_scores The genetic hybrid scores table hybridgene_software Support table for the HYBRIDGENE_ANALYSES.Software column table hybridmorph_observers The observers of the morphological hybrid scores table hybridmorph_reports The instances where an individual''s hybrid morphology was scored table hybridmorph_score_data The hybrid morphology scores table institutions Support table for the Institution column in LOCATIONS, NUCACID_LOCAL_IDS, and TISSUE_LOCAL_IDS table integrity_queries The queries used by the warning system to generate warnings table integrity_warnings Warnings generated from the queries in INTEGRITY_QUERIES table interact_data Every dyadic (not multipary) interaction. Tip: use the ACTOR_ACTEES view instead table iqtypes Support table for INTEGRITY_QUERIES.Type table kidcontacts Support table for the FPOINTS.Kidcontact column table lab_personnel Support table for the HYBRIDGENE_ANALYSES.Analyzed_By, NUCACID_CREATORS.Creator, and WBC_COUNTS.Counted_By columns table locations The possible places where samples in the inventory may be located table lymphstates Support table for the DPHYS.Ringnode, Lingnode, Raxnode, Laxnode, Lsubmandnode, and Rsubmandnode columns table markers Support table for the HYBRIDGENE_ANALYSES.Marker column table maturedates Date when individuals reached sexual maturity. Menarche for females, testicular enlargement for males table mdintervals Day-by-day record of number of days since the last Mdate and until the next Ddate table members Records which group each individual is in on a given date including interpolation of presence or absence on dates between censuses table misid_statuses Support table for the TISSUE_DATA.Misid_Status column table mmintervals Day-by-day record of number of days since the last Mdate and until the next Mdate table mpi_data Each interaction in a multiparty interaction series. Tip: use the MPI_EVENTS view instead table mpi_parts Each participant in an interaction in a multiparty interaction series. Tip: use the MPI_EVENTS view instead table mpiacts Support table for the MPI_DATA.MPIAct column table mpis Each complete series of multiparty interactions. Tip: use the MPI_EVENTS view instead table mstatuses Support table for the MATUREDATES.Mstatus and RANKDATES.Rstatus columns table ncodes Support table for the NEIGHBORS.Ncode column table neighbors The focal individual''s neighbors at the time of the specified focal point table nucacid_conc_data Concentration data for nucleic acid samples. Tip: use the NUCACID_CONCS or NUCACIDS_W_CONC views table nucacid_conc_methods Support table for the NUCACID_CONC_DATA.Conc_Method column table nucacid_creation_methods Support table for the NUCACID_DATA.Creation_Method column table nucacid_creators Lab personnel involved with creating nucleic acid samples table nucacid_data Every nucleic acid sample. Tip: use the NUCACIDS view table nucacid_local_ids The ID''s used in different locales to identify nucleic acid samples table nucacid_sources Source info for nucleic acid samples generated from other nucleic acid samples table nucacid_types Support table for the NUCACID_DATA.NucAcid_Type column table observer_roles Support table for the OBSERVERS.Role and SWERB_OBSERVERS.Role columns table observers Support table for MANY different tables table parasites Support table for the TICKS.Tickkind column table parts The participants in dyadic (not multiparty) interactions. Tip: use the ACTOR_ACTEES view instead table partunks Support table for the MPI_PARTS.Unksname column table pcscolors Support table for the SEXSKINS.Color column table pcvs Packed cell volume measurements from darted individuals table place_types Support table for the SWERB_GWS.Type column table point_data Each point observation in a focal sample table populations The different populations whose individuals might appear in UNIQUE_INDIVS and the inventory table postures Support table for POINT_DATA.Posture table predators Support table for the SWERB_DATA.Predator column table pregs One row for each known pregnancy table programids Support table for the SAMPLES.Programid column table quad_data The map quadrants used in early SWERB data to indicate location table raingauges Every reading from a rain gauge table rankdates Date of ADULT male rank attainment table ranks Dominance ranks of individuals within social groups table repstats Day-by-day record indicating whether a female is pregnant, lactating, or cycling table repro_notes Reproduction-related text notes about females table residencies Residency from MEMBERS, condensed into bouts table rgsetups Every rain gauge used table rnktypes Support table for the RANKS.Rnktype column table samples Every focal sample table samples_collection_systems Support table for the SAMPLES.Collection_System column table setupids Support table for the SAMPLES.Setupid column table sexskins Each observation of a female''s sexskin size and/or color table statuses Support table for the BIOGRAPH.Status column table storage_media Support table for the TISSUE_DATA.Storage_Medium column table stypes Support table for the SAMPLES.SType column table stypes_activities (IMPORTANT FOR VALIDATING DATA, BUT PROBABLY NOT USEFUL FOR REGULAR USERS) Support table controlling which POINT_DATA.Activity values can be used with which SAMPLES.SType values table stypes_ncodes (IMPORTANT FOR VALIDATING DATA, BUT PROBABLY NOT USEFUL FOR REGULAR USERS) Support table controlling which NEIGHBORS.Ncode values can be used with which SAMPLES.SType values table stypes_postures (IMPORTANT FOR VALIDATING DATA, BUT PROBABLY NOT USEFUL FOR REGULAR USERS) Support table controlling which POINT_DATA.Posture values can be used with which SAMPLES.SType values table suckles Support table for the FPOINTS.Kidsuckle column table swerb_bes Bouts of observation on a group in SWERB data table swerb_data Every event recorded in SWERB, except departures and descent/ascent times. Tip: use the SWERB view instead table swerb_departs_data Every departure from camp that included collection of SWERB data. Tip: use the SWERB_DEPARTS view instead table swerb_departs_gps GPS info for every SWERB departure of a team that used GPS units table swerb_gw_loc_data Every time the location or coordinates of a SWERB "place" was recorded table swerb_gws All the possible SWERB places, especially groves and waterholes table swerb_loc_confidences Support table for the SWERB_LOC_DATA_CONFIDENCES.Confidence column table swerb_loc_data Every time a group was observed at a SWERB "place" table swerb_loc_data_confidences Confidence scores for each SWERB observation of a location table swerb_loc_gps Secondary GPS coordinates recorded for a SWERB "place". In practice, these are the coordinates for MDTs and MATs table swerb_loc_statuses Support table for the SWERB_LOC_DATA.Loc_Status column table swerb_observers The observers recorded for each SWERB departure table swerb_time_sources Support table for the SWERB_BES.Bsource and Esource columns table swerb_xysources Support table for the SWERB_GW_LOC_DATA.XYSource column table tconditions Support table for the TEETH.Tcondition column table teeth Tooth observations (per tooth) from darted individuals table tempmaxs Every time a maximum temperature was recorded table tempmins Every time a minimum temperature was recorded table testes_arc Testicle circumference measurements from darted individuals table testes_diam Testicle diameter measurements from darted individuals table ticks Ticks and other parasites observed on darted individuals table tickstatuses Support table for the TICKS.Tickstatus column table tissue_data Every tissue sample. Tip: use the TISSUES view table tissue_local_ids The ID''s used in different locales to identify tissue samples table tissue_sources Source info for tissue samples generated from other tissue samples table tissue_types Support table for the TISSUE_DATA.Tissue_Type column table toothcodes Support table for the TEETH.Tooth column table toothsites Support table for the TOOTHCODES.Toothsite column table trees Every tree in the tree monitoring project table tstates Support table for the TEETH.Tstate column table ulnas Ulna length measurements from darted individuals table unique_indivs Every individual from BIOGRAPH and/or who appears in the inventory table unksnames Support table for the NEIGHBORS.Unksname column table vaginal_phs Vaginal pH measurements from darted females table warning_remarks Notes and explanations that may be applied to warnings in the INTEGRITY_WARNINGS table table wbc_counts Contains WBC counts from smears of blood collected during a darting table weather_softwares Support table for the DIGITAL_WEATHER.Wsoftware column table wp_affectedparts The body parts affected by the specified wound/pathology cluster table wp_details Wound/pathology type, number, and effects, per "cluster" table wp_healstatuses Support table for the WP_HEALUPDATES.HealStatus column table wp_healupdates Wound/pathology healing updates table wp_observers The observers recorded for each wound/pathology report table wp_reports Basic information (such as sname, date, grp) about a given wound/pathology report table wp_reportstates Support table for the WP_REPORTS.ReportState column table wp_woundpathcodes Support table for the WP_DETAILS.WoundPathCode column table wreadings Each time someone collected meteorological data table wstations Support table for the Wstation column in WREADINGS, RGSETUPS, and DIGITAL_WEATHER view actor_actees All dyadic (non-multiparty) interactions view anesth_stats Calculates statistics for anesthetic administered in dartings view birth_grp BIOGRAPH, with the MEMBERS.Grp on the individual''s Birth view bodytemp_stats Calculates statistics for body temp measurements in dartings view census_demog CENSUS, with DEMOG rows if any view census_demog_sorted CENSUS, with DEMOG rows if any, sorted by sname, date view chest_stats Calculates statistics for chest circumference measurements in dartings view consortdates_grp CONSORTDATES, with the individual''s MEMBERS.Grp on that date view crownrump_stats Calculates statistics for crown-to-rump measurements in dartings view cycgapdays_grp CYCGAPDAYS, with the individual''s MEMBERS.Grp on that date view cycgaps_grp CYCGAPS, with the individual''s MEMBERS.Grp on that date view cycles_sexskins CYCLES, with related SEXSKINS rows if any view cycles_sexskins_sorted CYCLES, with related SEXSKINS rows if any, sorted by sname, date view cycpoints_cycles CYCPOINTS and CYCLES together view cycpoints_cycles_sorted CYCPOINTS and CYCLES together, sorted by sname, date view cycstats_grp CYCSTATS, with the individual''s MEMBERS.Grp on that date view dart_flow_cytometry_upload Used only for uploading darting flow cytometry data view dart_logistics_upload Used only for uploading darting logistics data view dart_morphology_upload Used only for uploading darting morphology data view dart_physiology_upload Used only for uploading darting physiology data view dart_samples_upload Used only for uploading darting samples data view dart_teeth_upload Used only for uploading darting teeth data view dart_testes_arc_upload Used only for uploading darting testes circumference data view dart_testes_diam_upload Used only for uploading darting testes diameter data view dart_ticks_upload Used only for uploading darting ticks data view dart_vaginal_phs_upload Used only for uploading darting vaginal pH data view dart_wbc_counts_upload Used only for uploading darting white blood cell count data view dartings_grp DARTINGS, with the individual''s MEMBERS.Grp on that date view demog_census DEMOG, with related CENSUS view demog_census_sorted DEMOG, with related CENSUS, sorted by sname, date view dent_codes Tooth observations (per darting) from darted individuals. Teeth designated by description, e.g. "right upper molar 1" view dent_sites Tooth observations (per darting) from darted individuals. Teeth designated by number, 1-32 view dispersedates_grp DISPERSEDATES, with the individual''s MEMBERS.Grp on that date view dsamples Samples collected from darted individuals view entrydate_grp BIOGRAPH, with the MEMBERS.Grp on the individual''s Entrydate view estrogens Sample- and lab-related info for every sample with an estrogen assay view glucocorticoids Sample- and lab-related info for every sample with a glucocorticoid assay view groups_history GROUPS with some helpful calculated columns view hormone_preps HORMONE_PREP_DATA, expanded to be more useful view hormone_results HORMONE_RESULT_DATA, expanded to be more useful view hormone_samples HORMONE_SAMPLE_DATA, expanded to be more useful view hybridmorph_scores The morphological hybrid scores, one row per sname-date view humerus_stats Calculates statistics for humerus length measurements in dartings view interact INTERACT_DATA with enhanced dates and times view interact_sorted INTERACT_DATA with enhanced dates and times, sorted by iid view locations_free Every location in LOCATIONS that is NOT used in TISSUE_DATA and NUCACID_DATA view maternities Cycling, conception, and birth info for every birth and fetal loss view maturedates_grp MATUREDATES, with the individual''s MEMBERS.Grp on that date view mdintervals_grp MDINTERVALS, with the individual''s MEMBERS.Grp on that date view min_maxs All manually-collected weather data view min_maxs_sorted All manually-collected weather data, sorted by wrdaytime, wstation view mmintervals_grp MMINTERVALS, with the individual''s MEMBERS.Grp on that date view mpi_events All multiparty interaction data view mpi_upload Used for uploading multiparty interaction data view mtd_cycles For every cycle, shows the Mdate, Tdate, and Ddate view nucacid_concs Concentration data for nucleic acid samples view nucacid_sources_ext NUCACID_SOURCES, extended with LocalIds view nucacids All nucleic acid samples view nucacids_w_conc All nucleic acid samples, with their most recent concentrations view parents The parents for every individual who has at least one known parent view pcv_stats Calculates statistics for packed cell volumes in dartings view points POINT_DATA with enhanced dates and times view points_sorted POINT_DATA with enhanced dates and times, sorted by sid, ptime view potential_dads Males who might be an individual''s dad, according to the males interactions or presence at the time of conception view progesterones Sample- and lab-related info for every sample with a progesterone assay view proportional_ranks RANKS, with a calculated "proportional" rank column view quads Location of the SWERB quads as X and Y coordinates view rankdates_grp RANKDATES, with the individual''s MEMBERS.Grp on that date view repstats_grp REPSTATS, with the individual''s MEMBERS.Grp on that date view samples_goff SAMPLES, with a column indicating the MEMBERS.Grp of the focal on this date view sexskins_cycles SEXSKINS, with related CYCLES view sexskins_cycles_sorted SEXSKINS, with related CYCLES, sorted by sname, date view sexskins_repro_notes SEXSKINS and REPRO_NOTES together view statdate_grp BIOGRAPH, with the MEMBERS.Grp on the individual''s Statdate view swerb All SWERB data view swerb_data_xy SWERB_DATA, with location as X and Y coordinates view swerb_departs SWERB_DEPARTS_DATA with related SWERB_DEPARTS_GPS rows, if any view swerb_gw_loc_data_xy SWERB_GW_LOC_DATA with X and Y coordinates view swerb_gw_locs SWERB_GW_LOC_DATA and QUAD_DATA, unified and with X and Y coordinates view swerb_loc_gps_xy SWERB_LOC_GPS with X and Y coordinates view swerb_locs SWERB_LOC_DATA with an added column indicating if the row involved an ascent or descent view swerb_upload Used for uploading SWERB data view testes_arc_stats Calculates statistics for testicle circumference measurements in dartings view testes_diam_stats Calculates statistics for testicle diameter measurements in dartings view testosterones Sample- and lab-related info for every sample with a testosterone assay view thyroid_hormones Sample- and lab-related info for every sample with a thyroid hormone assay view tissue_sources_ext TISSUE_SOURCES, extended with LocalIds view tissues All tissue samples view tissues_hormones All tissue samples, with extra columns specific to hormone samples view ulna_stats Calculates statistics for ulna length measurements in dartings view vaginal_ph_stats Calculates statistics for vaginal pH measurements in dartings view woundspathologies All wounds/pathologies data, except healing updates view wp_details_affectedparts Intended for uploading to WP_DETAILS and WP_AFFECTEDPARTS. Possibly useful for querying those tables, too view wp_heals All wounds/pathologies data, including healing updates view wp_reports_observers Intended for uploading to WP_REPORTS and WP_OBSERVERS. Possibly useful for querying those tables too