Query Defining the ACTOR

%entities; %constants; ]>

Query Defining the ACTOR_ACTEES View

SELECT events.eid AS eid
     , events.intid AS intid
     , actors.pid AS actorpid
     , actees.pid AS acteepid
     , events.behavior AS behavior
     , events.position AS position
     , events.uncertain AS uncertain
     , followrole(intervals.followid, actors.participant) AS actorrole
     , actors.participant AS actor
     , followrole(intervals.followid, actees.participant) AS acteerole
     , actees.participant AS actee
     , events.comment AS comment
  FROM events
         JOIN intervals
           ON (intervals.intid = events.intid)
         JOIN parts AS actors
           ON (actors.eid = events.eid)
         JOIN parts AS actees
           ON (actees.eid = events.eid)
  WHERE actors.part = 'gmi_actor'
        AND actees.part = 'gmi_actee'

;

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