Query Defining the NOOBS View

%entities; %constants; ]>


SELECT followparts.followid AS followid
     , followparts.chimpid AS chimpid
     , followparts.role AS role
     , chimpids.animid AS animid
     , times.time AS time 
  FROM followparts
         JOIN chimpids ON (chimpids.chimpid = followparts.chimpid)
         CROSS JOIN
           (SELECT GENERATE_SERIES('2000-01-01 gmi_day_start'::TIMESTAMP
                                 , '2000-01-01 gmi_day_end'::TIMESTAMP
                                 , '1 minute')::TIME
                   AS time
           ) AS times
  WHERE NOT EXISTS
          (SELECT 1
             FROM intervals
                  JOIN events ON (events.intid = intervals.intid)
                  JOIN parts ON (parts.eid = events.eid)
                  JOIN chimpids AS part_cids
                       ON (part_cids.chimpid = parts.participant)
            WHERE intervals.followid = followparts.followid
                  AND intervals.time = times.time
                  AND part_cids.animid = chimpids.animid
            LIMIT 1)

;

Entity Relationship Diagram of the NOOBS View If we could we would display here the diagram showing how the NOOBS view is constructed.