AGGRESSION_EVENT_LOG

Each row contains information on the source of the data in the AGGRESSIONS table. There is, at most, one row per-community, per-year.

The combination of Community and Year must be unique.

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.

Year

The year of the information recorded in the row. This value may not be before 1975.

This column may not be NULL.

Community

The community of the information recorded in the row. The COMM_IDS.CommID of the community of the information recorded in the row.

Each value stored in this column must be unique. This column may not be NULL.

BRecEnglish

Information on what came from the B-Record notes in English. This column may be empty text. It need not contain characters, but it may not contain only whitespace characters. This column may not be NULL.

ARecSwahili

Information on what came from the A-Record notes in Swahili. This column may be empty text. It need not contain characters, but it may not contain only whitespace characters. This column may not be NULL.

ARecEnglishNotes

Information on what came from the A-Record notes in English. This column may be empty text. It need not contain characters, but it may not contain only whitespace characters. This column may not be NULL.

ARecBookExtract

Information on what came from the A-Record book. This column may be empty text. It need not contain characters, but it may not contain only whitespace characters. This column may not be NULL.

BRecSwahili

Information on what came from the B-Record notes in Swahili. This column may be empty text. It need not contain characters, but it may not contain only whitespace characters. This column may not be NULL.

BRecBookExtract

Information on what came from the B-Record book. This column may be empty text. It need not contain characters, but it may not contain only whitespace characters. This column may not be NULL.

MaInfBookExtract

Information on what came from the mother-infant book. This column may be empty text. It need not contain characters, but it may not contain only whitespace characters. This column may not be NULL.

MaInf

Information on what came from the mother-infant project. This column may be empty text. It need not contain characters, but it may not contain only whitespace characters. This column may not be NULL.

Schroepfer

Information on what came from Kara Schroepfer’s PHD data. This column may be empty text. It need not contain characters, but it may not contain only whitespace characters. This column may not be NULL.

Notes

Other notes. This column may be empty text. It need not contain characters, but it may not contain only whitespace characters. This column may not be NULL.

Page last generated: 2026-05-14 16:59:14 UTC