By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
ID | PTA_1 | PTA_2 | PTA_3 | PTA_4 | PTA_5 | DTA_1 | DTA_2 | DTA_3 | DTA_4 | DTA_5 |
---|---|---|---|---|---|---|---|---|---|---|
1 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 |
2 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 |
3 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 |
4 | 1 | 0 | 1 | 0 | 0 | 0 | 1 | 0 | 0 | 0 |
ID | PartNum1 | PartNum2 | PartNum3 | PartNum4 | PartNum5 | DataNum1 | DataNum2 | DataNum3 | DataNum4 | DataNum5 |
---|---|---|---|---|---|---|---|---|---|---|
1 | PTA_1 | PTA_2 | PTA_3 | DTA_1 | DTA_2 | DTA_3 | DTA_4 | |||
2 | PTA_1 | DTA_1 | DTA_2 | |||||||
3 | PTA_1 | PTA_2 | DTA_1 | |||||||
4 | PTA_1 |
ID | column_name | column_value |
---|---|---|
1 | PTA_1 | 1 |
1 | PTA_2 | 0 |
1 | PTA_3 | 1 |
1 | DTA_1 | 0 |
1 | DTA_2 | 1 |
1 | DTA_3 | 0 |
1 | DTA_4 | 0 |
2 | PTA_1 | 1 |
2 | DTA_1 | 0 |
2 | DTA_2 | 1 |
3 | PTA_1 | 1 |
3 | PTA_2 | 0 |
3 | DTA_1 | 0 |
4 | PTA_1 | 1 |