FERTILITY

Each row represents a period of time during which a female is fertile.

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

For any given female, for any given study, the periods of fertility cannot overlap. This means that, per female, per study, the Stopdate of any given row cannot be between, inclusive, the StartDate and the Stopdate of any other row.

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.

Study

A code designating the the study that produced the fertility data. A STUDIES.Study value. This column may not be NULL.

AnimID

The BIOGRAPHY_DATA.AnimID of the female. This column may not be NULL.

StartDate

The date, inclusive, of the start of the period of fertility. This column may not be NULL.

StartType

A code indicating the female’s fertility state at the start of the time period. A FERTILITY_STARTS.Code value. This column may not be NULL.

StopDate

The date, inclusive, of the end of the period of fertility. This column may not be NULL.

StopType

A code indicating the female’s fertility state at the end of the time period. A FERTILITY_STOPS.Code value. This column may not be NULL.

Page last generated: 2026-07-20 23:28:52 UTC