ESTRUS_STATES

ESTRUS_STATES contains one row for each female chimpanzee for every day the individual’s estrus state was observed. It records daily minimum and maximum sexual swelling information. This table provides an automatically maintained summary of the estrus state information found throughout SokweDB.

The ESTRUS_STATES table is automatically constructed by the system and cannot be manually maintained. The table’s rows are computed from the SokweDB tables’ content.

The ESTRUS_SOURCES table is used to both force specific estrus state values and to add additional records of estrus state, records from “external” data sources, into ESTRUS_STATES’ minimum and maxium estrus calculations. There is no way to remove rows from ESTRUS_STATES when SokweDB tables, other than the ESTRUS_SOURCES table, contain estrus state information on an individual on a particular day. But if the only reason a row appears in ESTRUS_STATES is due to rows in ESTRUS_SOURCES, the row can be removed from ESTRUS_STATES by removing the ESTRUS_SOURCES rows.

Rows may exist in ESTRUS_SOURCES to record additional estrus state information on an individual on a given day regardless of whether other tables in SokweDB also contain estrus information. Should the SokweDB db’s content change in a way that removes the individual’s daily estrus information, the relevant rows in ESTRUS_SOURCES become the sole source of the individual’s daily estrus information.

The ESTRUS_STATES.EstrusMin value is the minimum of all the minimum estrus swelling states recorded in SokweDB for the individual for a given day. Notably, this includes minimum estrus values present in ESTRUS_SOURCES, which provides a way to include arbitrary estrus state information.

The ESTRUS_STATES.EstrusMax value is the maximum of all the maximum estrus swelling states recorded in SokweDB for the individual for a given day, computed in a fashion analogous to the EstrusMin computation.

Minimums and maximums are computed by comparing CYCLE_STATES.AsNum values. CYCLE_STATES.Code values associated with NULL AsNum values are not used in minimum or maximum calculations. This means that only those CYCLE_STATES.Code values associated with non-NULL AsNum values appear as EstrusMin or EstrusMax values.

There is a mechanism for ignoring the above minimum and maximum calculations and manually specifying a daily estrus state value. To do this, create a row in ESTRUS_SOURCES with the special Source value of MANUAL. The EstrusMin and ESTRUS_SOURCES.EstrusMax| values in the row you create then become the values used in the ESTRUS_STATES.EstrusMin and EstrusMax columns for the given individual for the given day.

To allow the manual adjustment of EstrusMin values without also being forced to supply manual value for EstrusMax, NULL ESTRUS_SOURCES.EstrusMin and ESTRUS_SOURCES.EstrusMax values are ignored.

ID (Estrus_States 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.

Date

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

AnimID (Animal IDentifier)

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

EstrusMin (Estrus Minimum swelling)

The minimum estrus swelling observed on the day. A CYCLE_STATES.Code value. See above for more information on how the value of this column is determined.

This column may not be NULL.

EstrusMinSource

A code indicating the record-taking that is the source of the minimum estrus swelling information. A SIGHTING_RECORDS.Code value. See above for more information on how the value of this column is determined.

This column may not be NULL.

EstrusMax (Estrus Maximum swelling)

The maximum estrus swelling observed on the day. A CYCLE_STATES.Code value. See above for more information on how the value of this column is determined.

This column may not be NULL.

EstrusMaxSource

A code indicating the record-taking that is the source of the maximum estrus swelling information. A SIGHTING_RECORDS.Code value. See above for more information on how the value of this column is determined.

This column may not be NULL.

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