Figure 2
A database schema diagram shows seven E S C O tables with labeled fields and arrows indicating foreign key relationships.The first table on the top left has 5 rows and 2 columns. Row 1 represents the table header “broader underscore Relations underscore Skill underscore Pillar,” and rows 2 to 5 are divided into two columns. The data presented in the table is as follows: Row 2: Column 1: concepty underscore type; Column 2: string. Row 3: Column 1: concept underscore u r i; Column 2: REFERENCES. Row 4: Column 1: broader underscore type; Column 2: string. Row 5: Column 1: broader U r i; Column 2: REFERENCE. The second table on the bottom left has 11 rows and 2 columns. Row 1 represents the table header “skill underscore groups,” and rows 2 to 11 are divided into two columns. The data presented is as follows: Row 2: Column 1: concepty underscore type; Column 2: string. Row 3: Column 1: concept underscore u r i; Column 2: REFERENCES. Row 4: Column 1: preferred underscore label; Column 2: string. Row 5: Column 1: alt underscore labels; Column 2: string. Row 6: Column 1: hidden underscore labels; Column 2: string. Row 7: Column 1: status; Column 2: string. Row 8: Column 1: modified underscore date; Column 2: timestamp. Row 9: Column 1: in underscore scheme; Column 2: string. Row 10: Column 1: description; Column 2: string. Row 11: Column 1: code; Column 2: string. The third table at the top center has 16 rows and 2 columns. Row 1 represents the table header “skills,” and rows 2 to 16 are divided into two columns. The data presented in the table is as follows: Row 2: Column 1: concept underscore type; Column 2: string. Row 3: Column 1: concept underscore u r i; Column 2: P K. Row 4: Column 1: skill underscore type; Column 2: string. Row 5: Column 1: reuse underscore level; Column 2: string. Row 6: Column 1: preferred underscore label; Column 2: string. Row 7: Column 1: alt underscore labels; Column 2: string. Row 8: Column 1: hidden underscore labels; Column 2: string. Row 9: Column 1: status; Column 2: string. Row 10: Column 1: modified underscore date; Column 2: timestamp. Row 11: Column 1: scope underscore note; Column 2: string. Row 12: Column 1: definition; Column 2: string. Row 13: Column 1: in underscore scheme; Column 2: string. Row 14: Column 1: description; Column 2: string. Row 15: Column 1: version; Column 2: string. Row 16: Column 1: is underscore deleted; Column 2: boolean. The fourth table on the bottom center has 6 rows and 2 columns. Row 1 is the table header “skill underscore skill underscore relations,” and rows 2 to 7 are divided into two columns. The data presented in the table is as follows: Row 2: Column 1: original underscore skill underscore u r i; Column 2: REFERENCES. Row 3: Column 1: original underscore skill underscore type; Column 2: string. Row 4: Column 1: relation underscore type; Column 2: string. Row 5: Column 1: related underscore skill underscore type; Column 2: string. Row 6: Column 1: related underscore skill underscore u r i; Column 2: REFERENCES. Row 7: Column 1: version; Column 2: string. The fifth table on the top right has 17 rows and 2 columns. Row 1 represents the table header “occupations,” and rows 2 to 17 are divided into two columns. The data presented in the table is as follows: Row 2: Column 1: concept underscore type; Column 2: string. Row 3: Column 1: concept underscore u r i; Column 2: P K. Row 4: Column 1: i s c o underscore group; Column 2: REFERENCES. Row 5: Column 1: preferred underscore label; Column 2: string. Row 6: Column 1: alt underscore labels; Column 2: string. Row 7: Column 1: hidden underscore labels; Column 2: string. Row 8: Column 1: status; Column 2: string. Row 9: Column 1: modified underscore date; Column 2: timestamp. Row 10: Column 1: regulated underscore profession underscore note; Column 2: Type. Row 11: Column 1: scope underscore note; Column 2: string. Row 12: Column 1: definition; Column 2: string. Row 13: Column 1: in underscore scheme; Column 2: string. Row 14: Column 1: description; Column 2: string. Row 15: Column 1: code; Column 2: string. Row 16: Column 1: version; Column 2: string. Row 17: Column 1: is underscore deleted; Column 2: boolean. The sixth table on the bottom center-right has 6 rows and 2 columns. Row 1 represents the table header “occupation underscore skill underscore relations,” and rows 2 to 7 are divided into two columns. The data presented in the table is as follows: Row 2: Column 1: occupation underscore u r i; Column 2: REFERENCES. Row 3: Column 1: relation underscore type; Column 2: string. Row 4: Column 1: skill underscore type; Column 2: string. Row 5: Column 1: skill underscore u r i; Column 2: REFERENCES. Row 6: Column 1: related underscore skill underscore u r i; Column 2: string. Row 7: Column 1: version; Column 2: string. The seventh table on the top, to the right of the fifth, has 10 rows and 2 columns. Row 1 represents the table header “I S C O underscore groups,” and rows 2 to 9 are divided into two columns. The data presented in the table is as follows: Row 2: Column 1: concept underscore type; Column 2: string. Row 3: Column 1: concept underscore u r i; Column 2: string. Row 4: Column 1: code; Column 2: P K. Row 5: Column 1: preferred underscore label; Column 2: string. Row 6: Column 1: status; Column 2: string. Row 7: Column 1: alt underscore labels; Column 2: string. Row 8: Column 1: in underscore scheme; Column 2: string. Row 9: Column 1: description; Column 2: string. Row 10: Column 1: version; Column 2: string. A line from “Row 3: Column 1: concept underscore u r i; Column 2: REFERENCES” of the first table connects to “Row 3: Column 1: concept underscore u r i; Column 2: P K” of the third table. A line from “Row 5: Column 1: broader u r i; Column 2: REFERENCE” of the first table connects to “Row 3: Column 1: concept underscore u r i; Column 2: REFERENCES” of the second table. A line from “Row 3: Column 1: concept underscore u r i; Column 2: REFERENCES” of the first table connects to “Row 5: Column 1: broader U r i; Column 2: REFERENCE” of the first table. A line from “Row 3: Column 1: concept underscore u r i; Column 2: P K” of the third table connects to “Row 2: Column 1: original underscore skill underscore u r i; Column 2: REFERENCES” of the fourth table. Another line from “Row 3: Column 1: concept underscore u r i; Column 2: P K” of the third table connects to “Row 5: Column 1: skill underscore u r i; Column 2: REFERENCES” of the sixth table. A line from “Row 3: Column 1: concept underscore u r i; Column 2: P K” of the fifth table connects to “Row 2: Column 1: occupation underscore u r i; Column 2: REFERENCES” of the sixth table. A line from “Row 4: Column 1: i s c o underscore group; Column 2: REFERENCES” of the fifth table connects to “Row 4: Column 1: code; Column 2: P K” of the seventh table.

The connections between concepts of the different ESCO tables. The arrows link primary and foreign keys to join tables. Source: Figure by authors

or Create an Account

Close subscription notice
Close access options