PANTGRUNTS_VIEW

Each row represents a dyadic pantgrunt interaction between two individuals. Rows resemble the MS Access database structure, which may make the data easier to work with.

The view puts the individual performing the pantgrunt and the individual receiving the pantgrunt in separate columns. There is a flag to indicate whether the pantgrunting is mutual; when TRUE ,there is not meaning to the placement of the interacting individuals into these two columns.

Definition

CREATE OR REPLACE VIEW pantgrunts_view (
  date
 ,focal
 ,time
 ,actor
 ,recipient
 ,multiactors
 ,multirecipients
 ,twosided
 ,commid
 ,pg_commid
 ,source
 ,enteredby
 ,notes
  -- Administrative information
 ,type
 ,wid
 ,eid
 ,actor_pid
 ,recipient_pid
  )
  AS
    SELECT
      dyads.date AS date
     ,dyads.focal AS focal
     ,dyads.start AS time
     ,dyads.actor AS actor
     ,dyads.recipient AS recipient
     ,pantgrunts.multiactors AS multiactors
     ,pantgrunts.multirecipients AS multirecipients
     ,dyads.twosided AS twosided
     ,dyads.commid AS commid
     ,pantgrunts.commid AS pg_commid
     ,pantgrunts.source AS source
     ,pantgrunts.enteredby AS enteredby
     ,dyads.notes AS notes
     ,dyads.type AS type
     ,dyads.wid AS wid
     ,dyads.eid AS eid
     ,dyads.actor_pid AS actor_pid
     ,dyads.recipient_pid AS recipient_pid
     FROM dyads
       JOIN pantgrunts
            ON (pantgrunts.eid = dyads.eid);

ER Diagram

PANTGRUNTS_VIEW

Columns of the PANTGRUNTS_VIEW View

The columns of the PANTGRUNTS_VIEW view

Column	From	Description
Date	WATCHES.Date	Date of pantgrunt
Focal	WATCHES.Focal	Focal of follow, or focal of a non-existant follow, or an un-interesting AnimID
Time	EVENTS.Start	Time of pantgrunt
Actor	ROLES.Participant	The BIOGRAPHY_DATA.AnimID of the individual pantgrunting, or mutually pantgrunting
Recipient	ROLES.Participant	The BIOGRAPHY_DATA.AnimID of the individual receiving the pantgrunt, or mutually pantgrunting
MultiActors	PANTGRUNTS.MultiActors	Boolean, TRUE when there were multiple pantgrunters
MultiRecipients	PANTGRUNTS.MultiRecipients	Boolean, TRUE when there were mulitple recipients of a pantgrunt
TwoSided	An expression based on ROLES.Role	Boolean, TRUE when both the Actor and the Recipient were pantgrunting to each other
CommID	WATCHES.CommID	The community identifier associated either with the follow or with the ad-hoc recording of the pantgrunt
PG_CommID	PANTGRUNTS.CommID	The community identifier associated with the record of the pantgrunt
Source	PANTGRUNTS.Source	Code for the source of the pantgrunt information
Notes	EVENTS.Notes	Textual notes on the pantgrunt event
EnteredBy	PANTGRUNTS.EnteredBy	Code for the person who extracted the pantgrunt information from the written records
Type	WATCHES.Type	Type, reporting whether or not the pantgrunt was observed during a follow
WID	WATCHES.WID	Identifier of the related WATCHES row
EID	EVENTS.EID	Identifier of the related EVENTS and PANTGRUNTS rows
Actor_PID	ROLES.PID	Identifier of the ROLES row containing the individual performing the pantgrunt, or mutually pantgrunting
Recipient_PID	ROLES.PID	Identifier of the ROLES row containig the individual receiving the pantgrunt, or mutually pantgrunting

Operations Allowed

INSERT

The Focal, Date, and Time columns must be supplied.

The WID, Type, EID, Actor_PID, and Recipient_PID columns will not have their values inserted into new rows. If values are supplied for these columns they must match the values already existing in, or inserted into, the database.

The WATCHES and EVENTS table’s rows may already exist. The data values supplied for these tables must match the values that already exist.

UPDATE

This operation is not allowed.

DELETE

This operation is not allowed.

Page last generated: 2026-07-01 00:11:55 UTC