NON_BREC_SIGHTING_SOURCES

There is a row for each chimpanzee, for each date sighted, for non-BRec related sightings. This table is used to make “manual”, that is, non-BRec related, changes to the per-day record of chimpanzee sightings found in the SIGHTINGS table.

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 Non-BRec record in which the sighting 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 the individual was sighted. This column may not be NULL.

AnimID (Animal IDentifier)

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

CommID (Community IDentifier)

The COMM_IDS.CommID of the community to which the individual was assigned for the day. This column may not be NULL.

Notes

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

Page last generated: 2026-02-10 22:26:46 UTC