COMM_MEMBS¶
Each row represents an un-interrupted series of days during which
the given chimpanzee is a member of the given community.
The unit of time is the day; it is not possible to place any given
chimpanzee in more than one community within a single day. Leaving a community, whether to join another or
not, ends this period of community membership.
Another row in COMM_MEMBS is required to record a newer period of
community membership, whether in the same or a different community.
An individual may not be recorded in more than one community on any
given day, although there may be days during which the individual is
not placed in any community.
Further, an individual may not be placed in the same community, by
use of two COMM_MEMBS rows, on the same day.
There can be no “overlap” of COMM_MEMBS rows.
The StartDate to EndDate intervals, of all
the COMM_MEMBS rows with a given AnimID, may not
overlap.
Two COMM_MEMBS rows may not be used to place a single individual
in the same community on successive days.
Instead, combine the two COMM_MEMBS rows into one.
The StartDate of an individual with a given
CommID may not be the day after the EndDate
of a COMM_MEMBS row having the same AnimID value.
An individual may not be a member of any community before their birth date. This means, the StartDate may not be before the individual’s BIOGRAPHY_DATA.BirthDate.
An individual may be a member of their birth community before they became under study, but may not be a member of any other community until they have come under study. This means, when the CommID is not the BIOGRAPHY_DATA.BirthComm, then the StartDate may not be before the individual’s BIOGRAPHY_DATA.EntryDate.
An individual may not be a member of a community after they cease to be under study. This means, the EndDate may not be after the individual’s BIOGRAPHY_DATA.DepartDate.
The StartDate must not be after the EndDate.
CommMID (Community Memberships 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.
AnimID (Animal IDentifier)¶
The BIOGRAPHY_DATA.AnimID which identifies the
chimpanzee who’s community membership is recorded. This column may not be NULL.
StartDate¶
The date on which the individual joined the community; the
start date, inclusive, of the interval of continuous membership. This column may not be NULL.
EndDate¶
The last date on which the individual was a community member; the
end date, inclusive, of the interval of continuous membership This column may not be NULL.
CommID (Community IDentifier)¶
The COMM_IDS.CommID identifying the community in which
the row records membership. This column may not be NULL.
StartSource¶
The COMM_MEMBS_SOURCES.CommMembsSource
value which identifies the data source used to determine the
StartDate. This column may not be NULL.
EndSource¶
The COMM_MEMBS_SOURCES.CommMembsSource
value which identifies the data source used to determine the
EndDate. This column may not be NULL.
Page last generated: 2025-11-01 22:22:26 UTC