CREATE TABLE tblunit (
    unit_id INTEGER NOT NULL,
    unit_location CHARACTER VARYING(100)
);
INSERT INTO tblunit VALUES(1,'location1');
INSERT INTO tblunit VALUES(2,'location2');
INSERT INTO tblunit VALUES(3,'location3');

CREATE TABLE tbloperator (
    operator_id INTEGER NOT NULL,
    operator_name CHARACTER VARYING(100)
);
INSERT INTO tbloperator VALUES(1,'operator1');
INSERT INTO tbloperator VALUES(2,'operator2');
INSERT INTO tbloperator VALUES(3,'operator3');
INSERT INTO tbloperator VALUES(4,'operator4');
INSERT INTO tbloperator VALUES(5,'operator5');
INSERT INTO tbloperator VALUES(6,'operator6');


CREATE TABLE tbloperatorschedule (
    operator_schedule_id BIGINT NOT NULL,
    operator_id INTEGER,
    schedule_start_time TIMESTAMP WITHOUT TIME zone,
    schedule_end_time TIMESTAMP WITHOUT TIME zone,
    unit_id BIGINT
);
INSERT INTO tbloperatorschedule VALUES(1,1,'2011-12-01 01:00:00','2011-12-01 02:00:00',1);
INSERT INTO tbloperatorschedule VALUES(2,5,'2011-12-01 02:30:00','2011-12-01 04:50:00',1);
INSERT INTO tbloperatorschedule VALUES(3,2,'2011-12-01 04:55:00','2011-12-01 10:20:00',1);
INSERT INTO tbloperatorschedule VALUES(4,1,'2011-12-01 03:00:00','2011-12-01 05:00:00',2);
INSERT INTO tbloperatorschedule VALUES(5,3,'2011-12-01 05:30:00','2011-12-01 09:50:00',2);
INSERT INTO tbloperatorschedule VALUES(6,4,'2011-12-01 09:55:00','2011-12-01 13:20:00',2);
INSERT INTO tbloperatorschedule VALUES(7,6,'2011-12-01 14:00:00','2011-12-01 18:00:00',2);
INSERT INTO tbloperatorschedule VALUES(8,5,'2011-12-01 06:30:00','2011-12-01 14:50:00',3);
INSERT INTO tbloperatorschedule VALUES(9,2,'2011-12-01 14:55:00','2011-12-01 20:20:00',3);

CREATE TABLE tbldata (
    data_id BIGINT NOT NULL,
    event_time TIMESTAMP WITHOUT TIME zone DEFAULT now(),
    data_text CHARACTER VARYING(100),
    unit_id BIGINT
);
INSERT INTO tbldata VALUES(1,'2011-12-01 02:30:00','abc',1);
INSERT INTO tbldata VALUES(2,'2011-12-01 06:28:00','abc',2);
INSERT INTO tbldata VALUES(3,'2011-12-01 11:10:00','abc',3);
INSERT INTO tbldata VALUES(4,'2011-12-01 21:30:00','abc',3);