CREATE TABLE abilities_to_work_context ( abilities_element_id CHARACTER VARYING(20) NOT NULL, work_context_element_id CHARACTER VARYING(20) NOT NULL, FOREIGN KEY (abilities_element_id) REFERENCES content_model_reference(element_id), FOREIGN KEY (work_context_element_id) REFERENCES content_model_reference(element_id)); GO INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.a.1', '4.C.1.a.2.c'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.a.1', '4.C.1.a.2.f'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.a.1', '4.C.1.a.2.l'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.a.1', '4.C.1.a.4'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.a.1', '4.C.1.b.1.e'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.a.1', '4.C.1.b.1.f'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.a.1', '4.C.1.b.1.g'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.a.1', '4.C.1.c.1'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.a.1', '4.C.1.c.2'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.a.1', '4.C.1.d.1'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.a.1', '4.C.1.d.2'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.a.1', '4.C.1.d.3'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.a.2', '4.C.1.a.2.h'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.a.2', '4.C.1.a.2.j'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.a.3', '4.C.1.a.2.c'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.a.3', '4.C.1.a.2.f'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.a.3', '4.C.1.a.2.l'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.a.3', '4.C.1.a.4'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.a.3', '4.C.1.b.1.e'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.a.3', '4.C.1.b.1.f'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.a.3', '4.C.1.b.1.g'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.a.3', '4.C.1.c.1'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.a.3', '4.C.1.c.2'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.a.3', '4.C.1.d.1'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.a.3', '4.C.1.d.2'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.a.3', '4.C.1.d.3'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.a.4', '4.C.1.a.2.h'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.a.4', '4.C.1.a.2.j'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.a.4', '4.C.1.b.1.g'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.b.3', '4.C.1.a.2.l'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.b.3', '4.C.1.b.1.e'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.b.3', '4.C.1.b.1.f'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.b.3', '4.C.1.b.1.g'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.b.3', '4.C.1.c.1'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.b.3', '4.C.1.c.2'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.b.3', '4.C.1.d.1'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.b.3', '4.C.1.d.2'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.b.3', '4.C.1.d.3'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.b.3', '4.C.3.a.1'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.b.3', '4.C.3.a.2.a'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.b.3', '4.C.3.a.4'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.b.3', '4.C.3.b.8'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.b.3', '4.C.3.c.1'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.b.4', '4.C.1.b.1.f'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.b.4', '4.C.1.b.1.g'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.b.4', '4.C.1.d.1'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.b.4', '4.C.1.d.2'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.b.4', '4.C.1.d.3'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.b.4', '4.C.3.a.2.a'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.b.4', '4.C.3.a.4'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.b.4', '4.C.3.b.8'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.b.4', '4.C.3.c.1'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.b.5', '4.C.1.b.1.f'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.b.5', '4.C.1.b.1.g'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.b.5', '4.C.1.d.1'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.b.5', '4.C.1.d.2'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.b.5', '4.C.3.a.2.a'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.b.5', '4.C.3.a.4'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.b.5', '4.C.3.b.8'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.b.5', '4.C.3.c.1'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.b.6', '4.C.1.b.1.g'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.b.7', '4.C.1.b.1.g'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.g.1', '4.C.1.a.2.l'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.g.1', '4.C.2.b.1.a'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.g.1', '4.C.3.b.7'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.g.1', '4.C.3.d.3'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.1.g.2', '4.C.1.b.1.g'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.2.a.1', '4.C.2.d.1.g'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.2.a.2', '4.C.1.d.3'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.2.a.2', '4.C.2.d.1.c'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.2.a.2', '4.C.2.d.1.g'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.2.a.3', '4.C.2.d.1.g'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.2.b.1', '4.C.2.d.1.g'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.2.b.2', '4.C.1.d.3'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.2.b.3', '4.C.1.d.3'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.2.b.4', '4.C.3.d.3'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.2.c.1', '4.C.1.d.3'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.2.c.1', '4.C.2.c.1.e'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.2.c.1', '4.C.3.d.3'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.2.c.3', '4.C.1.d.3'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.3.a.1', '4.C.1.d.3'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.3.a.2', '4.C.1.d.3'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.3.a.2', '4.C.2.d.1.d'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.3.a.3', '4.C.1.d.3'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.3.a.3', '4.C.2.d.1.c'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.3.a.3', '4.C.2.d.1.i'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.3.a.4', '4.C.1.d.3'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.3.a.4', '4.C.2.b.1.f'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.3.a.4', '4.C.2.d.1.a'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.3.a.4', '4.C.2.d.1.b'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.3.a.4', '4.C.2.d.1.c'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.3.a.4', '4.C.2.d.1.d'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.3.a.4', '4.C.2.d.1.e'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.3.a.4', '4.C.2.d.1.f'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.3.b.1', '4.C.1.d.3'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.3.b.1', '4.C.2.d.1.d'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.3.c.1', '4.C.1.d.3'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.3.c.1', '4.C.2.b.1.e'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.3.c.1', '4.C.2.d.1.c'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.3.c.1', '4.C.2.d.1.e'); GO INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.3.c.1', '4.C.2.d.1.h'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.3.c.3', '4.C.1.d.3'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.3.c.3', '4.C.2.d.1.c'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.3.c.3', '4.C.2.d.1.d'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.3.c.3', '4.C.2.d.1.e'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.3.c.4', '4.C.1.d.3'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.3.c.4', '4.C.2.c.1.c'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.3.c.4', '4.C.2.d.1.c'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.3.c.4', '4.C.2.d.1.d'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.3.c.4', '4.C.2.d.1.e'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.3.c.4', '4.C.2.d.1.f'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.3.c.4', '4.C.2.d.1.h'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.4.a.1', '4.C.1.a.2.h'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.4.a.1', '4.C.2.c.1.e'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.4.a.7', '4.C.2.b.1.c'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.4.b.2', '4.C.2.b.1.a'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.4.b.4', '4.C.1.a.2.f'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.4.b.4', '4.C.1.a.2.l'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.4.b.4', '4.C.1.a.4'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.4.b.4', '4.C.1.b.1.e'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.4.b.4', '4.C.1.b.1.f'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.4.b.4', '4.C.1.b.1.g'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.4.b.4', '4.C.1.c.1'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.4.b.4', '4.C.1.c.2'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.4.b.4', '4.C.1.d.1'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.4.b.4', '4.C.1.d.2'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.4.b.4', '4.C.1.d.3'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.4.b.5', '4.C.1.a.2.c'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.4.b.5', '4.C.1.a.2.f'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.4.b.5', '4.C.1.a.2.l'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.4.b.5', '4.C.1.a.4'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.4.b.5', '4.C.1.b.1.e'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.4.b.5', '4.C.1.b.1.f'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.4.b.5', '4.C.1.b.1.g'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.4.b.5', '4.C.1.c.1'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.4.b.5', '4.C.1.c.2'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.4.b.5', '4.C.1.d.1'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.4.b.5', '4.C.1.d.2'); INSERT INTO abilities_to_work_context (abilities_element_id, work_context_element_id) VALUES ('1.A.4.b.5', '4.C.1.d.3'); GO