By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
50 rows affected
IdSottocategoria | Sottocategoria | IdCategoria | Note |
---|---|---|---|
IWG | Titolario | - | Categoria |
0 | HR | IWG | |
0.0 | CV | 0 | |
0.1 | test | 0 | null |
0.1.0 | ghjghjg | 0.1 | |
0.1.0.0 | ghghg | 0.1.0 | |
0.1.0.0.0 | sdf | 0.1.0.0 | |
0.1.0.0.0.0 | fsdfsdfsd | 0.1.0.0.0 | |
0.1.0.0.0.0.0 | dgdgdfg | 0.1.0.0.0.0 | |
0.1.0.0.0.0.1 | uiouoi | 0.1.0.0.0.0 | |
0.1.0.0.0.0.2 | yrtyrtyrtyrt | 0.1.0.0.0.0 | |
0.1.0.0.1 | HR - fghfhfghf | 0.1.0.0 | |
0.2 | bla | 0 | |
0.3 | AAA | 0 | |
0.4 | dasdas | 0 | |
0.5 | fghfghfgh | 0 | |
0.6 | HR - TEST PRIMO LIVELLO | 0 | |
0.6.0 | HR - TEST SECONDO LIVELLO | 0.6 | |
0.6.0.0 | HR - TEST TERZO LIVELLO | 0.6.0 | |
1 | Commerciale | IWG | |
1.1 | XXX | 1 | null |
1.1.0 | Commerciale - bla | 1.1 | |
1.2 | YYY | 1 | null |
1.3 | ZZZ | 1 | null |
1.4 | Commerciale - dsasdasd | 1 | |
2 | Titolario - TEST LIVELLO 0 | IWG | |
2.0 | bhjbhjbhbjb | 2 | |
2.0.0 | pippo | 2.0 | |
2.0.1 | Titolario - TEST LIVELLO 0 - dfgdfgdfg | 2.0 | |
3 | Titolario - TEST 2 LIVELLO 0 | IWG | |
4 | TEST 3 LIVELLO 0 | IWG | |
4.0 | TEST 3 LIVELLO 0 - LIVELLO 1 | 4 | |
4.0.0 | TEST 3 LIVELLO 0 - LIVELLO 2 | 4.0 | |
4.0.0.0 | TEST 3 LIVELLO 0 - LIVELLO 3 | 4.0.0 | |
4.0.1 | TEST 3 LIVELLO 0 - DASDASDAS | 4.0 | |
5 | ORDINAMENTO | IWG | |
5.0 | ORDINAMENTO - ORD 0 | 5 | |
5.0.0 | ORDINAMENTO - test | 5.0 | |
5.1 | ORDINAMENTO - ORD 1 | 5 | |
5.2 | ORDINAMENTO - ORD 2 | 5 | |
5.3 | ORDINAMENTO - ORD 3 | 5 | |
5.4 | ORDINAMENTO - ORD 4 | 5 | |
5.5 | ORDINAMENTO - ORD 5 | 5 | |
5.6 | ORDINAMENTO - ORD 6 | 5 | |
5.7 | ORDINAMENTO - ORD 7 | 5 | |
5.8 | ORDINAMENTO - ORD 8 | 5 | |
5.9 | ORDINAMENTO - ORD 9 | 5 | |
5.10 | ORDINAMENTO - ORD 10 | 5 | |
5.11 | ORDINAMENTO - ORD 11 | 5 | |
5.12 | ORDINAMENTO - ORD 12 | 5 |
IdSottocategoria | Sottocategoria | IdCategoria | Note | Hid |
---|---|---|---|---|
0 | HR | IWG | /0/ | |
0.0 | CV | 0 | /0/0/ | |
0.1 | test | 0 | null | /0/1/ |
0.1.0 | ghjghjg | 0.1 | /0/1/0/ | |
0.1.0.0 | ghghg | 0.1.0 | /0/1/0/0/ | |
0.1.0.0.0 | sdf | 0.1.0.0 | /0/1/0/0/0/ | |
0.1.0.0.0.0 | fsdfsdfsd | 0.1.0.0.0 | /0/1/0/0/0/0/ | |
0.1.0.0.0.0.0 | dgdgdfg | 0.1.0.0.0.0 | /0/1/0/0/0/0/0/ | |
0.1.0.0.0.0.1 | uiouoi | 0.1.0.0.0.0 | /0/1/0/0/0/0/1/ | |
0.1.0.0.0.0.2 | yrtyrtyrtyrt | 0.1.0.0.0.0 | /0/1/0/0/0/0/2/ | |
0.1.0.0.1 | HR - fghfhfghf | 0.1.0.0 | /0/1/0/0/1/ | |
0.2 | bla | 0 | /0/2/ | |
0.3 | AAA | 0 | /0/3/ | |
0.4 | dasdas | 0 | /0/4/ | |
0.5 | fghfghfgh | 0 | /0/5/ | |
0.6 | HR - TEST PRIMO LIVELLO | 0 | /0/6/ | |
0.6.0 | HR - TEST SECONDO LIVELLO | 0.6 | /0/6/0/ | |
0.6.0.0 | HR - TEST TERZO LIVELLO | 0.6.0 | /0/6/0/0/ | |
1 | Commerciale | IWG | /1/ | |
1.1 | XXX | 1 | null | /1/1/ |
1.1.0 | Commerciale - bla | 1.1 | /1/1/0/ | |
1.2 | YYY | 1 | null | /1/2/ |
1.3 | ZZZ | 1 | null | /1/3/ |
1.4 | Commerciale - dsasdasd | 1 | /1/4/ | |
2 | Titolario - TEST LIVELLO 0 | IWG | /2/ | |
2.0 | bhjbhjbhbjb | 2 | /2/0/ | |
2.0.0 | pippo | 2.0 | /2/0/0/ | |
2.0.1 | Titolario - TEST LIVELLO 0 - dfgdfgdfg | 2.0 | /2/0/1/ | |
3 | Titolario - TEST 2 LIVELLO 0 | IWG | /3/ | |
4 | TEST 3 LIVELLO 0 | IWG | /4/ | |
4.0 | TEST 3 LIVELLO 0 - LIVELLO 1 | 4 | /4/0/ | |
4.0.0 | TEST 3 LIVELLO 0 - LIVELLO 2 | 4.0 | /4/0/0/ | |
4.0.0.0 | TEST 3 LIVELLO 0 - LIVELLO 3 | 4.0.0 | /4/0/0/0/ | |
4.0.1 | TEST 3 LIVELLO 0 - DASDASDAS | 4.0 | /4/0/1/ | |
5 | ORDINAMENTO | IWG | /5/ | |
5.0 | ORDINAMENTO - ORD 0 | 5 | /5/0/ | |
5.0.0 | ORDINAMENTO - test | 5.0 | /5/0/0/ | |
5.1 | ORDINAMENTO - ORD 1 | 5 | /5/1/ | |
5.2 | ORDINAMENTO - ORD 2 | 5 | /5/2/ | |
5.3 | ORDINAMENTO - ORD 3 | 5 | /5/3/ | |
5.4 | ORDINAMENTO - ORD 4 | 5 | /5/4/ | |
5.5 | ORDINAMENTO - ORD 5 | 5 | /5/5/ | |
5.6 | ORDINAMENTO - ORD 6 | 5 | /5/6/ | |
5.7 | ORDINAMENTO - ORD 7 | 5 | /5/7/ | |
5.8 | ORDINAMENTO - ORD 8 | 5 | /5/8/ | |
5.9 | ORDINAMENTO - ORD 9 | 5 | /5/9/ | |
5.10 | ORDINAMENTO - ORD 10 | 5 | /5/10/ | |
5.11 | ORDINAMENTO - ORD 11 | 5 | /5/11/ | |
5.12 | ORDINAMENTO - ORD 12 | 5 | /5/12/ | |
IWG | Titolario | - | Categoria | null |