ESTRUS_SOURCES

There is a row for each female chimpanzee, for each date estrus information was recorded, for each kind of record – that is not a TRec – where the estrus information was recorded. Rows exist both for non-BRec related sightings, and for BRec related sighting when those sightings were recorded in the old, MS Access based, database. Going forward, this table is used to make non-BRec related, changes to the per-day record of female chimpanzee estrus information found in the ESTRUS_STATES table.

This table provides a way to incorporate estrus state information from records kept outside of SokweDB into the per-individual, per-day estrus state information found in the ESTRUS_STATES table. See the ESTRUS_STATE documentation or further information on how estrus state information is summarized in the ESTRUS_STATES table.

There must either be a non-NULL EstrusMin value or a non-NULL EstrusMax value; in a single row, both the EstrusMin and the EstrusMax may not be NULL.

The AnimID value must be that of a female. This means that the BIOGRAPHY_DATA.Sex value must be F.

The Date must be during a period when the sighted individual was under study, on or after the individual’s BIOGRAPHY_DATA.EntryDate and on or before the individual’s BIOGRAPHY_DATA.DepartDate. Further, the Date must be on a day when the individual is between 5 years old and 48 years old, inclusive of endpoints.[1]

ID (IDentifier)

A unique, automatically generated, positive integer which serves to identify the row. The value of this column cannot be changed. This column may not be NULL.

Source

Code indicating the record in which the estrus state was recorded. A SIGHTING_RECORDS.Code value. The special value sdb_sowkedb_source may not appear as a value in this column.

This column may not be NULL.

Date

The date of the individual’s estrus state measurement. This column may not be NULL.

AnimID (Animal IDentifier)

The BIOGRAPHY_DATA.AnimID of the individual who’s estrus state was recorded. This column may not be NULL.

EstrusMin (Estrus Minimum swelling)

The minimum estrus swelling observed on the day. A CYCLE_STATES.Code value.

This value may only be NULL when the Source value is MANUAL.

EstrusMax (Estrus Maximum swelling)

The maximum estrus swelling observed by the given source on the given day. A CYCLE_STATES.Code value.

This value may only be NULL when the Source value is MANUAL.

Notes

Textual notes related to the estrus state. This column may not be NULL.

rubric:: Footnotes

[1]

The lower age limit is the minimum age of adolescence, the upper the maximum age limit for recording female sexual swelling values.

Page last generated: 2026-03-02 22:02:22 UTC