SWELLING_SOURCES

There is a row for each female chimpanzee, for each date sexual swelling information was recorded, for each kind of record where the sexual swelling information was recorded, when the sexual swelling information is not recorded elsewhere in SokweDB. Going forward, this table is used to make non-BRec related, changes to the per-day record of female chimpanzee sexual swelling information found in the SWELLING_STATES table.

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

There must either be a non-NULL SwellingMin value or a non-NULL SwellingMax value; in a single row, both the SwellingMin and the SwellingMax 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 sexual swelling measurement 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 sexual swelling measurement. This column may not be NULL.

AnimID (Animal IDentifier)

The BIOGRAPHY_DATA.AnimID of the individual who’s sexual swelling measurement was recorded. This column may not be NULL.

SwellingMin (MINimum sexual SWELLING)

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

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

SwellingMax (MAXimum sexual SWELLING)

The maximum sexual 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 sexual swelling measurement. 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-06-12 16:40:37 UTC