Chapter 6. The Babase Views

Table of Contents

Group Membership and Life Events
CENSUS_DEMOG (CENSUS extended with DEMOG information)
CENSUS_DEMOG_SORTED (CENSUS_DEMOG, Sorted)
CYCPOINTS_CYCLES (CYCPOINTS extended with CYCLES information)
CYCPOINTS_CYCLES_SORTED (CYCPOINTS_CYCLES, Sorted)
DEMOG_CENSUS (DEMOG, showing CENSUS information)
DEMOG_CENSUS_SORTED (DEMOG_CENSUS, Sorted)
GROUPS_HISTORY
PARENTS
POTENTIAL_DADS (Potential Dads)
PROPORTIONAL_RANKS (RANKS extended with calculated PROPORTIONAL ranks)
Physical Traits
ESTROGENS
GLUCOCORTICOIDS
HORMONE_PREPS
HORMONE_RESULTS
HORMONE_SAMPLES
PROGESTERONES
TESTOSTERONES
THYROID_HORMONES
WOUNDSPATHOLOGIES (All Wound/Pathology Data, Together)
WP_DETAILS_AFFECTEDPARTS (WP_DETAILS, extended with WP_AFFECTEDPARTS)
WP_HEALS (WP_HEALUPDATES, extended)
WP_REPORTS_OBSERVERS (WP_REPORTS, extended with WP_OBSERVERS)
Sexual Cycles
CYCLES_SEXSKINS (CYCLES extended with SEXSKINS information)
CYCLES_SEXSKINS_SORTED (CYCLES_SEXSKINS, Sorted)
MATERNITIES (completed reproductive events)
MTD_CYCLES (CYCLES and Mdate, Tdate, and Ddate CYCPOINTS data)
SEXSKINS_CYCLES (CYCLES extended with SEXSKINS information)
SEXSKINS_CYCLES_SORTED (SEXSKINS_CYCLES, Sorted)
SEXSKINS_REPRO_NOTES (SEXSKINS extended with REPRO_NOTES)
Social and Multiparty Interactions
ACTOR_ACTEES (Complete social interactions, INTERACT_DATA extended twice with PARTS)
INTERACT (INTERACT_DATA, with enhanced dates and times)
INTERACT_SORTED
MPI_EVENTS (Dyadic social interactions that comprise multiparty interaction collections, MPIS joined with MPI_DATA extended twice with MPI_PARTS)
POINTS (POINT_DATA, with enhanced times)
POINTS_SORTED (POINTS, Sorted)
SAMPLES_GOFF (SAMPLES, with the Group OF the Focal)
Darting
ANESTH_STATS (darting additional Anesthetic Statistics)
BODYTEMP_STATS (darting Body Temperature Statistics)
CHEST_STATS (darting Chest circumference Statistics)
CROWNRUMP_STATS (darting Crown-to-Rump Statistics)
DSAMPLES (darting sample records with columns for each sample type)
DENT_CODES (darting Dentition records with columns for each Toothcode)
DENT_SITES (darting Dentition records with columns for each Toothsite)
HUMERUS_STATS (darting Humerus length Statistics)
PCV_STATS (darting PCV Statistics)
TESTES_ARC_STATS (darting Testes circumference Statistics)
TESTES_DIAM_STATS (darting Testes Diameter Statistics)
ULNA_STATS (darting Ulna length Statistics)
Inventory
LOCATIONS_FREE (LOCATIONS available for storage)
NUCACID_CONCS (NUCACID_CONC_DATA, extended)
NUCACIDS (NUCACID_DATA, extended)
NUCACIDS_W_CONC (NUCleic ACIDS With CONCentration data)
TISSUES
TISSUES_HORMONES
SWERB Data (Group-level Geolocation Data)
QUADS (map Quadrants)
SWERB (Group level gps point samples)
SWERB_DATA_XY (The SWERB_DATA table with separate X and Y coordinates)
SWERB_DEPARTS (SWERB observation team Departures from camp)
SWERB_GW_LOCS (SWERB Grove and Waterhole Locations)
SWERB_GW_LOC_DATA_XY (The SWERB_GW_LOC_DATA table with separate X and Y coordinates)
SWERB_LOC_GPS_XY (The SWERB_LOC_GPS table with separate X and Y coordinates)
SWERB_LOCS (placement of a group at a landscape feature)
SWERB_UPLOAD (facility for uploading data into SWERB)
Weather Data
MIN_MAXS (Manually collected minimum and maximum temperature and rain data)
MIN_MAXS_SORTED (MIN_MAXS, Sorted)
Views Which Add Gid To Tables
The BIRTH_GRP View
The ENTRYDATE_GRP View
The STATDATE_GRP View
The CONSORTDATES_GRP View
The CYCGAPDAYS_GRP View
The CYCGAPS_GRP View
The CYCSTATS_GRP View
The DARTINGS_GRP View
The DISPERSEDATES_GRP View
The MATUREDATES_GRP View
The MDINTERVALS_GRP View
The MMINTERVALS_GRP View
The RANKDATES_GRP View
The REPSTATS_GRP View

The documentation of each view contains a short description of the purpose of the view, the query used to generate the view, a diagram of the Babase tables contained in the view, a table showing the columns contained in the view, and notes on the operations (INSERT, UPDATE, or DELETE) allowed on the view. For further information on the columns' content see the documentation of each column in the table that is the source of the view's data.

Note

Babase contains schemas that use views to organize the Babase content. The views in these schemas refer to tables or views within the babase schema and are not otherwise documented.

Warning

Attempts to update computed columns, columns that appear in the view but not in the underlying data tables, may be silently ignored. This is also sometimes true of actual data columns that are expected to automatically have their values assigned by Babase. Changes that are silently ignored produce no error message. The ignored changes are not made at the same time that changes to other columns are made.

The views are being changed as time permits so that there are no cases where errors are silently ignored.

The documentation of each view describes which columns can not be changed through the view.

The entity-relationship diagrams which document each view use the same key as this documents other entity-relationships diagrams. The key is show in Figure 2.1: “Key to the Babase Entity Relationship Diagrams”.

Note

If you have trouble viewing the diagrams in your browser, you may wish to view them in PDF format. The diagrams are available in The Babase Pocket Reference (approx. 4.8MB) in PDF form.

There are two differences between the entity-relationship diagrams which document the views and those which show the relationship between the Babase tables. First, the ER diagrams of the tables are a complete reference, they show all of each table's columns. The ER diagrams of the views show only those columns used in the view. Second, the view ER diagrams follow the column names of each Babase table with parenthesis that contain the name each column takes in the view.[253]



[253] Those columns that are joined in the view appear twice in the view ER diagrams, once in each of the two underlying tables. These columns appear only once in the view, so both the name of both columns in the view ER diagrams are followed by parenthesis containing the same text -- the name the column has in the view.


Page generated: 2022-09-15T15:33:40-04:00.