By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
id | p_id | col | id | p_id | name | value |
---|---|---|---|---|---|---|
1 | 1 | Kolumna 1 | 1 | 1 | atrybut 1 | 1 |
1 | 1 | Kolumna 1 | 2 | 1 | atrybut 2 | 10 |
1 | 1 | Kolumna 1 | 3 | 1 | atrybut 3 | 100 |
2 | 2 | Kolumna 2 | 4 | 2 | atrybut 1 | 2 |
2 | 2 | Kolumna 2 | 5 | 2 | atrybut 2 | 20 |
2 | 2 | Kolumna 2 | 6 | 2 | atrybut 3 | 200 |
3 | 3 | Kolumna 3 | 7 | 3 | atrybut 1 | 3 |
3 | 3 | Kolumna 3 | 8 | 3 | atrybut 2 | 30 |
3 | 3 | Kolumna 3 | 9 | 3 | atrybut 3 | 300 |
id | col | attr1 | attr2 | attr3 |
---|---|---|---|---|
1 | Kolumna 1 | 1 | 10 | 100 |
2 | Kolumna 2 | 2 | 20 | 200 |
3 | Kolumna 3 | 3 | 30 | 300 |