  */
 
 CREATE SEQUENCE eventLogIdSeq START 1;
-
 
 CREATE TABLE EventLog (
   id             integer PRIMARY KEY  DEFAULT nextval('eventLogIdSeq')

, PRIMARY KEY(rulePkeyId, directiveId)
);

CREATE INDEX rule_id_start on Rules (ruleId, startTime);
CREATE INDEX rule_end on Rules (endTime);

CREATE sequence NodesId START 101;

CREATE TABLE Nodes (
  id              integer PRIMARY KEY default nextval('NodesId')

 * or not. 
 */
CREATE TABLE ReportsExecution (
  nodeId             text NOT NULL
, date               timestamp with time zone NOT NULL
, complete           boolean NOT NULL
, PRIMARY KEY(nodeId, date)
);

