CREATE TABLE cleaning_area(
janitor_id VARCHAR(4) NOT NULL
,facility_id VARCHAR(6) NOT NULL
,effective_date DATE NOT NULL
,PRIMARY KEY(janitor_id,effective_date)
);
INSERT INTO cleaning_area(janitor_id,facility_id,effective_date) VALUES ('3017','FAC001','2020-07-30');
INSERT INTO cleaning_area(janitor_id,facility_id,effective_date) VALUES ('3017','FAC002','2020-08-01');
INSERT INTO cleaning_area(janitor_id,facility_id,effective_date) VALUES ('3017','FAC003','2020-08-03');
INSERT INTO cleaning_area(janitor_id,facility_id,effective_date) VALUES ('3018','FAC004','2020-08-01');
INSERT INTO cleaning_area(janitor_id,facility_id,effective_date) VALUES ('3018','FAC005','2020-08-02');
INSERT INTO cleaning_area(janitor_id,facility_id,effective_date) VALUES ('3018','FAC006','2020-08-03');
INSERT INTO cleaning_area(janitor_id,facility_id,effective_date) VALUES ('3019','FAC007','2020-08-04');
INSERT INTO cleaning_area(janitor_id,facility_id,effective_date) VALUES ('3019','FAC008','2020-08-05');
INSERT INTO cleaning_area(janitor_id,facility_id,effective_date) VALUES ('3019','FAC009','2020-08-06');
INSERT INTO cleaning_area(janitor_id,facility_id,effective_date) VALUES ('3020','FAC010','2020-08-07');
INSERT INTO cleaning_area(janitor_id,facility_id,effective_date) VALUES ('3020','FAC011','2020-08-08');
CREATE TABLE cleaning_area( janitor_id VARCHAR(4) NOT NULL ,facility_id VARCHAR(6) NOT NULL ,effective_date DATE NOT NULL ,PRIMARY KEY(janitor_id,effective_date) ); INSERT INTO cleaning_area(janitor_id,facility_id,effective_date) VALUES ('3017','FAC001','2020-07-30'); INSERT INTO cleaning_area(janitor_id,facility_id,effective_date) VALUES ('3017','FAC002','2020-08-01'); INSERT INTO cleaning_area(janitor_id,facility_id,effective_date) VALUES ('3017','FAC003','2020-08-03'); INSERT INTO cleaning_area(janitor_id,facility_id,effective_date) VALUES ('3018','FAC004','2020-08-01'); INSERT INTO cleaning_area(janitor_id,facility_id,effective_date) VALUES ('3018','FAC005','2020-08-02'); INSERT INTO cleaning_area(janitor_id,facility_id,effective_date) VALUES ('3018','FAC006','2020-08-03'); INSERT INTO cleaning_area(janitor_id,facility_id,effective_date) VALUES ('3019','FAC007','2020-08-04'); INSERT INTO cleaning_area(janitor_id,facility_id,effective_date) VALUES ('3019','FAC008','2020-08-05'); INSERT INTO cleaning_area(janitor_id,facility_id,effective_date) VALUES ('3019','FAC009','2020-08-06'); INSERT INTO cleaning_area(janitor_id,facility_id,effective_date) VALUES ('3020','FAC010','2020-08-07'); INSERT INTO cleaning_area(janitor_id,facility_id,effective_date) VALUES ('3020','FAC011','2020-08-08');