GROOMINGS

Each row, taken together with the related EVENTS row, represents a grooming event recording during a follow. Groomings are recorded as dyadic pairs.

Should there be multiple individuals, whether groomer or recipient, involved in simultaneous grooming behavior, there should be multiple rows in the GROOMINGS table. There should be one row for each dyad.

Caution

The system’s design cannot distinguish between multiple multi-party grooming events that are recorded as part of a single follow and occur at a given time, and a single, larger, multi-party grooming event recorded in the given follow at the given time.[1]

The related EVENTS row must be a grooming event; it must have an EVENTS.Behavior value of GROOM. This related EVENTS row supplies the time of the grooming and relates to the follow, and the ROLES role related to the event supplies information on the individuals involved.

The initiator and the terminator of the grooming event, when either of these are known, must each be one of the individuals who participated in the grooming event. Further, the initiator and the terminator of the grooming event, when known, must each be either the groomer or the individual being groomed. This means the Initiator and Terminator values must be a ROLES.PID value of a ROLES row that has a ROLES.EID equal to the EID of the grooming event and the ROLES.Role value must be either Actor or Actee. This condition is checked on transaction commit.

For further information, including additional data integrity rules, see the documentation of the EVENTS table.

EID (Event ID)

The EVENTS.EID identifying the grooming event. A unique, automatically generated, positive integer which serves to identify the row. The value of this column cannot be changed. The related event contains information on the time of the grooming and is related to the participants in the grooming event.

This column may not be NULL.

Initiator

The participant that initiated the grooming. A ROLES.Role value. This column may be NULL when there is no record of who initiated the grooming.

Terminator

The participant that initiated the grooming. A ROLES.Role value. This column may be NULL when there is no record of who terminated the grooming.

Problems

Text describing problems in the grooming observation. 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.

Extractedby

The person who extracted the grooming information from the written records and prepared it for data entry into the database. This column may not be NULL.

[1]

More information related to this problem can be found in the documentation of the AGGRESSIONS table.

Page last generated: 2026-06-12 16:40:37 UTC