By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
p_id | mx_datum |
---|---|
1 | 2018-06-22 |
2 | 2018-01-01 |
p_id | nname | vname | modul | datum | datum2 |
---|---|---|---|---|---|
1 | Müller | Christian | D | 2018-06-22 | 2020-06-22 |
2 | Huber | Martin | A | 2018-01-01 | 2020-01-01 |
p_id | nname | vname | modul | datum | datum2 |
---|---|---|---|---|---|
1 | Müller | Christian | A | 2012-01-01 | null |
1 | Müller | Christian | B | 2014-05-12 | null |
1 | Müller | Christian | D | 2018-06-22 | 2020-06-22 |
2 | Huber | Martin | A | 2018-01-01 | 2020-01-01 |
2 | Huber | Martin | C | 2014-06-13 | null |
p_id | modul | datum |
---|---|---|
1 | A | 2012-01-01 |
1 | B | 2014-05-12 |
1 | D | 2018-06-22 |
1 | NEU | 2020-06-22 |
2 | A | 2018-01-01 |
2 | C | 2014-06-13 |
2 | NEU | 2020-01-01 |
p_id | person | A | B | C | D | NEU |
---|---|---|---|---|---|---|
1 | Müller, Christian | 2012-01-01 | 2014-05-12 | null | 2018-06-22 | 2020-06-22 |
2 | Huber, Martin | 2018-01-01 | null | 2014-06-13 | null | 2020-01-01 |