%entities; %constants; ]>

SELECT * FROM (SELECT datasheet_events.followid AS followid , datasheet_events.intid AS intid , datasheet_events.date AS date , datasheet_events.time AS time , datasheet_events.mom AS mom , datasheet_events.infant AS infant , datasheet_events.infant2 AS infant2 , datasheet_events.sib AS sib , datasheet_events.sib2 AS sib2 , datasheet_events.eid AS eid , datasheet_events.behavior AS e_behavior , datasheet_events.position AS e_position , datasheet_events.uncertain AS e_uncertain , datasheet_events.e_mom AS e_mom , datasheet_events.e_mompart AS e_mompart , datasheet_events.e_mom_foodpart AS e_mom_foodpart , datasheet_events.e_mom_foodkind AS e_mom_foodkind , datasheet_events.e_mom_fishpart AS e_mom_fishpart , datasheet_events.e_mom_fishkind AS e_mom_fishkind , datasheet_events.e_mom_fishresult AS e_mom_fishresult , datasheet_events.e_mom_voc AS e_mom_voc , datasheet_events.e_mom_play AS e_mom_play , datasheet_events.e_mom_rest AS e_mom_rest , datasheet_events.e_infant AS e_infant , datasheet_events.e_infantpart AS e_infantpart , datasheet_events.e_infant_foodpart AS e_infant_foodpart , datasheet_events.e_infant_foodkind AS e_infant_foodkind , datasheet_events.e_infant_fishpart AS e_infant_fishpart , datasheet_events.e_infant_fishkind AS e_infant_fishkind , datasheet_events.e_infant_fishresult AS e_infant_fishresult , datasheet_events.e_infant_voc AS e_infant_voc , datasheet_events.e_infant_play AS e_infant_play , datasheet_events.e_infant_ride AS e_infant_ride , datasheet_events.e_infant_rest AS e_infant_rest , datasheet_events.e_sib as e_sib , datasheet_events.e_sibpart AS e_sibpart , datasheet_events.e_sib_foodpart AS e_sib_foodpart , datasheet_events.e_sib_foodkind AS e_sib_foodkind , datasheet_events.e_sib_fishpart AS e_sib_fishpart , datasheet_events.e_sib_fishkind AS e_sib_fishkind , datasheet_events.e_sib_fishresult AS e_sib_fishresult , datasheet_events.e_sib_voc AS e_sib_voc , datasheet_events.e_sib_play AS e_sib_play , datasheet_events.e_sib_ride AS e_sib_ride , datasheet_events.e_sib_rest AS e_sib_rest , datasheet_events.e_nonfocal AS e_nonfocal , datasheet_events.e_nonfocalpart as e_nonfocalpart , datasheet_events.e_baboon AS e_baboon , datasheet_events.e_baboonpart AS e_baboonpart

, NULL AS d_distid , NULL AS d_uncertain , NULL AS d_mom , NULL AS d_infant , NULL AS d_sib , NULL AS d_distance , datasheet_events.i_comment AS i_comment , datasheet_events.e_comment AS e_comment FROM datasheet_events

UNION SELECT family_dists.followid AS followid , family_dists.intid AS intid , family_dists.date AS date , family_dists.time AS time , family_dists.mom AS mom , family_dists.infant AS infant , family_dists.infant2 AS infant2 , family_dists.sib AS sib , family_dists.sib2 AS sib2 , NULL AS eid , NULL AS e_behavior , NULL AS e_position , NULL AS e_uncertain , NULL AS e_mom , NULL AS e_mompart , NULL AS e_mom_foodpart , NULL AS e_mom_foodkind , NULL AS e_mom_fishpart , NULL AS e_mom_fishkind , NULL AS e_mom_fishresult , NULL AS e_mom_voc , NULL AS e_mom_play , NULL AS e_mom_rest , NULL AS e_infant , NULL AS e_infantpart , NULL AS e_infant_foodpart , NULL AS e_infant_foodkind , NULL AS e_infant_fishpart , NULL AS e_infant_fishkind , NULL AS e_infant_fishresult , NULL AS e_infant_voc , NULL AS e_infant_play , NULL AS e_infant_ride , NULL AS e_infant_rest , NULL AS e_sib , NULL AS e_sibpart , NULL AS e_sib_foodpart , NULL AS e_sib_foodkind , NULL AS e_sib_fishpart , NULL AS e_sib_fishkind , NULL AS e_sib_fishresult , NULL AS e_sib_voc , NULL AS e_sib_play , NULL AS e_sib_ride , NULL AS e_sib_rest , NULL AS e_nonfocal , NULL AS e_nonfocalpart , NULL AS e_baboon , NULL AS e_baboonpart

, family_dists.distid AS d_distid , family_dists.uncertain AS d_uncertain , family_dists.d_mom AS d_mom , family_dists.d_infant AS d_infant , family_dists.d_sib AS d_sib , family_dists.distance AS d_distance , family_dists.i_comment AS i_comment , NULL AS e_comment FROM family_dists ) AS q ORDER BY q.date , q.time , q.e_behavior , q.e_mom IS NULL , q.e_infant IS NULL , q.e_nonfocal , q.d_mom IS NULL , q.d_infant IS NULL;

The DATASHEETS view ER diagram intentionally omitted due to query size.