Data Retrieval Views

The views appearing in this section exist for convenience in querying. Some exist to make the data look more like the “old” data, as it appeared in the old MS Access database. Others reproduce common query patterns, eliminiating the need to connect (join) multiple tables.

View	One row for each	Purpose	Tables/Views used
BIOGRAPHY	BIOGRAPHY_DATA row	Reproduce “old” data	BIOGRAPHY_DATA

• BIOGRAPHY
  • Definition
  • Columns of the BIOGRAPHY View
  • Operations Allowed

Data Modification Views

The views appearing in this section exist so that data can be more easily uploaded into the database and more easily modifed. These views may also be suitable for querying.

Some exist to make the data look more like the “old” data, as it appeared in the old MS Access database. Others reproduce common query patterns, eliminiating the need to connect (join) multiple tables.

View	One row for each	Purpose	Tables/Views used
DYADS	EVENTS row, where the behavior observed is a dyadic interaction	Simplifies querying – puts the two individals involved in a dyadic interactions into a single row.	WATCHES, EVENTS, ROLES (twice)
OBS (Observations)	EVENTS row, so one row for every observed event	Simplifies querying – attaches a date and a AnimID, etc., to each event.	WATCHES, EVENTS
PANTGRUNTS_VIEW	EVENTS row related to a PANTGRUNTS row	Upload pantgrunt data, reproduce “old” data	WATCHES, EVENTS, ROLES, PANTGRUNTS

• DYADS
  • Definition
  • ER Diagram
  • Columns of the DYADS View
  • Operations Allowed
• OBS (OBservationS)
  • Definition
  • ER Diagram
  • Columns of the OBS View
  • Operations Allowed
• PANTGRUNTS_VIEW
  • Definition
  • ER Diagram
  • Columns of the PANTGRUNTS_VIEW View
  • Operations Allowed

Page last generated: 2026-07-05 18:38:43 UTC