View: biographies

Comment: One row per individual studied. This view is identical to the BIOGRAPHY table, but for the addition of the MomId column -- which contains the mother's AnimId. This view is updatable. The underlying rows may be changed by INSERT, UPDATE, or DELETE on the view. The MomBId value of the underlying BIOGRAPHY row may be manipulated via BIOGRAPHIES using either the MomBId column or the MomId column. On INSERT either MomBId or MomId can be omitted from the list of inserted columns or the NULL value used in either of the columns. The MomId of the underlying BIOGRAPHIES row is assigned based on the supplied non-NULL column. To INSERT a NULL BIOGRAPHY.MomBId value either specify a NULL value for both BIOGRAPHIES MomBId and MomId or omit both columns from the INSERT statement. On INSERT if both MomBId and MomId are specified then the 2 values must refer to the same mother. On UPDATE if both MomBId and MomId change then the 2 values must refer to the same mother; if only one of MomBId or MomId changes value then the changed value is used. For more information see the BIOGRAPHY table documentation.

ColumnTypeComment
bidinteger NULLUnique row identifier, and hence a unique identifier of the individual regardless of study. The value of this column is automatically assigned by the system; the normal practice, which results in a system generated id, is to omit this column when inserting new rows or to supply a NULL value. The value of this column cannot be NULL. The value of this column cannot be changed. TIP: Can be used to JOIN with FERTILITY.BId.
studyidcharacter varying(12) NULLIdentifier of the study for which the individual is observed. This value may not be NULL. TIP: Can be used to JOIN with STUDY.Id.
animidcharacter varying(16) NULLThe identifier used by the study to denote the individual. This value may not be NULL.
animnamecharacter varying(128) NULLThe (long) name of the individual. This value may be NULL when the individual has no long name.
momonlyboolean NULLWhether or not the biography row records an individual who exists in the database only because they are known to be a mother of another individual in the database. A Boolean value. Individuals who are "only mothers" (MomOnly = TRUE) have different requirements from typical study subjects as to what data must or must not be recorded in the database. This value may not be NULL.
birthdatedate NULLBirth date. Animal's birthdate. The birthdate is either the exactly known date of birth or it is with a range of possible birthdates. The BirthDate must be on or follow 1910-01-01. Caution: The automatic data integrity check for early BirthDates does not provide adequate per-study data integrity.
bdmindate NULLEstimated earliest birth date. Must differ from Birthdate whenever earliest possible birth date is >7 days before Birthdate.
bdmaxdate NULLEstimated latest birth date. Must differ from Birthdate whenever latest possible birth date is >7 days after Birthdate.
bddistcharacter(1) NULLProbability distribution of the estimated birth date given BDMin, Birthdate, and BDMax. The vocabulary for this column is defined by the PROBABILITY_TYPE table, which expected to define only normal (N) and uniform (U).
birthgroupcharacter varying(32) NULLThe name or code or ID of the group within which the individual was born. This value may be NULL to indicate that the group at birth is unknown or the concept is not applicable. Caution: This value is not validated. As with all strings, it is case-sensitive.
bgqualcharacter(1) NULLQuality of the estimate of the group of birth. The degree of certainty about which group this animal was born into. Must be one of 'C' or 'U' for certain or uncertain. This value may be NULL to indicate quality estimate is unknown.
firstborncharacter(1) NULLWhether the individual is the first born, meaning the first offspring from the maternal parent. Values are 'Y', 'N' and 'U', for Yes, No, and Unknown, respectively. This value may be NULL when the study does not track first born.
mombidinteger NULLThe row identifier of the individual's mother. This is a BIOGRAPHY.BId value. This condition is checked on transaction commit. This value may be NULL when the mother is unknown. TIP: The study's code for the mother may be found in the MomId column of the BIOGRAPHIES view.
momidcharacter varying(16) NULLThe identifier used by the study to denote the indivdual's mother. This value may be NULL when the mother is unknown.
sexcharacter(1) NULLThe gender of the individual. Allowed values are 'M', 'F', and 'U', for male, female, and unknown, respectively. This value may not be NULL.
entrydatedate NULLDate the animal was first seen. Date on which the animal is first sighted in the study population, either because the animal is recognized and ID'd as of that date or because strong inference indicates group membership from that date. Study population is the studied population at the time of the animal's entry into it. EntryDate must be on or follow 1960-01-01. EntryDate must be on or precede today's date. Caution: The automatic data integrity check for early EntryDates does not provide adequate per-study data integrity.
entrytypecharacter varying(8) NULLType of entry into population. Birth, immigration, start of confirmed ID, Initiation of close observation for any other reason, etc. The vocabulary for this column is defined by the START_EVENT table.
departdatedate NULLDate on which the animal was last seen alive in the population. DepartDate must be on or precede today's date.
departtypecharacter varying(8) NULLType of departure. Death, permanent disappearance, emigration out of the study population, end of close observation for any other reason, or end of currently entered data period. Death may be assigned only in cases where the evidence is very strong: body found, or circumstantial evidence indicates poor health or other risks contributing to mortality and/or violations of population-specific behavior patterns. Otherwise assign permanent disappearance. Do not assign mortality based solely on inferred risks associated with age. The vocabulary for this column is defined by the END_EVENT table.
departdateerrordouble precision NULLTime between departdate and the first time that the animal was confirmed missing. Expressed as fraction of a year (number of days divided by 365.25). Assign a zero to DepartdateError only if the number of day between departdate and the first time that the animal was confirmed missing was < 15.
Language: