Created
October 22, 2024 21:33
-
-
Save thomas-schuster/91e69589f359ffe1c32e5abb8b865e18 to your computer and use it in GitHub Desktop.
Create an ERD with pgAdmin, create a schema from it and insert sample data (on some tables).
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Anna', 'Wagner', '1976-02-27', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Anna', 'Fischer', '1973-03-26', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Anna', 'Meyer', '1973-06-14', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Tim', 'Fischer', '1990-02-10', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Paul', 'Wagner', '1982-09-06', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Laura', 'Müller', '1989-12-20', 'laura.mü[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Max', 'Schmidt', '1986-08-03', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Nina', 'Hoffmann', '1993-02-09', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Max', 'Weber', '1971-05-03', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Sophie', 'Weber', '1972-12-24', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Max', 'Schäfer', '2000-04-28', 'max.schä[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Jonas', 'Hoffmann', '1971-10-23', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Jonas', 'Schäfer', '2000-07-25', 'jonas.schä[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Nina', 'Schneider', '1986-07-28', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Max', 'Müller', '1970-11-14', 'max.mü[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Maria', 'Wagner', '1986-04-23', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Paul', 'Becker', '1987-10-18', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Sophie', 'Weber', '1990-12-15', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Jonas', 'Schneider', '1975-06-21', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Nina', 'Schäfer', '1985-02-13', 'nina.schä[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Maria', 'Schmidt', '1985-01-09', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Jonas', 'Schäfer', '1982-03-11', 'jonas.schä[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Tim', 'Meyer', '1973-11-10', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Paul', 'Meyer', '1977-12-14', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Maria', 'Weber', '1992-06-04', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Nina', 'Becker', '1992-11-02', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Sophie', 'Hoffmann', '1981-09-03', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Laura', 'Müller', '1997-07-15', 'laura.mü[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Jonas', 'Fischer', '1975-10-22', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Anna', 'Schmidt', '1997-12-26', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Jonas', 'Müller', '1989-04-12', 'jonas.mü[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Laura', 'Fischer', '1991-04-13', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Sophie', 'Wagner', '1973-11-04', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Max', 'Wagner', '1979-10-05', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Nina', 'Schmidt', '1998-02-02', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Anna', 'Schäfer', '1992-10-15', 'anna.schä[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Tim', 'Fischer', '1978-02-09', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Anna', 'Schmidt', '1983-04-26', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Maria', 'Becker', '1999-01-17', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Tim', 'Becker', '1985-10-07', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Lukas', 'Becker', '1983-05-03', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Nina', 'Becker', '1972-06-23', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Tim', 'Wagner', '1979-06-08', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Anna', 'Wagner', '1995-10-15', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Nina', 'Schäfer', '2000-07-19', 'nina.schä[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Maria', 'Meyer', '1970-12-07', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Jonas', 'Hoffmann', '1979-01-18', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Jonas', 'Weber', '1985-10-17', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Tim', 'Becker', '1996-10-28', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Maria', 'Schmidt', '1994-05-27', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Nina', 'Becker', '1995-03-09', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Tim', 'Schmidt', '1979-08-01', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Max', 'Schäfer', '2000-04-13', 'max.schä[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Max', 'Schneider', '1990-04-19', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Sophie', 'Schäfer', '1984-07-24', 'sophie.schä[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Nina', 'Schmidt', '1975-11-15', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Paul', 'Wagner', '2000-08-05', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Paul', 'Wagner', '1984-09-02', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Laura', 'Müller', '1987-11-12', 'laura.mü[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Sophie', 'Schmidt', '1980-12-17', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Max', 'Hoffmann', '1988-11-19', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Nina', 'Hoffmann', '1994-05-26', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Lukas', 'Schäfer', '1977-09-21', 'lukas.schä[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Jonas', 'Wagner', '1982-11-11', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Nina', 'Meyer', '1991-04-11', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Sophie', 'Weber', '1970-12-20', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Lukas', 'Wagner', '1991-02-27', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Jonas', 'Schmidt', '1977-12-10', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Nina', 'Fischer', '1988-06-10', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Jonas', 'Schmidt', '1982-02-11', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Tim', 'Fischer', '1989-04-11', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Laura', 'Meyer', '1989-02-13', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Max', 'Schäfer', '1988-02-04', 'max.schä[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Paul', 'Weber', '1979-02-15', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Paul', 'Schneider', '1983-09-16', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Tim', 'Becker', '1991-04-10', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Paul', 'Wagner', '1997-04-26', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Maria', 'Schneider', '1992-01-05', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Tim', 'Hoffmann', '1985-08-14', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Paul', 'Weber', '1978-12-09', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Tim', 'Meyer', '1998-02-23', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Lukas', 'Müller', '1998-12-28', 'lukas.mü[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Jonas', 'Becker', '1971-10-10', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Nina', 'Müller', '1976-09-16', 'nina.mü[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Anna', 'Müller', '1977-10-16', 'anna.mü[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Sophie', 'Fischer', '1971-03-21', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Jonas', 'Meyer', '1988-08-03', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Paul', 'Wagner', '1999-01-21', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Sophie', 'Weber', '1994-11-01', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Jonas', 'Weber', '1975-09-26', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Jonas', 'Hoffmann', '1993-06-16', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Lukas', 'Hoffmann', '1983-08-06', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Nina', 'Meyer', '1989-09-04', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Lukas', 'Schäfer', '1974-07-21', 'lukas.schä[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Anna', 'Fischer', '1979-03-27', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Laura', 'Fischer', '1976-09-04', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Jonas', 'Schneider', '1976-04-02', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Maria', 'Becker', '1982-06-27', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Anna', 'Meyer', '1999-12-06', '[email protected]'); | |
| INSERT INTO student200.mitglieder (vorname, nachname, geburtsdatum, email) VALUES ('Maria', 'Hoffmann', '1998-06-23', '[email protected]'); | |
| INSERT INTO student200.trainer (vorname, nachname, email) VALUES ('Maria', 'Schäfer', 'maria.schä[email protected]'); | |
| INSERT INTO student200.trainer (vorname, nachname, email) VALUES ('Maria', 'Müller', 'maria.mü[email protected]'); | |
| INSERT INTO student200.trainer (vorname, nachname, email) VALUES ('Max', 'Schneider', '[email protected]'); | |
| INSERT INTO student200.trainer (vorname, nachname, email) VALUES ('Laura', 'Müller', 'laura.mü[email protected]'); | |
| INSERT INTO student200.trainer (vorname, nachname, email) VALUES ('Anna', 'Hoffmann', '[email protected]'); | |
| INSERT INTO student200.trainer (vorname, nachname, email) VALUES ('Lukas', 'Wagner', '[email protected]'); | |
| INSERT INTO student200.trainer (vorname, nachname, email) VALUES ('Paul', 'Hoffmann', '[email protected]'); | |
| INSERT INTO student200.trainer (vorname, nachname, email) VALUES ('Nina', 'Wagner', '[email protected]'); | |
| INSERT INTO student200.trainer (vorname, nachname, email) VALUES ('Maria', 'Becker', '[email protected]'); | |
| INSERT INTO student200.trainer (vorname, nachname, email) VALUES ('Laura', 'Schmidt', '[email protected]'); | |
| INSERT INTO student200.trainer (vorname, nachname, email) VALUES ('Anna', 'Schmidt', '[email protected]'); | |
| INSERT INTO student200.trainer (vorname, nachname, email) VALUES ('Sophie', 'Wagner', '[email protected]'); | |
| INSERT INTO student200.trainer (vorname, nachname, email) VALUES ('Anna', 'Meyer', '[email protected]'); | |
| INSERT INTO student200.trainer (vorname, nachname, email) VALUES ('Jonas', 'Meyer', '[email protected]'); | |
| INSERT INTO student200.trainer (vorname, nachname, email) VALUES ('Jonas', 'Schäfer', 'jonas.schä[email protected]'); | |
| INSERT INTO student200.trainer (vorname, nachname, email) VALUES ('Anna', 'Hoffmann', '[email protected]'); | |
| INSERT INTO student200.trainer (vorname, nachname, email) VALUES ('Jonas', 'Weber', '[email protected]'); | |
| INSERT INTO student200.trainer (vorname, nachname, email) VALUES ('Nina', 'Fischer', '[email protected]'); | |
| INSERT INTO student200.trainer (vorname, nachname, email) VALUES ('Anna', 'Meyer', '[email protected]'); | |
| INSERT INTO student200.trainer (vorname, nachname, email) VALUES ('Paul', 'Weber', '[email protected]'); | |
| INSERT INTO student200.studio (name, strasse, hausnummer, plz, oeffnungszeiten, stadt, landescode, provinz) VALUES ('Studio 1', 'Habermehlstrasse', 38, '78174', '08:00-22:00', 'Pforzheim', 'D', 'Baden-Württemberg'); | |
| INSERT INTO student200.studio (name, strasse, hausnummer, plz, oeffnungszeiten, stadt, landescode, provinz) VALUES ('Studio 2', 'Strasse 51', 40, '76014', '08:00-22:00', 'Osnabrück', 'D', 'Niedersachsen'); | |
| INSERT INTO student200.studio (name, strasse, hausnummer, plz, oeffnungszeiten, stadt, landescode, provinz) VALUES ('Studio 3', 'Strasse 78', 40, '75338', '08:00-22:00', 'Heidelberg', 'D', 'Baden-Württemberg'); | |
| INSERT INTO student200.studio (name, strasse, hausnummer, plz, oeffnungszeiten, stadt, landescode, provinz) VALUES ('Studio 4', 'Strasse 15', 19, '78577', '08:00-22:00', 'Stuttgart', 'D', 'Baden-Württemberg'); | |
| INSERT INTO student200.studio (name, strasse, hausnummer, plz, oeffnungszeiten, stadt, landescode, provinz) VALUES ('Studio 5', 'Strasse 49', 11, '76720', '08:00-22:00', 'Mülheim', 'D', 'Nordrhein-Westfalen'); | |
| INSERT INTO student200.studio (name, strasse, hausnummer, plz, oeffnungszeiten, stadt, landescode, provinz) VALUES ('Studio 6', 'Strasse 38', 45, '75420', '08:00-22:00', 'Dresden', 'D', 'Sachsen'); | |
| INSERT INTO student200.studio (name, strasse, hausnummer, plz, oeffnungszeiten, stadt, landescode, provinz) VALUES ('Studio 7', 'Strasse 58', 42, '74975', '08:00-22:00', 'Wiesbaden', 'D', 'Hessen'); | |
| INSERT INTO student200.studio (name, strasse, hausnummer, plz, oeffnungszeiten, stadt, landescode, provinz) VALUES ('Studio 8', 'Strasse 54', 43, '70464', '08:00-22:00', 'Stuttgart', 'D', 'Baden-Württemberg'); | |
| INSERT INTO student200.studio (name, strasse, hausnummer, plz, oeffnungszeiten, stadt, landescode, provinz) VALUES ('Studio 9', 'Strasse 66', 20, '77723', '08:00-22:00', 'Zwickau', 'D', 'Sachsen'); | |
| INSERT INTO student200.studio (name, strasse, hausnummer, plz, oeffnungszeiten, stadt, landescode, provinz) VALUES ('Studio 10', 'Strasse 61', 10, '73710', '08:00-22:00', 'Heilbronn', 'D', 'Baden-Württemberg'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 10', 1, '2024-11-19', '14:00:00', '20:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 11', 1, '2024-07-18', '10:00:00', '21:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 12', 1, '2024-01-06', '9:00:00', '21:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 13', 1, '2025-07-02', '11:00:00', '21:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 14', 1, '2025-01-14', '13:00:00', '20:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 20', 2, '2025-12-18', '18:00:00', '21:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 21', 2, '2024-03-25', '8:00:00', '20:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 30', 3, '2024-06-07', '13:00:00', '19:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 40', 4, '2025-09-05', '16:00:00', '19:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 41', 4, '2025-09-14', '16:00:00', '21:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 42', 4, '2024-11-03', '13:00:00', '21:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 43', 4, '2024-05-23', '14:00:00', '19:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 50', 5, '2025-04-23', '8:00:00', '20:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 60', 6, '2024-03-22', '12:00:00', '22:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 61', 6, '2025-07-28', '14:00:00', '20:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 62', 6, '2025-05-12', '18:00:00', '19:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 63', 6, '2024-03-16', '16:00:00', '22:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 70', 7, '2025-12-16', '8:00:00', '22:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 80', 8, '2024-01-27', '17:00:00', '21:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 81', 8, '2024-04-20', '12:00:00', '22:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 82', 8, '2025-06-12', '17:00:00', '19:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 90', 9, '2025-05-12', '16:00:00', '22:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 91', 9, '2024-12-11', '10:00:00', '21:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 92', 9, '2025-02-09', '17:00:00', '20:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 93', 9, '2024-02-26', '9:00:00', '19:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 94', 9, '2025-03-25', '13:00:00', '22:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 100', 10, '2025-04-02', '9:00:00', '22:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 101', 10, '2024-01-27', '14:00:00', '21:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 110', 11, '2024-08-17', '16:00:00', '21:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 111', 11, '2025-07-05', '10:00:00', '20:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 112', 11, '2024-03-07', '12:00:00', '20:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 120', 12, '2024-05-04', '12:00:00', '20:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 121', 12, '2025-09-06', '13:00:00', '21:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 122', 12, '2024-04-14', '8:00:00', '22:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 123', 12, '2024-04-06', '15:00:00', '22:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 124', 12, '2024-10-20', '17:00:00', '22:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 130', 13, '2024-04-20', '15:00:00', '20:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 131', 13, '2025-07-13', '8:00:00', '20:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 132', 13, '2024-12-18', '14:00:00', '21:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 133', 13, '2025-01-16', '17:00:00', '21:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 134', 13, '2025-02-03', '13:00:00', '19:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 140', 14, '2025-08-05', '18:00:00', '19:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 141', 14, '2025-06-21', '10:00:00', '20:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 142', 14, '2024-10-02', '17:00:00', '21:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 150', 15, '2025-12-27', '13:00:00', '19:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 151', 15, '2024-11-03', '17:00:00', '22:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 160', 16, '2025-10-10', '11:00:00', '20:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 161', 16, '2024-08-07', '10:00:00', '20:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 162', 16, '2024-05-04', '10:00:00', '21:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 163', 16, '2024-04-25', '8:00:00', '20:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 170', 17, '2025-04-20', '16:00:00', '19:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 171', 17, '2025-03-22', '14:00:00', '21:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 172', 17, '2025-10-14', '16:00:00', '21:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 173', 17, '2024-04-28', '18:00:00', '21:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 180', 18, '2025-12-01', '11:00:00', '19:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 181', 18, '2024-02-03', '16:00:00', '20:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 190', 19, '2024-12-11', '14:00:00', '22:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 191', 19, '2024-04-06', '13:00:00', '21:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 192', 19, '2025-05-07', '15:00:00', '21:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 193', 19, '2024-09-18', '9:00:00', '20:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 194', 19, '2024-07-15', '10:00:00', '20:00:00'); | |
| INSERT INTO student200.kurse (name, trainer_id, datum, start_zeit, end_zeit) VALUES ('Kurs 200', 20, '2024-01-13', '13:00:00', '21:00:00'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (1, 3, '2023-09-08', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (2, 9, '2023-12-12', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (3, 48, '2024-09-24', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (3, 36, '2023-01-20', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (3, 43, '2024-03-15', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (4, 57, '2023-07-18', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (5, 25, '2024-04-12', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (5, 26, '2023-08-01', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (5, 37, '2023-02-13', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (6, 49, '2024-11-05', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (6, 12, '2023-11-12', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (6, 10, '2023-04-11', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (7, 35, '2023-02-04', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (7, 40, '2024-03-04', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (8, 19, '2024-09-26', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (9, 54, '2023-09-23', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (10, 55, '2023-01-05', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (11, 2, '2023-01-24', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (11, 25, '2024-11-20', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (11, 47, '2023-09-09', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (12, 10, '2024-02-25', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (13, 19, '2023-07-18', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (13, 60, '2024-12-04', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (14, 18, '2023-10-07', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (14, 28, '2024-03-28', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (14, 10, '2024-02-21', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (15, 26, '2023-06-10', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (15, 5, '2024-07-25', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (16, 10, '2023-04-08', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (16, 53, '2023-11-21', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (16, 8, '2024-11-14', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (17, 15, '2024-03-02', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (17, 14, '2023-01-04', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (18, 27, '2024-07-24', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (18, 37, '2024-10-10', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (18, 42, '2023-06-23', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (19, 50, '2023-06-04', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (19, 42, '2024-11-22', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (19, 24, '2023-02-07', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (20, 40, '2024-12-02', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (20, 11, '2024-04-09', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (20, 16, '2023-11-28', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (21, 52, '2024-05-20', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (21, 19, '2023-08-04', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (21, 44, '2023-12-04', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (22, 28, '2023-04-16', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (22, 4, '2023-05-20', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (23, 3, '2024-02-03', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (24, 34, '2023-06-25', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (24, 7, '2023-01-28', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (25, 34, '2024-07-16', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (26, 19, '2023-01-27', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (27, 28, '2023-07-12', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (27, 34, '2023-03-21', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (27, 25, '2024-05-06', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (28, 27, '2024-07-10', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (29, 22, '2023-12-28', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (29, 49, '2024-10-24', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (30, 17, '2023-07-13', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (30, 40, '2023-12-25', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (30, 1, '2023-06-24', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (31, 11, '2024-03-06', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (31, 20, '2024-11-22', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (32, 29, '2023-11-08', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (32, 15, '2023-04-10', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (33, 8, '2024-11-23', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (33, 36, '2024-03-18', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (34, 47, '2024-09-27', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (35, 47, '2024-10-22', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (35, 28, '2023-02-16', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (36, 21, '2024-04-11', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (37, 22, '2023-09-03', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (38, 7, '2023-03-28', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (38, 40, '2024-10-13', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (39, 7, '2023-05-18', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (40, 44, '2023-02-03', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (40, 35, '2023-08-17', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (41, 6, '2024-01-23', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (41, 61, '2024-04-02', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (42, 61, '2024-03-20', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (43, 2, '2023-11-12', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (43, 34, '2023-09-12', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (43, 13, '2024-09-28', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (44, 7, '2024-03-21', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (45, 9, '2023-09-05', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (45, 19, '2024-06-05', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (46, 59, '2024-02-17', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (46, 15, '2024-03-06', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (46, 5, '2023-12-12', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (47, 29, '2024-09-25', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (47, 53, '2024-05-16', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (47, 8, '2023-04-24', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (48, 27, '2023-04-17', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (49, 55, '2023-01-23', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (49, 14, '2023-05-20', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (49, 7, '2023-05-22', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (50, 9, '2024-03-06', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (50, 29, '2023-01-27', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (51, 28, '2024-03-03', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (51, 21, '2024-04-10', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (52, 8, '2024-07-06', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (53, 57, '2023-07-08', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (53, 6, '2024-07-18', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (53, 35, '2023-03-27', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (54, 36, '2023-10-03', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (55, 23, '2024-01-19', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (55, 24, '2024-04-24', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (55, 7, '2023-09-07', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (56, 22, '2023-06-04', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (56, 8, '2024-11-04', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (56, 5, '2023-10-26', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (57, 28, '2024-09-23', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (58, 23, '2024-10-24', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (59, 5, '2023-10-11', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (60, 29, '2023-05-27', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (60, 9, '2023-05-10', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (61, 7, '2024-02-13', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (62, 5, '2023-04-21', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (62, 5, '2023-01-08', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (63, 9, '2024-11-17', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (64, 6, '2023-02-14', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (64, 8, '2024-02-10', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (65, 34, '2023-10-21', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (66, 47, '2023-05-25', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (67, 52, '2024-10-13', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (67, 59, '2023-02-25', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (68, 9, '2023-04-28', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (69, 31, '2023-06-03', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (70, 18, '2023-09-05', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (70, 44, '2024-09-07', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (70, 35, '2023-12-13', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (71, 10, '2024-11-17', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (71, 55, '2024-02-09', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (72, 54, '2024-09-03', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (72, 59, '2024-06-11', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (72, 55, '2024-01-08', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (73, 1, '2024-01-27', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (74, 8, '2024-08-24', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (74, 24, '2024-01-28', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (74, 43, '2023-02-08', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (75, 20, '2023-07-27', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (75, 8, '2024-02-16', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (75, 30, '2023-05-18', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (76, 8, '2023-05-21', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (76, 57, '2023-04-27', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (77, 60, '2024-09-20', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (77, 7, '2023-06-21', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (78, 49, '2024-03-20', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (78, 17, '2024-04-11', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (79, 33, '2024-04-07', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (79, 14, '2023-10-01', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (79, 23, '2023-03-14', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (80, 45, '2024-09-05', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (80, 48, '2023-06-06', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (81, 2, '2023-11-25', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (82, 7, '2023-11-20', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (82, 9, '2024-04-05', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (82, 54, '2024-08-16', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (83, 22, '2023-02-28', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (84, 9, '2023-12-13', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (84, 42, '2023-03-26', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (84, 3, '2023-02-02', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (85, 46, '2023-02-24', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (85, 60, '2023-02-28', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (85, 48, '2023-06-25', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (86, 9, '2024-04-04', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (86, 54, '2023-05-05', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (87, 36, '2023-02-13', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (87, 61, '2023-07-27', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (87, 30, '2024-10-22', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (88, 42, '2023-02-20', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (88, 19, '2024-10-17', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (88, 38, '2023-01-24', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (89, 57, '2023-12-14', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (90, 30, '2024-07-03', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (91, 51, '2024-10-05', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (91, 6, '2024-09-21', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (92, 37, '2023-07-08', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (93, 41, '2023-10-06', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (94, 47, '2023-10-03', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (94, 57, '2024-11-01', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (94, 61, '2024-01-10', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (95, 5, '2024-11-25', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (95, 56, '2023-06-16', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (95, 6, '2024-11-13', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (96, 7, '2023-01-20', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (96, 19, '2024-06-01', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (97, 8, '2024-05-20', 'gebucht'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (97, 27, '2024-12-20', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (98, 5, '2024-08-28', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (99, 59, '2024-01-03', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (100, 58, '2024-10-06', 'storniert'); | |
| INSERT INTO student200.buchungen (mitglied_id, kurs_id, buchungsdatum, status) VALUES (100, 14, '2024-11-14', 'storniert'); |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- This script was generated by the ERD tool in pgAdmin 4. | |
| -- Please log an issue at https://github.com/pgadmin-org/pgadmin4/issues/new/choose if you find any bugs, including reproduction steps. | |
| BEGIN; | |
| CREATE TABLE IF NOT EXISTS student200.buchungen | |
| ( | |
| buchung_id serial NOT NULL, | |
| mitglied_id integer, | |
| kurs_id integer, | |
| buchungsdatum date NOT NULL, | |
| status character varying(50) COLLATE pg_catalog."default" DEFAULT 'gebucht'::character varying, | |
| CONSTRAINT buchungen_pkey PRIMARY KEY (buchung_id) | |
| ); | |
| CREATE TABLE IF NOT EXISTS student200.kurse | |
| ( | |
| kurs_id serial NOT NULL, | |
| name character varying(100) COLLATE pg_catalog."default" NOT NULL, | |
| trainer_id integer, | |
| datum date NOT NULL, | |
| start_zeit time without time zone, | |
| end_zeit time without time zone, | |
| CONSTRAINT kurse_pkey PRIMARY KEY (kurs_id) | |
| ); | |
| CREATE TABLE IF NOT EXISTS student200.maschinen | |
| ( | |
| maschinen_id serial NOT NULL, | |
| studio_id integer, | |
| maschinen_name character varying(100) COLLATE pg_catalog."default" NOT NULL, | |
| typ character varying(50) COLLATE pg_catalog."default" NOT NULL, | |
| wartungsdatum date, | |
| CONSTRAINT maschinen_pkey PRIMARY KEY (maschinen_id) | |
| ); | |
| CREATE TABLE IF NOT EXISTS student200.mitglieder | |
| ( | |
| mitglied_id serial NOT NULL, | |
| vorname character varying(100) COLLATE pg_catalog."default" NOT NULL, | |
| nachname character varying(100) COLLATE pg_catalog."default" NOT NULL, | |
| geburtsdatum date, | |
| email character varying(200) COLLATE pg_catalog."default" NOT NULL, | |
| CONSTRAINT mitglieder_pkey PRIMARY KEY (mitglied_id), | |
| CONSTRAINT mitglieder_email_key UNIQUE (email) | |
| ); | |
| CREATE TABLE IF NOT EXISTS student200.mitgliedschaften | |
| ( | |
| mitgliedschaft_id serial NOT NULL, | |
| mitglied_id integer, | |
| studio_id integer, | |
| start_datum date NOT NULL, | |
| end_datum date, | |
| mitgliedschafts_typ character varying(50) COLLATE pg_catalog."default" NOT NULL, | |
| CONSTRAINT mitgliedschaften_pkey PRIMARY KEY (mitgliedschaft_id) | |
| ); | |
| CREATE TABLE IF NOT EXISTS student200.studio | |
| ( | |
| studio_id serial NOT NULL, | |
| name character varying(100) COLLATE pg_catalog."default" NOT NULL, | |
| strasse character varying(100) COLLATE pg_catalog."default", | |
| hausnummer integer, | |
| plz character varying(5) COLLATE pg_catalog."default", | |
| oeffnungszeiten character varying(100) COLLATE pg_catalog."default", | |
| stadt character varying(50) COLLATE pg_catalog."default", | |
| landescode character varying(4) COLLATE pg_catalog."default", | |
| provinz character varying(50) COLLATE pg_catalog."default", | |
| CONSTRAINT studio_pkey PRIMARY KEY (studio_id) | |
| ); | |
| CREATE TABLE IF NOT EXISTS student200.trainer | |
| ( | |
| trainer_id serial NOT NULL, | |
| vorname character varying(100) COLLATE pg_catalog."default" NOT NULL, | |
| nachname character varying(100) COLLATE pg_catalog."default" NOT NULL, | |
| email character varying(200) COLLATE pg_catalog."default" NOT NULL, | |
| CONSTRAINT trainer_pkey PRIMARY KEY (trainer_id), | |
| CONSTRAINT trainer_email_key UNIQUE (email) | |
| ); | |
| CREATE TABLE IF NOT EXISTS student200.trainer_bewertungen | |
| ( | |
| bewertung_id serial NOT NULL, | |
| trainer_id integer, | |
| mitglied_id integer, | |
| bewertung integer, | |
| feedback text COLLATE pg_catalog."default", | |
| bewertungsdatum date NOT NULL, | |
| CONSTRAINT trainer_bewertungen_pkey PRIMARY KEY (bewertung_id) | |
| ); | |
| CREATE TABLE IF NOT EXISTS student200.trainingsplaene | |
| ( | |
| plan_id serial NOT NULL, | |
| mitglied_id integer, | |
| trainer_id integer, | |
| start_datum date NOT NULL, | |
| end_datum date, | |
| CONSTRAINT trainingsplaene_pkey PRIMARY KEY (plan_id) | |
| ); | |
| CREATE TABLE IF NOT EXISTS student200.trainingsplaene_uebungen | |
| ( | |
| plan_id integer NOT NULL, | |
| uebungs_id integer NOT NULL, | |
| saetze integer, | |
| wiederholungen integer, | |
| dauer interval, | |
| CONSTRAINT trainingsplaene_uebungen_pkey PRIMARY KEY (plan_id, uebungs_id) | |
| ); | |
| CREATE TABLE IF NOT EXISTS student200.uebungen | |
| ( | |
| uebungs_id serial NOT NULL, | |
| name character varying(100) COLLATE pg_catalog."default" NOT NULL, | |
| beschreibung text COLLATE pg_catalog."default", | |
| kalorien_pro_minute numeric(5, 2), | |
| CONSTRAINT uebungen_pkey PRIMARY KEY (uebungs_id) | |
| ); | |
| CREATE TABLE IF NOT EXISTS student200.zahlungen | |
| ( | |
| zahlung_id serial NOT NULL, | |
| mitglied_id integer, | |
| betrag numeric(10, 2) NOT NULL, | |
| zahlungsdatum date NOT NULL, | |
| zahlungsmethode character varying(50) COLLATE pg_catalog."default" NOT NULL, | |
| CONSTRAINT zahlungen_pkey PRIMARY KEY (zahlung_id) | |
| ); | |
| ALTER TABLE IF EXISTS student200.buchungen | |
| ADD CONSTRAINT buchungen_kurs_id_fkey FOREIGN KEY (kurs_id) | |
| REFERENCES student200.kurse (kurs_id) MATCH SIMPLE | |
| ON UPDATE NO ACTION | |
| ON DELETE CASCADE; | |
| ALTER TABLE IF EXISTS student200.buchungen | |
| ADD CONSTRAINT buchungen_mitglied_id_fkey FOREIGN KEY (mitglied_id) | |
| REFERENCES student200.mitglieder (mitglied_id) MATCH SIMPLE | |
| ON UPDATE NO ACTION | |
| ON DELETE CASCADE; | |
| ALTER TABLE IF EXISTS student200.kurse | |
| ADD CONSTRAINT kurse_trainer_id_fkey FOREIGN KEY (trainer_id) | |
| REFERENCES student200.trainer (trainer_id) MATCH SIMPLE | |
| ON UPDATE NO ACTION | |
| ON DELETE SET NULL; | |
| ALTER TABLE IF EXISTS student200.maschinen | |
| ADD CONSTRAINT maschinen_studio_id_fkey FOREIGN KEY (studio_id) | |
| REFERENCES student200.studio (studio_id) MATCH SIMPLE | |
| ON UPDATE NO ACTION | |
| ON DELETE CASCADE; | |
| ALTER TABLE IF EXISTS student200.mitgliedschaften | |
| ADD CONSTRAINT mitgliedschaften_mitglied_id_fkey FOREIGN KEY (mitglied_id) | |
| REFERENCES student200.mitglieder (mitglied_id) MATCH SIMPLE | |
| ON UPDATE NO ACTION | |
| ON DELETE CASCADE; | |
| ALTER TABLE IF EXISTS student200.mitgliedschaften | |
| ADD CONSTRAINT mitgliedschaften_studio_id_fkey FOREIGN KEY (studio_id) | |
| REFERENCES student200.studio (studio_id) MATCH SIMPLE | |
| ON UPDATE NO ACTION | |
| ON DELETE CASCADE; | |
| ALTER TABLE IF EXISTS student200.studio | |
| ADD CONSTRAINT "cityFK" FOREIGN KEY (stadt, landescode, provinz) | |
| REFERENCES public.city (name, country, province) MATCH SIMPLE | |
| ON UPDATE NO ACTION | |
| ON DELETE NO ACTION | |
| NOT VALID; | |
| ALTER TABLE IF EXISTS student200.trainer_bewertungen | |
| ADD CONSTRAINT trainer_bewertungen_mitglied_id_fkey FOREIGN KEY (mitglied_id) | |
| REFERENCES student200.mitglieder (mitglied_id) MATCH SIMPLE | |
| ON UPDATE NO ACTION | |
| ON DELETE CASCADE; | |
| ALTER TABLE IF EXISTS student200.trainer_bewertungen | |
| ADD CONSTRAINT trainer_bewertungen_trainer_id_fkey FOREIGN KEY (trainer_id) | |
| REFERENCES student200.trainer (trainer_id) MATCH SIMPLE | |
| ON UPDATE NO ACTION | |
| ON DELETE CASCADE; | |
| ALTER TABLE IF EXISTS student200.trainingsplaene | |
| ADD CONSTRAINT trainingsplaene_mitglied_id_fkey FOREIGN KEY (mitglied_id) | |
| REFERENCES student200.mitglieder (mitglied_id) MATCH SIMPLE | |
| ON UPDATE NO ACTION | |
| ON DELETE CASCADE; | |
| ALTER TABLE IF EXISTS student200.trainingsplaene | |
| ADD CONSTRAINT trainingsplaene_trainer_id_fkey FOREIGN KEY (trainer_id) | |
| REFERENCES student200.trainer (trainer_id) MATCH SIMPLE | |
| ON UPDATE NO ACTION | |
| ON DELETE SET NULL; | |
| ALTER TABLE IF EXISTS student200.trainingsplaene_uebungen | |
| ADD CONSTRAINT trainingsplaene_uebungen_plan_id_fkey FOREIGN KEY (plan_id) | |
| REFERENCES student200.trainingsplaene (plan_id) MATCH SIMPLE | |
| ON UPDATE NO ACTION | |
| ON DELETE CASCADE; | |
| ALTER TABLE IF EXISTS student200.trainingsplaene_uebungen | |
| ADD CONSTRAINT trainingsplaene_uebungen_uebungs_id_fkey FOREIGN KEY (uebungs_id) | |
| REFERENCES student200.uebungen (uebungs_id) MATCH SIMPLE | |
| ON UPDATE NO ACTION | |
| ON DELETE CASCADE; | |
| ALTER TABLE IF EXISTS student200.zahlungen | |
| ADD CONSTRAINT zahlungen_mitglied_id_fkey FOREIGN KEY (mitglied_id) | |
| REFERENCES student200.mitglieder (mitglied_id) MATCH SIMPLE | |
| ON UPDATE NO ACTION | |
| ON DELETE CASCADE; | |
| END; |
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| {"version":"81200","data":{"id":"b41ee771-1136-44ea-9b89-53357aa1b5da","offsetX":646.5684302696191,"offsetY":108.0407712109548,"zoom":56.4865244861937,"gridSize":15,"layers":[{"id":"df7160cf-1c2e-435f-8108-f76564883239","type":"diagram-links","isSvg":true,"transformed":true,"models":{"fb95efcd-62df-4592-a11c-be2af414c9b0":{"id":"fb95efcd-62df-4592-a11c-be2af414c9b0","locked":true,"type":"onetomany","selected":false,"source":"e404792f-1d61-45d7-a306-6f223cc02250","sourcePort":"b3afbb9d-e380-4da1-84ad-6394e05acd05","target":"b643626e-476d-4435-a26c-0cef2d19e68e","targetPort":"86e93ce4-d004-472d-b6b3-686320cc1701","points":[{"id":"1b205f4c-ce0f-4928-9a5a-564f36c4d003","type":"point","x":-260.7781613797997,"y":1187.8358659609348},{"id":"954d5b09-7c2f-47cd-8fbb-fa2b903b011c","type":"point","selected":false,"x":-163.38717319372046,"y":1187.8358659609348},{"id":"a69bbb0f-7c54-4d2d-b87c-a8c8823231fe","type":"point","selected":false,"x":-163.38717319372046,"y":923.8124406553416},{"id":"66ebf8e9-7806-4b0a-ae5e-607d3908b004","type":"point","x":-305.77655285412675,"y":923.8124406553416}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"b643626e-476d-4435-a26c-0cef2d19e68e","local_column_attnum":3,"referenced_table_uid":"e404792f-1d61-45d7-a306-6f223cc02250","referenced_column_attnum":1}},"4f63d7ac-e4e0-40cc-9d0a-51f3d05c45c9":{"id":"4f63d7ac-e4e0-40cc-9d0a-51f3d05c45c9","locked":true,"type":"onetomany","selected":false,"source":"245d534e-d739-426a-b6af-c9e057f17ac9","sourcePort":"8d9c8bbb-8dd6-4017-97f3-89b097463e69","target":"b643626e-476d-4435-a26c-0cef2d19e68e","targetPort":"25dd663b-8006-4c53-86a6-807e2dba5e8e","points":[{"id":"49473c77-b9bc-44f0-9a68-20f9c2744419","type":"point","x":210.75836634020516,"y":827.8376689159454},{"id":"6cf32806-506f-4d97-8811-cec94ba82a35","type":"point","selected":false,"x":210.75836634020516,"y":898.5491330488984},{"id":"fc4ef030-4228-43e3-a2df-5f8073ed3cd6","type":"point","selected":false,"x":-305.77655285412675,"y":898.5491330488984},{"id":"b10f3917-552d-4bd9-80f8-15006522cc0b","type":"point","x":-305.77655285412675,"y":898.3281017269567}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"b643626e-476d-4435-a26c-0cef2d19e68e","local_column_attnum":2,"referenced_table_uid":"245d534e-d739-426a-b6af-c9e057f17ac9","referenced_column_attnum":1}},"55cc165d-569a-419b-824c-cb6676b59b61":{"id":"55cc165d-569a-419b-824c-cb6676b59b61","locked":true,"type":"onetomany","selected":false,"source":"3e54e5c9-ea90-42e3-825a-64bb1a4a5e2a","sourcePort":"3fc727d5-0910-4408-a76f-561fb64f8e56","target":"e404792f-1d61-45d7-a306-6f223cc02250","targetPort":"fbaa1f82-3efb-432d-8cbe-8dd7508ac228","points":[{"id":"d113d482-1086-404e-8af1-c34f07ea1482","type":"point","x":-149.2463538016691,"y":1322.8425513520506},{"id":"ea3a61bb-2b3e-4dc3-bf0d-7ef3eb00c0d8","type":"point","selected":false,"x":-149.2463538016691,"y":1322.177338430064},{"id":"74515366-6df1-421b-9a12-20ee1fe63026","type":"point","selected":false,"x":-260.7781613797997,"y":1322.177338430064},{"id":"890adb3f-97af-4f5d-b122-258dae2cb8e3","type":"point","x":-260.7781613797997,"y":1258.107851317328}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"e404792f-1d61-45d7-a306-6f223cc02250","local_column_attnum":3,"referenced_table_uid":"3e54e5c9-ea90-42e3-825a-64bb1a4a5e2a","referenced_column_attnum":1}},"9410f265-0784-44ab-b7b9-7e6077bd3405":{"id":"9410f265-0784-44ab-b7b9-7e6077bd3405","locked":true,"type":"onetomany","selected":false,"source":"2670a6c7-241a-4476-b477-dff938589643","sourcePort":"59b08cf4-7ccf-4ba4-8378-b2a2d9268298","target":"e0fc7e6e-d2b2-4078-9b8e-a617fd61612c","targetPort":"6f460414-25d6-42eb-99f2-08e6efa034dc","points":[{"id":"269695c1-3b9d-462e-ac70-b3c0fef09fcc","type":"point","x":-260.7615242148337,"y":407.8333092032037},{"id":"00ea30c4-7ef7-4109-ac55-a4d4ac02a365","type":"point","selected":false,"x":-222.69512194708366,"y":407.8333092032037},{"id":"95eb966b-b0c3-4ce7-a055-bd7691c645c7","type":"point","selected":false,"x":-222.69512194708366,"y":208.3177281499759},{"id":"72018f80-0666-4aae-ac1f-d264fe675dbd","type":"point","x":-119.23074870063317,"y":208.3177281499759}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"e0fc7e6e-d2b2-4078-9b8e-a617fd61612c","local_column_attnum":2,"referenced_table_uid":"2670a6c7-241a-4476-b477-dff938589643","referenced_column_attnum":1}},"aea0c319-654b-47b9-83b2-f381d5213ac5":{"id":"aea0c319-654b-47b9-83b2-f381d5213ac5","locked":true,"type":"onetomany","selected":false,"source":"245d534e-d739-426a-b6af-c9e057f17ac9","sourcePort":"48c7e5e5-57ac-40db-88d3-bc4945b02cbd","target":"1e8ee15a-3313-478c-b6d7-33d9fc017ae6","targetPort":"172cad49-fb80-43d7-a99a-f44baecdfe4c","points":[{"id":"218e17b1-2662-432d-8220-355f7a047c1e","type":"point","x":444.22757577925836,"y":827.8376689159454},{"id":"e3291c85-dcf8-4975-acd0-e1343db72b8c","type":"point","selected":false,"x":444.22757577925836,"y":493.9841969098851},{"id":"31105678-0038-439b-a37b-6ba5fce4d798","type":"point","selected":false,"x":339.22757577925836,"y":493.9841969098851},{"id":"9facc835-4337-40c5-8a3e-1f539a55aa30","type":"point","x":339.22757577925836,"y":493.32262778236236}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"1e8ee15a-3313-478c-b6d7-33d9fc017ae6","local_column_attnum":2,"referenced_table_uid":"245d534e-d739-426a-b6af-c9e057f17ac9","referenced_column_attnum":1}},"51f71421-ee5f-4d25-809f-f51ea5b6385c":{"id":"51f71421-ee5f-4d25-809f-f51ea5b6385c","locked":true,"type":"onetomany","selected":false,"source":"2670a6c7-241a-4476-b477-dff938589643","sourcePort":"59b08cf4-7ccf-4ba4-8378-b2a2d9268298","target":"1e8ee15a-3313-478c-b6d7-33d9fc017ae6","targetPort":"9f655738-9cef-4e5d-8672-65c3ed63e7d5","points":[{"id":"1dd39263-b40a-41bf-8df7-a99b6a5b5ed4","type":"point","x":-260.7615242148337,"y":407.8333092032037},{"id":"d24bfb7d-714a-4b5d-a602-537a30de0bbe","type":"point","selected":false,"x":-85.01595519820478,"y":407.8333092032037},{"id":"a4e20e09-4375-4398-9650-37e03dea330c","type":"point","selected":false,"x":-85.01595519820478,"y":518.806966710747},{"id":"b0c17e94-9131-4b12-9d91-5f3fc133f653","type":"point","x":105.75836634020516,"y":518.806966710747}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"1e8ee15a-3313-478c-b6d7-33d9fc017ae6","local_column_attnum":3,"referenced_table_uid":"2670a6c7-241a-4476-b477-dff938589643","referenced_column_attnum":1}},"8fdb3498-e3af-42a1-8a3f-6f1280b869ce":{"id":"8fdb3498-e3af-42a1-8a3f-6f1280b869ce","locked":true,"type":"onetomany","selected":false,"source":"245d534e-d739-426a-b6af-c9e057f17ac9","sourcePort":"48c7e5e5-57ac-40db-88d3-bc4945b02cbd","target":"8ac8f408-7ebf-4887-a30d-5af2703ee1fa","targetPort":"46cd0596-13a2-412b-8901-ae9b4a7e57b1","points":[{"id":"64231ca6-482e-4551-a75c-9f6d230817a3","type":"point","x":444.22757577925836,"y":827.8376689159454},{"id":"0180c8b2-7012-4f0f-9f5a-571b35742934","type":"point","selected":false,"x":537.7175067121088,"y":827.8376689159454},{"id":"cffd3774-5dc5-4772-9b87-c96949721d6f","type":"point","selected":false,"x":537.7175067121088,"y":1208.8065412020524},{"id":"285cac88-91e3-4eb7-b24a-8fd300bc6048","type":"point","x":444.22318393140995,"y":1208.8065412020524}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"8ac8f408-7ebf-4887-a30d-5af2703ee1fa","local_column_attnum":3,"referenced_table_uid":"245d534e-d739-426a-b6af-c9e057f17ac9","referenced_column_attnum":1}},"1b3cf1ce-9c57-4231-aee9-63362c3454ab":{"id":"1b3cf1ce-9c57-4231-aee9-63362c3454ab","locked":true,"type":"onetomany","selected":false,"source":"3e54e5c9-ea90-42e3-825a-64bb1a4a5e2a","sourcePort":"660a1f3b-1778-4f8a-9c0b-23b1d40d05b0","target":"8ac8f408-7ebf-4887-a30d-5af2703ee1fa","targetPort":"973ec24a-51fd-443d-8cbb-d4b97bad76f7","points":[{"id":"2aeee24f-2071-48a4-8959-6c0fdda35156","type":"point","x":84.22285563738387,"y":1322.8425513520506},{"id":"5423d035-c967-4b5d-8415-f0e93d35b400","type":"point","selected":false,"x":84.22285563738387,"y":1296.7596461071942},{"id":"d7a277b7-6ceb-4e20-82cc-68a806acc474","type":"point","selected":false,"x":210.7538369221047,"y":1296.7596461071942},{"id":"042e45f0-942b-4ada-a916-41698bf3e50a","type":"point","x":210.7538369221047,"y":1183.3222366662308}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"8ac8f408-7ebf-4887-a30d-5af2703ee1fa","local_column_attnum":2,"referenced_table_uid":"3e54e5c9-ea90-42e3-825a-64bb1a4a5e2a","referenced_column_attnum":1}},"ea2f64bb-6bc8-40e1-9084-dabdba732e61":{"id":"ea2f64bb-6bc8-40e1-9084-dabdba732e61","locked":true,"type":"onetomany","selected":false,"source":"245d534e-d739-426a-b6af-c9e057f17ac9","sourcePort":"48c7e5e5-57ac-40db-88d3-bc4945b02cbd","target":"0e5cd907-42c4-414a-bd1d-7b87110a4965","targetPort":"e4401709-e8f9-4b93-903f-0a80faca9293","points":[{"id":"1900d7cd-e57e-46c9-acfc-a4541056dd56","type":"point","x":444.22757577925836,"y":827.8376689159454},{"id":"c590dae1-c2dc-46b6-9488-6624b6828e96","type":"point","selected":false,"x":482.64584001255736,"y":827.8376689159454},{"id":"f4cb3342-9ab4-44b3-967e-bdc4598ff153","type":"point","selected":false,"x":482.64584001255736,"y":762.9881073269254},{"id":"b44e9b6a-e62e-4b18-8ca5-6309fa63c11c","type":"point","selected":false,"x":585.758977073312,"y":762.9881073269254},{"id":"715fe716-998b-472d-a080-2f4adbf18113","type":"point","x":585.758977073312,"y":763.3263296140212}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"0e5cd907-42c4-414a-bd1d-7b87110a4965","local_column_attnum":2,"referenced_table_uid":"245d534e-d739-426a-b6af-c9e057f17ac9","referenced_column_attnum":1}},"d5611fd7-772b-424c-b969-43aade3c3be6":{"id":"d5611fd7-772b-424c-b969-43aade3c3be6","locked":true,"type":"onetomany","selected":false,"source":"3e54e5c9-ea90-42e3-825a-64bb1a4a5e2a","sourcePort":"660a1f3b-1778-4f8a-9c0b-23b1d40d05b0","target":"0e5cd907-42c4-414a-bd1d-7b87110a4965","targetPort":"d574a2e3-c529-4416-bc84-f6c90ccd661c","points":[{"id":"a4d0b2cd-c55a-46df-81ca-e4fb864a4431","type":"point","x":84.22285563738387,"y":1322.8425513520506},{"id":"bcdb3803-77cf-4f69-aa25-21d6e74b0fa2","type":"point","selected":false,"x":84.22285563738387,"y":1404.7848384793915},{"id":"0381a79a-3f3c-48c3-b507-9c403e55c7af","type":"point","selected":false,"x":585.758977073312,"y":1404.7848384793915},{"id":"4bf9d98d-d844-48cb-87ce-a620def3a274","type":"point","x":585.758977073312,"y":788.8105997572802}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"0e5cd907-42c4-414a-bd1d-7b87110a4965","local_column_attnum":3,"referenced_table_uid":"3e54e5c9-ea90-42e3-825a-64bb1a4a5e2a","referenced_column_attnum":1}},"1e74ccae-264c-4821-87a0-c252027a55b8":{"id":"1e74ccae-264c-4821-87a0-c252027a55b8","locked":true,"type":"onetomany","selected":false,"source":"0e5cd907-42c4-414a-bd1d-7b87110a4965","sourcePort":"944dffe2-5d99-43e7-acde-8d2913530827","target":"be84765a-1aa3-4ecc-ab01-a349bc9a583f","targetPort":"e5cb67c4-ca6e-49f4-9c67-6d48779a5163","points":[{"id":"5ada48c1-f590-48f1-bf80-26f924afabab","type":"point","x":819.2281865123655,"y":737.8419906856366},{"id":"0bcc9099-6dd8-4f22-a41d-ee70be1847be","type":"point","x":819.2281865123655,"y":737.5704150040555},{"id":"a286bb93-87a5-4a34-a55b-0eff28cd2173","type":"point","selected":false,"x":849.0842376672657,"y":737.5704150040555},{"id":"2d7ed1ac-f468-445f-bcfc-be0db80bf012","type":"point","selected":false,"x":849.0842376672657,"y":767.8377067641595},{"id":"be6f8ea6-6415-4924-8ec5-678a003da8fd","type":"point","x":885.7588000492678,"y":767.8377067641595}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"be84765a-1aa3-4ecc-ab01-a349bc9a583f","local_column_attnum":1,"referenced_table_uid":"0e5cd907-42c4-414a-bd1d-7b87110a4965","referenced_column_attnum":1}},"e435affc-8b0c-4167-9eb6-00f2920e8e4d":{"id":"e435affc-8b0c-4167-9eb6-00f2920e8e4d","locked":true,"type":"onetomany","selected":false,"source":"ee43e8d6-c6af-4509-a299-785e781394b0","sourcePort":"6bd969bd-054f-4688-8409-e9a00cd76b56","target":"be84765a-1aa3-4ecc-ab01-a349bc9a583f","targetPort":"8d93c8da-d8b5-42a9-958d-44f0ad58ccaf","points":[{"id":"5910013e-1a7b-4586-97ad-096a87d77b12","type":"point","x":849.2279700345284,"y":1007.8432150799536},{"id":"60ad7fba-7c14-40ee-a9a2-ffcaed0a2d75","type":"point","selected":false,"x":870.2656479363241,"y":1007.8432150799536},{"id":"dbfd98af-e521-4d27-a0b9-a3cff48a03d2","type":"point","selected":false,"x":870.2656479363241,"y":793.3220456925442},{"id":"1ffe45b3-b52b-49c1-8405-4ef59750ee02","type":"point","x":885.7588000492678,"y":793.3220456925442}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"be84765a-1aa3-4ecc-ab01-a349bc9a583f","local_column_attnum":2,"referenced_table_uid":"ee43e8d6-c6af-4509-a299-785e781394b0","referenced_column_attnum":1}},"7ada3c0f-70af-45c3-b057-db4407027ab7":{"id":"7ada3c0f-70af-45c3-b057-db4407027ab7","locked":true,"type":"onetomany","selected":false,"source":"245d534e-d739-426a-b6af-c9e057f17ac9","sourcePort":"8d9c8bbb-8dd6-4017-97f3-89b097463e69","target":"5ab646a7-7d7d-4a7f-bab3-fe39ac7b341e","targetPort":"23654d0d-7881-42df-bbeb-07c0a990161d","points":[{"id":"644d228f-1332-4218-9b60-e51c4ab7904d","type":"point","x":210.75836634020516,"y":827.8376689159454},{"id":"e09b0a94-c3e2-4edd-a72c-e0ff242fc064","type":"point","selected":false,"x":101.38045516950815,"y":827.8376689159454},{"id":"0b8d410b-c1e9-4e75-a465-6064c44145d5","type":"point","selected":false,"x":101.38045516950815,"y":688.3229757939575},{"id":"127109f2-9e19-41d5-83f0-c8f66c4faf17","type":"point","x":54.22840299020254,"y":688.3229757939575}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"5ab646a7-7d7d-4a7f-bab3-fe39ac7b341e","local_column_attnum":2,"referenced_table_uid":"245d534e-d739-426a-b6af-c9e057f17ac9","referenced_column_attnum":1}},"04a77a6b-067a-4a7a-89bd-4d88e6fa747e":{"id":"04a77a6b-067a-4a7a-89bd-4d88e6fa747e","locked":true,"type":"onetomany","source":"d7fea907-7d2b-45e7-bb64-52c7bab78708","sourcePort":"ae3649e7-486a-49ab-a8a9-f8562d162724","target":"2670a6c7-241a-4476-b477-dff938589643","targetPort":"758a0def-2cba-4ec1-9d73-821bb2f0301c","points":[{"id":"8a360a09-05ad-4c96-b6fc-bb5b9d50d6ec","type":"point","x":-665.768121172787,"y":437.85273759789186},{"id":"01389677-189d-410e-8b29-8e91adcc1348","type":"point","x":-665.768121172787,"y":618.6601513668634},{"id":"424895be-e399-48ab-b324-adf70c36bb38","type":"point","x":-494.23286996495284,"y":618.6601513668634}],"labels":[],"width":1,"color":"gray","curvyness":50,"selectedColor":"rgb(0,192,255)","data":{"local_table_uid":"2670a6c7-241a-4476-b477-dff938589643","local_column_attnum":7,"referenced_table_uid":"d7fea907-7d2b-45e7-bb64-52c7bab78708","referenced_column_attnum":1}}}},{"id":"5a3ad6c2-6c84-4e7d-9ced-4b721dd67c2f","type":"diagram-nodes","isSvg":false,"transformed":true,"models":{"b643626e-476d-4435-a26c-0cef2d19e68e":{"id":"b643626e-476d-4435-a26c-0cef2d19e68e","type":"table","selected":false,"x":-510,"y":780,"ports":[{"id":"51f26640-08fc-4115-ae0e-29d4cd06c5f5","type":"onetomany","x":-509.24583107830586,"y":923.8124406553416,"name":"coll-port-3-left","alignment":"left","parentNode":"b643626e-476d-4435-a26c-0cef2d19e68e","links":[]},{"id":"86e93ce4-d004-472d-b6b3-686320cc1701","type":"onetomany","x":-335.77655285412675,"y":923.8124406553416,"name":"coll-port-3-right","alignment":"right","parentNode":"b643626e-476d-4435-a26c-0cef2d19e68e","links":["fb95efcd-62df-4592-a11c-be2af414c9b0"]},{"id":"2db39f7a-adbc-483f-970c-3267715dc11c","type":"onetomany","x":-509.24583107830586,"y":898.3281017269567,"name":"coll-port-2-left","alignment":"left","parentNode":"b643626e-476d-4435-a26c-0cef2d19e68e","links":[]},{"id":"25dd663b-8006-4c53-86a6-807e2dba5e8e","type":"onetomany","x":-335.77655285412675,"y":898.3281017269567,"name":"coll-port-2-right","alignment":"right","parentNode":"b643626e-476d-4435-a26c-0cef2d19e68e","links":["4f63d7ac-e4e0-40cc-9d0a-51f3d05c45c9"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["51f26640-08fc-4115-ae0e-29d4cd06c5f5","86e93ce4-d004-472d-b6b3-686320cc1701","2db39f7a-adbc-483f-970c-3267715dc11c","25dd663b-8006-4c53-86a6-807e2dba5e8e"],"otherInfo":{"data":{"columns":[{"name":"buchung_id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"","typname":"serial","displaytypname":"serial","cltype":"serial","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"buchungen","is_view_only":false,"attcompression":null,"seqrelid":135078,"seqtypid":23,"seqstart":"1","seqincrement":"1","seqmax":"2147483647","seqmin":"1","seqcache":"1","seqcycle":false,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","serial","smallint"]},{"name":"mitglied_id","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"buchungen","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","serial","smallint"]},{"name":"kurs_id","atttypid":23,"attlen":null,"attnum":3,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"buchungen","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","serial","smallint"]},{"name":"buchungsdatum","atttypid":1082,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"date","displaytypname":"date","cltype":"date","inheritedfrom":null,"inheritedid":null,"elemoid":1082,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"buchungen","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","timestamp with time zone","timestamp without time zone"]},{"name":"status","atttypid":1043,"attlen":"50","attnum":5,"attndims":0,"atttypmod":54,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":"'gebucht'::character varying","typname":"character varying","displaytypname":"character varying(50)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"buchungen","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]}],"name":"buchungen","schema":"student200","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":135084,"name":"buchungen_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"buchung_id"}],"include":[]}],"foreign_key":[{"name":"buchungen_kurs_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"c","confmatchtype":false,"conkey":[3],"confkey":[1],"confrelid":135067,"fknsp":"student200","fktab":"buchungen","refnspoid":134492,"refnsp":"student200","reftab":"kurse","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"kurs_id","references":"e404792f-1d61-45d7-a306-6f223cc02250","referenced":"kurs_id","references_table_name":"student200.kurse"}],"remote_schema":"student200","remote_table":"kurse","coveringindex":null,"autoindex":false,"hasindex":false},{"name":"buchungen_mitglied_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"c","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":135036,"fknsp":"student200","fktab":"buchungen","refnspoid":134492,"refnsp":"student200","reftab":"mitglieder","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"mitglied_id","references":"245d534e-d739-426a-b6af-c9e057f17ac9","referenced":"mitglied_id","references_table_name":"student200.mitglieder"}],"remote_schema":"student200","remote_table":"mitglieder","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"e404792f-1d61-45d7-a306-6f223cc02250":{"id":"e404792f-1d61-45d7-a306-6f223cc02250","type":"table","selected":false,"x":-465,"y":1095,"ports":[{"id":"bd8f3c19-4713-4760-bcc3-6f42efcece67","type":"onetomany","x":-464.2473364262896,"y":1187.8358659609348,"name":"coll-port-1-left","alignment":"left","parentNode":"e404792f-1d61-45d7-a306-6f223cc02250","links":[]},{"id":"b3afbb9d-e380-4da1-84ad-6394e05acd05","type":"onetomany","x":-290.7781613797997,"y":1187.8358659609348,"name":"coll-port-1-right","alignment":"right","parentNode":"e404792f-1d61-45d7-a306-6f223cc02250","links":["fb95efcd-62df-4592-a11c-be2af414c9b0"]},{"id":"21d21b44-d58d-4a56-a380-2a1467bf14bd","type":"onetomany","x":-464.2473364262896,"y":1258.107851317328,"name":"coll-port-3-left","alignment":"left","parentNode":"e404792f-1d61-45d7-a306-6f223cc02250","links":[]},{"id":"fbaa1f82-3efb-432d-8cbe-8dd7508ac228","type":"onetomany","x":-290.7781613797997,"y":1258.107851317328,"name":"coll-port-3-right","alignment":"right","parentNode":"e404792f-1d61-45d7-a306-6f223cc02250","links":["55cc165d-569a-419b-824c-cb6676b59b61"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["bd8f3c19-4713-4760-bcc3-6f42efcece67","b3afbb9d-e380-4da1-84ad-6394e05acd05","21d21b44-d58d-4a56-a380-2a1467bf14bd","fbaa1f82-3efb-432d-8cbe-8dd7508ac228"],"otherInfo":{"data":{"columns":[{"name":"kurs_id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"","typname":"serial","displaytypname":"serial","cltype":"serial","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"kurse","is_view_only":false,"attcompression":null,"seqrelid":135066,"seqtypid":23,"seqstart":"1","seqincrement":"1","seqmax":"2147483647","seqmin":"1","seqcache":"1","seqcycle":false,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","serial","smallint"]},{"name":"name","atttypid":1043,"attlen":"100","attnum":2,"attndims":0,"atttypmod":104,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(100)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"kurse","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"trainer_id","atttypid":23,"attlen":null,"attnum":3,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"kurse","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","serial","smallint"]},{"name":"datum","atttypid":1082,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"date","displaytypname":"date","cltype":"date","inheritedfrom":null,"inheritedid":null,"elemoid":1082,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"kurse","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","timestamp with time zone","timestamp without time zone"]},{"name":"start_zeit","atttypid":1083,"attlen":null,"attnum":5,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"time without time zone","displaytypname":"time without time zone","cltype":"time without time zone","inheritedfrom":null,"inheritedid":null,"elemoid":1083,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"kurse","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["interval","time with time zone","time without time zone","time without time zone"]},{"name":"end_zeit","atttypid":1083,"attlen":null,"attnum":6,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"time without time zone","displaytypname":"time without time zone","cltype":"time without time zone","inheritedfrom":null,"inheritedid":null,"elemoid":1083,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"kurse","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["interval","time with time zone","time without time zone","time without time zone","time without time zone"]}],"name":"kurse","schema":"student200","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":135071,"name":"kurse_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"kurs_id"}],"include":[]}],"foreign_key":[{"name":"kurse_trainer_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"n","confmatchtype":false,"conkey":[3],"confkey":[1],"confrelid":135045,"fknsp":"student200","fktab":"kurse","refnspoid":134492,"refnsp":"student200","reftab":"trainer","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"trainer_id","references":"3e54e5c9-ea90-42e3-825a-64bb1a4a5e2a","referenced":"trainer_id","references_table_name":"student200.trainer"}],"remote_schema":"student200","remote_table":"trainer","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"e0fc7e6e-d2b2-4078-9b8e-a617fd61612c":{"id":"e0fc7e6e-d2b2-4078-9b8e-a617fd61612c","type":"table","selected":false,"x":-90,"y":90,"ports":[{"id":"6f460414-25d6-42eb-99f2-08e6efa034dc","type":"onetomany","x":-89.23074870063317,"y":208.3177281499759,"name":"coll-port-2-left","alignment":"left","parentNode":"e0fc7e6e-d2b2-4078-9b8e-a617fd61612c","links":["9410f265-0784-44ab-b7b9-7e6077bd3405"]},{"id":"b8143c45-01ef-486c-adbf-80b5e2cce8a9","type":"onetomany","x":84.23847578516632,"y":208.3177281499759,"name":"coll-port-2-right","alignment":"right","parentNode":"e0fc7e6e-d2b2-4078-9b8e-a617fd61612c","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["6f460414-25d6-42eb-99f2-08e6efa034dc","b8143c45-01ef-486c-adbf-80b5e2cce8a9"],"otherInfo":{"data":{"columns":[{"name":"maschinen_id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"","typname":"serial","displaytypname":"serial","cltype":"serial","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"maschinen","is_view_only":false,"attcompression":null,"seqrelid":135166,"seqtypid":23,"seqstart":"1","seqincrement":"1","seqmax":"2147483647","seqmin":"1","seqcache":"1","seqcycle":false,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","serial","smallint"]},{"name":"studio_id","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"maschinen","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","serial","smallint"]},{"name":"maschinen_name","atttypid":1043,"attlen":"100","attnum":3,"attndims":0,"atttypmod":104,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(100)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"maschinen","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"typ","atttypid":1043,"attlen":"50","attnum":4,"attndims":0,"atttypmod":54,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(50)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"maschinen","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"wartungsdatum","atttypid":1082,"attlen":null,"attnum":5,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"date","displaytypname":"date","cltype":"date","inheritedfrom":null,"inheritedid":null,"elemoid":1082,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"maschinen","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","timestamp with time zone","timestamp without time zone"]}],"name":"maschinen","schema":"student200","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":135171,"name":"maschinen_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"maschinen_id"}],"include":[]}],"foreign_key":[{"name":"maschinen_studio_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"c","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":135054,"fknsp":"student200","fktab":"maschinen","refnspoid":134492,"refnsp":"student200","reftab":"studio","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"studio_id","references":"2670a6c7-241a-4476-b477-dff938589643","referenced":"studio_id","references_table_name":"studio"}],"remote_schema":"student200","remote_table":"studio","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"245d534e-d739-426a-b6af-c9e057f17ac9":{"id":"245d534e-d739-426a-b6af-c9e057f17ac9","type":"table","selected":false,"x":240,"y":735,"ports":[{"id":"8d9c8bbb-8dd6-4017-97f3-89b097463e69","type":"onetomany","x":240.75836634020516,"y":827.8376689159454,"name":"coll-port-1-left","alignment":"left","parentNode":"245d534e-d739-426a-b6af-c9e057f17ac9","links":["4f63d7ac-e4e0-40cc-9d0a-51f3d05c45c9","7ada3c0f-70af-45c3-b057-db4407027ab7"]},{"id":"48c7e5e5-57ac-40db-88d3-bc4945b02cbd","type":"onetomany","x":414.22757577925836,"y":827.8376689159454,"name":"coll-port-1-right","alignment":"right","parentNode":"245d534e-d739-426a-b6af-c9e057f17ac9","links":["8fdb3498-e3af-42a1-8a3f-6f1280b869ce","ea2f64bb-6bc8-40e1-9084-dabdba732e61","aea0c319-654b-47b9-83b2-f381d5213ac5"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["8d9c8bbb-8dd6-4017-97f3-89b097463e69","48c7e5e5-57ac-40db-88d3-bc4945b02cbd"],"otherInfo":{"data":{"columns":[{"name":"mitglied_id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"","typname":"serial","displaytypname":"serial","cltype":"serial","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"mitglieder","is_view_only":false,"attcompression":null,"seqrelid":135035,"seqtypid":23,"seqstart":"1","seqincrement":"1","seqmax":"2147483647","seqmin":"1","seqcache":"1","seqcycle":false,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","serial","smallint"]},{"name":"vorname","atttypid":1043,"attlen":"100","attnum":2,"attndims":0,"atttypmod":104,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(100)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"mitglieder","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"nachname","atttypid":1043,"attlen":"100","attnum":3,"attndims":0,"atttypmod":104,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(100)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"mitglieder","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"geburtsdatum","atttypid":1082,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"date","displaytypname":"date","cltype":"date","inheritedfrom":null,"inheritedid":null,"elemoid":1082,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"mitglieder","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","timestamp with time zone","timestamp without time zone"]},{"name":"email","atttypid":1043,"attlen":"200","attnum":5,"attndims":0,"atttypmod":204,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(200)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"mitglieder","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]}],"name":"mitglieder","schema":"student200","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":135040,"name":"mitglieder_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"mitglied_id"}],"include":[]}],"unique_constraint":[{"oid":135042,"name":"mitglieder_email_key","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"email"}],"include":[]}],"foreign_key":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"1e8ee15a-3313-478c-b6d7-33d9fc017ae6":{"id":"1e8ee15a-3313-478c-b6d7-33d9fc017ae6","type":"table","selected":false,"x":135,"y":375,"ports":[{"id":"c908a763-0a2e-435d-9b45-69957f1624bf","type":"onetomany","x":135.75836634020516,"y":493.32262778236236,"name":"coll-port-2-left","alignment":"left","parentNode":"1e8ee15a-3313-478c-b6d7-33d9fc017ae6","links":[]},{"id":"172cad49-fb80-43d7-a99a-f44baecdfe4c","type":"onetomany","x":309.22757577925836,"y":493.32262778236236,"name":"coll-port-2-right","alignment":"right","parentNode":"1e8ee15a-3313-478c-b6d7-33d9fc017ae6","links":["aea0c319-654b-47b9-83b2-f381d5213ac5"]},{"id":"9f655738-9cef-4e5d-8672-65c3ed63e7d5","type":"onetomany","x":135.75836634020516,"y":518.806966710747,"name":"coll-port-3-left","alignment":"left","parentNode":"1e8ee15a-3313-478c-b6d7-33d9fc017ae6","links":["51f71421-ee5f-4d25-809f-f51ea5b6385c"]},{"id":"a886b38f-8c7b-4ad2-b63b-d0051cee4a40","type":"onetomany","x":309.22757577925836,"y":518.806966710747,"name":"coll-port-3-right","alignment":"right","parentNode":"1e8ee15a-3313-478c-b6d7-33d9fc017ae6","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["c908a763-0a2e-435d-9b45-69957f1624bf","172cad49-fb80-43d7-a99a-f44baecdfe4c","9f655738-9cef-4e5d-8672-65c3ed63e7d5","a886b38f-8c7b-4ad2-b63b-d0051cee4a40"],"otherInfo":{"data":{"columns":[{"name":"mitgliedschaft_id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"","typname":"serial","displaytypname":"serial","cltype":"serial","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"mitgliedschaften","is_view_only":false,"attcompression":null,"seqrelid":135137,"seqtypid":23,"seqstart":"1","seqincrement":"1","seqmax":"2147483647","seqmin":"1","seqcache":"1","seqcycle":false,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","serial","smallint"],"cid":"c18"},{"name":"mitglied_id","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"mitgliedschaften","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","serial","smallint"],"cid":"c19"},{"name":"studio_id","atttypid":23,"attlen":null,"attnum":3,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"mitgliedschaften","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","serial","smallint"],"cid":"c20"},{"name":"start_datum","atttypid":1082,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"date","displaytypname":"date","cltype":"date","inheritedfrom":null,"inheritedid":null,"elemoid":1082,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"mitgliedschaften","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","timestamp with time zone","timestamp without time zone"],"cid":"c21"},{"name":"end_datum","atttypid":1082,"attlen":null,"attnum":5,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"date","displaytypname":"date","cltype":"date","inheritedfrom":null,"inheritedid":null,"elemoid":1082,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"mitgliedschaften","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","date","timestamp with time zone","timestamp without time zone"],"cid":"c22"},{"name":"mitgliedschafts_typ","atttypid":1043,"attlen":"50","attnum":6,"attndims":0,"atttypmod":54,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(50)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"mitgliedschaften","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"],"cid":"c23"}],"name":"mitgliedschaften","schema":"student200","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":135142,"name":"mitgliedschaften_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"mitgliedschaft_id","cid":"c13"}],"include":[],"cid":"c12"}],"foreign_key":[{"name":"mitgliedschaften_mitglied_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"c","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":135036,"fknsp":"student200","fktab":"mitgliedschaften","refnspoid":134492,"refnsp":"student200","reftab":"mitglieder","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"mitglied_id","references":"245d534e-d739-426a-b6af-c9e057f17ac9","referenced":"mitglied_id","references_table_name":"student200.mitglieder","cid":"c15"}],"remote_schema":"student200","remote_table":"mitglieder","coveringindex":null,"autoindex":false,"hasindex":false,"cid":"c14"},{"name":"mitgliedschaften_studio_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"c","confmatchtype":false,"conkey":[3],"confkey":[1],"confrelid":135054,"fknsp":"student200","fktab":"mitgliedschaften","refnspoid":134492,"refnsp":"student200","reftab":"studio","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"studio_id","references":"2670a6c7-241a-4476-b477-dff938589643","referenced":"studio_id","references_table_name":"studio","cid":"c17"}],"remote_schema":"student200","remote_table":"studio","coveringindex":null,"autoindex":false,"hasindex":false,"cid":"c16"}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"2670a6c7-241a-4476-b477-dff938589643":{"id":"2670a6c7-241a-4476-b477-dff938589643","type":"table","selected":false,"x":-465,"y":315,"ports":[{"id":"7332fb91-89f5-4ace-928d-b73892570548","type":"onetomany","x":-464.23074870063317,"y":407.8333092032037,"name":"coll-port-1-left","alignment":"left","parentNode":"2670a6c7-241a-4476-b477-dff938589643","links":[]},{"id":"59b08cf4-7ccf-4ba4-8378-b2a2d9268298","type":"onetomany","x":-290.7615242148337,"y":407.8333092032037,"name":"coll-port-1-right","alignment":"right","parentNode":"2670a6c7-241a-4476-b477-dff938589643","links":["9410f265-0784-44ab-b7b9-7e6077bd3405","51f71421-ee5f-4d25-809f-f51ea5b6385c"]},{"id":"758a0def-2cba-4ec1-9d73-821bb2f0301c","type":"onetomany","x":-464.23286996495284,"y":618.6601513668634,"name":"coll-port-7-left","alignment":"left","parentNode":"2670a6c7-241a-4476-b477-dff938589643","links":["04a77a6b-067a-4a7a-89bd-4d88e6fa747e"]},{"id":"4c26ddb8-ebd1-40d7-ba82-2c9b28a28898","type":"onetomany","x":-290.76363813736117,"y":618.6601513668634,"name":"coll-port-7-right","alignment":"right","parentNode":"2670a6c7-241a-4476-b477-dff938589643","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["7332fb91-89f5-4ace-928d-b73892570548","59b08cf4-7ccf-4ba4-8378-b2a2d9268298","758a0def-2cba-4ec1-9d73-821bb2f0301c","4c26ddb8-ebd1-40d7-ba82-2c9b28a28898"],"otherInfo":{"data":{"name":"studio","description":null,"relpersistence":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"coll_inherits":[],"hastoasttable":true,"toast_autovacuum_enabled":"x","autovacuum_enabled":"x","primary_key":[{"oid":135058,"name":"studio_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"studio_id","cid":"c30"}],"include":[],"cid":"c29"}],"foreign_key":[{"name":"cityFK","confmatchtype":false,"autoindex":false,"coveringindex":"","columns":[{"local_column":"stadt","referenced":"name","references_table_name":"city","references":"d7fea907-7d2b-45e7-bb64-52c7bab78708","cid":"c32"},{"local_column":"landescode","referenced":"country","references":"d7fea907-7d2b-45e7-bb64-52c7bab78708","references_table_name":"(public) city","cid":"c89"},{"local_column":"provinz","referenced":"province","references":"d7fea907-7d2b-45e7-bb64-52c7bab78708","references_table_name":"(public) city","cid":"c97"}],"confupdtype":"a","confdeltype":"a"}],"partition_keys":[],"partitions":[],"partition_type":"range","is_partitioned":false,"columns":[{"name":"studio_id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"","typname":"serial","displaytypname":"serial","cltype":"serial","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"studio","is_view_only":false,"attcompression":null,"seqrelid":135053,"seqtypid":23,"seqstart":"1","seqincrement":"1","seqmax":"2147483647","seqmin":"1","seqcache":"1","seqcycle":false,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","serial","smallint"]},{"name":"name","atttypid":1043,"attlen":"100","attnum":2,"attndims":0,"atttypmod":104,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(100)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"studio","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"strasse","atttypid":1043,"attlen":"100","attnum":3,"attndims":0,"atttypmod":104,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(100)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"studio","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"hausnummer","atttypid":23,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"studio","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","serial","smallint"]},{"name":"plz","atttypid":1043,"attlen":"5","attnum":5,"attndims":0,"atttypmod":9,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(5)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"studio","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"oeffnungszeiten","atttypid":1043,"attlen":"100","attnum":6,"attndims":0,"atttypmod":104,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(100)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"studio","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"stadt","atttypid":1043,"attlen":"50","attnum":7,"attndims":0,"atttypmod":54,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(50)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"studio","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"landescode","atttypid":1043,"attlen":"4","attnum":8,"attndims":0,"atttypmod":8,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(4)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"studio","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","character varying","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"provinz","atttypid":1043,"attlen":"50","attnum":9,"attndims":0,"atttypmod":54,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(50)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"studio","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","character varying","character varying","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]}],"schema":"student200","rlspolicy":false,"forcerlspolicy":false,"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"3e54e5c9-ea90-42e3-825a-64bb1a4a5e2a":{"id":"3e54e5c9-ea90-42e3-825a-64bb1a4a5e2a","type":"table","selected":false,"x":-120,"y":1230,"ports":[{"id":"3fc727d5-0910-4408-a76f-561fb64f8e56","type":"onetomany","x":-119.2463538016691,"y":1322.8425513520506,"name":"coll-port-1-left","alignment":"left","parentNode":"3e54e5c9-ea90-42e3-825a-64bb1a4a5e2a","links":["55cc165d-569a-419b-824c-cb6676b59b61"]},{"id":"660a1f3b-1778-4f8a-9c0b-23b1d40d05b0","type":"onetomany","x":54.22285563738387,"y":1322.8425513520506,"name":"coll-port-1-right","alignment":"right","parentNode":"3e54e5c9-ea90-42e3-825a-64bb1a4a5e2a","links":["1b3cf1ce-9c57-4231-aee9-63362c3454ab","d5611fd7-772b-424c-b969-43aade3c3be6"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["3fc727d5-0910-4408-a76f-561fb64f8e56","660a1f3b-1778-4f8a-9c0b-23b1d40d05b0"],"otherInfo":{"data":{"columns":[{"name":"trainer_id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"","typname":"serial","displaytypname":"serial","cltype":"serial","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"trainer","is_view_only":false,"attcompression":null,"seqrelid":135044,"seqtypid":23,"seqstart":"1","seqincrement":"1","seqmax":"2147483647","seqmin":"1","seqcache":"1","seqcycle":false,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","serial","smallint"]},{"name":"vorname","atttypid":1043,"attlen":"100","attnum":2,"attndims":0,"atttypmod":104,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(100)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"trainer","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"nachname","atttypid":1043,"attlen":"100","attnum":3,"attndims":0,"atttypmod":104,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(100)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"trainer","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"email","atttypid":1043,"attlen":"200","attnum":4,"attndims":0,"atttypmod":204,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(200)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"trainer","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]}],"name":"trainer","schema":"student200","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":135049,"name":"trainer_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"trainer_id"}],"include":[]}],"unique_constraint":[{"oid":135051,"name":"trainer_email_key","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"email"}],"include":[]}],"foreign_key":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"8ac8f408-7ebf-4887-a30d-5af2703ee1fa":{"id":"8ac8f408-7ebf-4887-a30d-5af2703ee1fa","type":"table","selected":false,"x":240,"y":1065,"ports":[{"id":"ae47026b-0b22-4d55-9632-d135bb6517cf","type":"onetomany","x":240.7538369221047,"y":1208.8065412020524,"name":"coll-port-3-left","alignment":"left","parentNode":"8ac8f408-7ebf-4887-a30d-5af2703ee1fa","links":[]},{"id":"46cd0596-13a2-412b-8901-ae9b4a7e57b1","type":"onetomany","x":414.22318393140995,"y":1208.8065412020524,"name":"coll-port-3-right","alignment":"right","parentNode":"8ac8f408-7ebf-4887-a30d-5af2703ee1fa","links":["8fdb3498-e3af-42a1-8a3f-6f1280b869ce"]},{"id":"973ec24a-51fd-443d-8cbb-d4b97bad76f7","type":"onetomany","x":240.7538369221047,"y":1183.3222366662308,"name":"coll-port-2-left","alignment":"left","parentNode":"8ac8f408-7ebf-4887-a30d-5af2703ee1fa","links":["1b3cf1ce-9c57-4231-aee9-63362c3454ab"]},{"id":"820afbc3-074b-4d3f-8e41-9934f18aa934","type":"onetomany","x":414.22318393140995,"y":1183.3222366662308,"name":"coll-port-2-right","alignment":"right","parentNode":"8ac8f408-7ebf-4887-a30d-5af2703ee1fa","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["ae47026b-0b22-4d55-9632-d135bb6517cf","46cd0596-13a2-412b-8901-ae9b4a7e57b1","973ec24a-51fd-443d-8cbb-d4b97bad76f7","820afbc3-074b-4d3f-8e41-9934f18aa934"],"otherInfo":{"data":{"columns":[{"name":"bewertung_id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"","typname":"serial","displaytypname":"serial","cltype":"serial","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"trainer_bewertungen","is_view_only":false,"attcompression":null,"seqrelid":135178,"seqtypid":23,"seqstart":"1","seqincrement":"1","seqmax":"2147483647","seqmin":"1","seqcache":"1","seqcycle":false,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","serial","smallint"]},{"name":"trainer_id","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"trainer_bewertungen","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","serial","smallint"]},{"name":"mitglied_id","atttypid":23,"attlen":null,"attnum":3,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"trainer_bewertungen","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","serial","smallint"]},{"name":"bewertung","atttypid":23,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"trainer_bewertungen","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","serial","smallint"]},{"name":"feedback","atttypid":25,"attlen":null,"attnum":5,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"text","displaytypname":"text","cltype":"text","inheritedfrom":null,"inheritedid":null,"elemoid":25,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"trainer_bewertungen","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","name","regclass","text"]},{"name":"bewertungsdatum","atttypid":1082,"attlen":null,"attnum":6,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"date","displaytypname":"date","cltype":"date","inheritedfrom":null,"inheritedid":null,"elemoid":1082,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"trainer_bewertungen","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","timestamp with time zone","timestamp without time zone"]}],"name":"trainer_bewertungen","schema":"student200","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":135186,"name":"trainer_bewertungen_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"bewertung_id"}],"include":[]}],"foreign_key":[{"name":"trainer_bewertungen_mitglied_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"c","confmatchtype":false,"conkey":[3],"confkey":[1],"confrelid":135036,"fknsp":"student200","fktab":"trainer_bewertungen","refnspoid":134492,"refnsp":"student200","reftab":"mitglieder","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"mitglied_id","references":"245d534e-d739-426a-b6af-c9e057f17ac9","referenced":"mitglied_id","references_table_name":"student200.mitglieder"}],"remote_schema":"student200","remote_table":"mitglieder","coveringindex":null,"autoindex":false,"hasindex":false},{"name":"trainer_bewertungen_trainer_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"c","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":135045,"fknsp":"student200","fktab":"trainer_bewertungen","refnspoid":134492,"refnsp":"student200","reftab":"trainer","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"trainer_id","references":"3e54e5c9-ea90-42e3-825a-64bb1a4a5e2a","referenced":"trainer_id","references_table_name":"student200.trainer"}],"remote_schema":"student200","remote_table":"trainer","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"0e5cd907-42c4-414a-bd1d-7b87110a4965":{"id":"0e5cd907-42c4-414a-bd1d-7b87110a4965","type":"table","selected":false,"x":615,"y":645,"ports":[{"id":"e4401709-e8f9-4b93-903f-0a80faca9293","type":"onetomany","x":615.758977073312,"y":763.3263296140212,"name":"coll-port-2-left","alignment":"left","parentNode":"0e5cd907-42c4-414a-bd1d-7b87110a4965","links":["ea2f64bb-6bc8-40e1-9084-dabdba732e61"]},{"id":"a51ea778-9979-4bab-a933-653917170149","type":"onetomany","x":789.2281865123655,"y":763.3263296140212,"name":"coll-port-2-right","alignment":"right","parentNode":"0e5cd907-42c4-414a-bd1d-7b87110a4965","links":[]},{"id":"d574a2e3-c529-4416-bc84-f6c90ccd661c","type":"onetomany","x":615.758977073312,"y":788.8105997572802,"name":"coll-port-3-left","alignment":"left","parentNode":"0e5cd907-42c4-414a-bd1d-7b87110a4965","links":["d5611fd7-772b-424c-b969-43aade3c3be6"]},{"id":"f32176d3-bd5a-48e3-a75a-0a4bd996dc6a","type":"onetomany","x":789.2281865123655,"y":788.8105997572802,"name":"coll-port-3-right","alignment":"right","parentNode":"0e5cd907-42c4-414a-bd1d-7b87110a4965","links":[]},{"id":"04558ce8-ab9e-42f3-921a-30e94d06d9b5","type":"onetomany","x":615.758977073312,"y":737.8419906856366,"name":"coll-port-1-left","alignment":"left","parentNode":"0e5cd907-42c4-414a-bd1d-7b87110a4965","links":[]},{"id":"944dffe2-5d99-43e7-acde-8d2913530827","type":"onetomany","x":789.2281865123655,"y":737.8419906856366,"name":"coll-port-1-right","alignment":"right","parentNode":"0e5cd907-42c4-414a-bd1d-7b87110a4965","links":["1e74ccae-264c-4821-87a0-c252027a55b8"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["e4401709-e8f9-4b93-903f-0a80faca9293","a51ea778-9979-4bab-a933-653917170149","d574a2e3-c529-4416-bc84-f6c90ccd661c","f32176d3-bd5a-48e3-a75a-0a4bd996dc6a","04558ce8-ab9e-42f3-921a-30e94d06d9b5","944dffe2-5d99-43e7-acde-8d2913530827"],"otherInfo":{"data":{"columns":[{"name":"plan_id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"","typname":"serial","displaytypname":"serial","cltype":"serial","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"trainingsplaene","is_view_only":false,"attcompression":null,"seqrelid":135096,"seqtypid":23,"seqstart":"1","seqincrement":"1","seqmax":"2147483647","seqmin":"1","seqcache":"1","seqcycle":false,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","serial","smallint"]},{"name":"mitglied_id","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"trainingsplaene","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","serial","smallint"]},{"name":"trainer_id","atttypid":23,"attlen":null,"attnum":3,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"trainingsplaene","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","serial","smallint"]},{"name":"start_datum","atttypid":1082,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"date","displaytypname":"date","cltype":"date","inheritedfrom":null,"inheritedid":null,"elemoid":1082,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"trainingsplaene","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","timestamp with time zone","timestamp without time zone"]},{"name":"end_datum","atttypid":1082,"attlen":null,"attnum":5,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"date","displaytypname":"date","cltype":"date","inheritedfrom":null,"inheritedid":null,"elemoid":1082,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"trainingsplaene","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","date","timestamp with time zone","timestamp without time zone"]}],"name":"trainingsplaene","schema":"student200","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":135101,"name":"trainingsplaene_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"plan_id"}],"include":[]}],"foreign_key":[{"name":"trainingsplaene_mitglied_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"c","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":135036,"fknsp":"student200","fktab":"trainingsplaene","refnspoid":134492,"refnsp":"student200","reftab":"mitglieder","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"mitglied_id","references":"245d534e-d739-426a-b6af-c9e057f17ac9","referenced":"mitglied_id","references_table_name":"student200.mitglieder"}],"remote_schema":"student200","remote_table":"mitglieder","coveringindex":null,"autoindex":false,"hasindex":false},{"name":"trainingsplaene_trainer_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"n","confmatchtype":false,"conkey":[3],"confkey":[1],"confrelid":135045,"fknsp":"student200","fktab":"trainingsplaene","refnspoid":134492,"refnsp":"student200","reftab":"trainer","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"trainer_id","references":"3e54e5c9-ea90-42e3-825a-64bb1a4a5e2a","referenced":"trainer_id","references_table_name":"student200.trainer"}],"remote_schema":"student200","remote_table":"trainer","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"be84765a-1aa3-4ecc-ab01-a349bc9a583f":{"id":"be84765a-1aa3-4ecc-ab01-a349bc9a583f","type":"table","selected":false,"x":915,"y":675,"ports":[{"id":"e5cb67c4-ca6e-49f4-9c67-6d48779a5163","type":"onetomany","x":915.7588000492678,"y":767.8377067641595,"name":"coll-port-1-left","alignment":"left","parentNode":"be84765a-1aa3-4ecc-ab01-a349bc9a583f","links":["1e74ccae-264c-4821-87a0-c252027a55b8"]},{"id":"e2e299dc-15dd-48dd-9453-169668656cec","type":"onetomany","x":1089.228078273447,"y":767.8377067641595,"name":"coll-port-1-right","alignment":"right","parentNode":"be84765a-1aa3-4ecc-ab01-a349bc9a583f","links":[]},{"id":"8d93c8da-d8b5-42a9-958d-44f0ad58ccaf","type":"onetomany","x":915.7588000492678,"y":793.3220456925442,"name":"coll-port-2-left","alignment":"left","parentNode":"be84765a-1aa3-4ecc-ab01-a349bc9a583f","links":["e435affc-8b0c-4167-9eb6-00f2920e8e4d"]},{"id":"ca3c63d8-ccf0-4dca-b6c8-0a5dc7666de3","type":"onetomany","x":1089.228078273447,"y":793.3220456925442,"name":"coll-port-2-right","alignment":"right","parentNode":"be84765a-1aa3-4ecc-ab01-a349bc9a583f","links":[]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["e5cb67c4-ca6e-49f4-9c67-6d48779a5163","e2e299dc-15dd-48dd-9453-169668656cec","8d93c8da-d8b5-42a9-958d-44f0ad58ccaf","ca3c63d8-ccf0-4dca-b6c8-0a5dc7666de3"],"otherInfo":{"data":{"columns":[{"name":"plan_id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1 2","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"trainingsplaene_uebungen","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"uebungs_id","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1 2","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"trainingsplaene_uebungen","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"saetze","atttypid":23,"attlen":null,"attnum":3,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1 2","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"trainingsplaene_uebungen","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"wiederholungen","atttypid":23,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1 2","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"trainingsplaene_uebungen","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","integer","integer","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","smallint"]},{"name":"dauer","atttypid":1186,"attlen":null,"attnum":5,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"interval","displaytypname":"interval","cltype":"interval","inheritedfrom":null,"inheritedid":null,"elemoid":1186,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1 2","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"trainingsplaene_uebungen","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["interval","interval","time without time zone"]}],"name":"trainingsplaene_uebungen","schema":"student200","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":135125,"name":"trainingsplaene_uebungen_pkey","col_count":2,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"plan_id"},{"column":"uebungs_id"}],"include":[]}],"foreign_key":[{"name":"trainingsplaene_uebungen_plan_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"c","confmatchtype":false,"conkey":[1],"confkey":[1],"confrelid":135097,"fknsp":"student200","fktab":"trainingsplaene_uebungen","refnspoid":134492,"refnsp":"student200","reftab":"trainingsplaene","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"plan_id","references":"0e5cd907-42c4-414a-bd1d-7b87110a4965","referenced":"plan_id","references_table_name":"student200.trainingsplaene"}],"remote_schema":"student200","remote_table":"trainingsplaene","coveringindex":null,"autoindex":false,"hasindex":false},{"name":"trainingsplaene_uebungen_uebungs_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"c","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":135114,"fknsp":"student200","fktab":"trainingsplaene_uebungen","refnspoid":134492,"refnsp":"student200","reftab":"uebungen","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"uebungs_id","references":"ee43e8d6-c6af-4509-a299-785e781394b0","referenced":"uebungs_id","references_table_name":"student200.uebungen"}],"remote_schema":"student200","remote_table":"uebungen","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"ee43e8d6-c6af-4509-a299-785e781394b0":{"id":"ee43e8d6-c6af-4509-a299-785e781394b0","type":"table","selected":false,"x":645,"y":915,"ports":[{"id":"cf040f04-0b13-4480-a491-70d8ada4223c","type":"onetomany","x":645.7586918103493,"y":1007.8432150799536,"name":"coll-port-1-left","alignment":"left","parentNode":"ee43e8d6-c6af-4509-a299-785e781394b0","links":[]},{"id":"6bd969bd-054f-4688-8409-e9a00cd76b56","type":"onetomany","x":819.2279700345284,"y":1007.8432150799536,"name":"coll-port-1-right","alignment":"right","parentNode":"ee43e8d6-c6af-4509-a299-785e781394b0","links":["e435affc-8b0c-4167-9eb6-00f2920e8e4d"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["cf040f04-0b13-4480-a491-70d8ada4223c","6bd969bd-054f-4688-8409-e9a00cd76b56"],"otherInfo":{"data":{"columns":[{"name":"uebungs_id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"","typname":"serial","displaytypname":"serial","cltype":"serial","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"uebungen","is_view_only":false,"attcompression":null,"seqrelid":135113,"seqtypid":23,"seqstart":"1","seqincrement":"1","seqmax":"2147483647","seqmin":"1","seqcache":"1","seqcycle":false,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","serial","smallint"]},{"name":"name","atttypid":1043,"attlen":"100","attnum":2,"attndims":0,"atttypmod":104,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(100)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"uebungen","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"beschreibung","atttypid":25,"attlen":null,"attnum":3,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"text","displaytypname":"text","cltype":"text","inheritedfrom":null,"inheritedid":null,"elemoid":25,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"uebungen","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","name","regclass","text"]},{"name":"kalorien_pro_minute","atttypid":1700,"attlen":"5","attnum":4,"attndims":0,"atttypmod":327686,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"m","attidentity":"","defval":null,"typname":"numeric","displaytypname":"numeric(5,2)","cltype":"numeric","inheritedfrom":null,"inheritedid":null,"elemoid":1700,"typnspname":"pg_catalog","defaultstorage":"m","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"uebungen","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":"2","coloptions":[],"edit_types":["bigint","double precision","integer","money","numeric","numeric","real","smallint"]}],"name":"uebungen","schema":"student200","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":135120,"name":"uebungen_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"uebungs_id"}],"include":[]}],"unique_constraint":[],"foreign_key":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"5ab646a7-7d7d-4a7f-bab3-fe39ac7b341e":{"id":"5ab646a7-7d7d-4a7f-bab3-fe39ac7b341e","type":"table","selected":false,"x":-150,"y":570,"ports":[{"id":"3be917ba-32c3-4897-a4c8-0eed708594cb","type":"onetomany","x":-149.2408064488509,"y":688.3229757939575,"name":"coll-port-2-left","alignment":"left","parentNode":"5ab646a7-7d7d-4a7f-bab3-fe39ac7b341e","links":[]},{"id":"23654d0d-7881-42df-bbeb-07c0a990161d","type":"onetomany","x":24.22840299020254,"y":688.3229757939575,"name":"coll-port-2-right","alignment":"right","parentNode":"5ab646a7-7d7d-4a7f-bab3-fe39ac7b341e","links":["7ada3c0f-70af-45c3-b057-db4407027ab7"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["3be917ba-32c3-4897-a4c8-0eed708594cb","23654d0d-7881-42df-bbeb-07c0a990161d"],"otherInfo":{"data":{"columns":[{"name":"zahlung_id","atttypid":23,"attlen":null,"attnum":1,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":"","typname":"serial","displaytypname":"serial","cltype":"serial","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"zahlungen","is_view_only":false,"attcompression":null,"seqrelid":135154,"seqtypid":23,"seqstart":"1","seqincrement":"1","seqmax":"2147483647","seqmin":"1","seqcache":"1","seqcycle":false,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","serial","smallint"]},{"name":"mitglied_id","atttypid":23,"attlen":null,"attnum":2,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"integer","displaytypname":"integer","cltype":"integer","inheritedfrom":null,"inheritedid":null,"elemoid":23,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"zahlungen","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","information_schema.cardinal_number","integer","money","numeric","oid","real","regclass","regcollation","regconfig","regdictionary","regnamespace","regoper","regoperator","regproc","regprocedure","regrole","regtype","serial","smallint"]},{"name":"betrag","atttypid":1700,"attlen":"10","attnum":3,"attndims":0,"atttypmod":655366,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"m","attidentity":"","defval":null,"typname":"numeric","displaytypname":"numeric(10,2)","cltype":"numeric","inheritedfrom":null,"inheritedid":null,"elemoid":1700,"typnspname":"pg_catalog","defaultstorage":"m","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"zahlungen","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":"2","coloptions":[],"edit_types":["bigint","double precision","integer","money","numeric","numeric","real","smallint"]},{"name":"zahlungsdatum","atttypid":1082,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"p","attidentity":"","defval":null,"typname":"date","displaytypname":"date","cltype":"date","inheritedfrom":null,"inheritedid":null,"elemoid":1082,"typnspname":"pg_catalog","defaultstorage":"p","description":null,"indkey":"1","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"zahlungen","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["date","timestamp with time zone","timestamp without time zone"]},{"name":"zahlungsmethode","atttypid":1043,"attlen":"50","attnum":5,"attndims":0,"atttypmod":54,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(50)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"zahlungen","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]}],"name":"zahlungen","schema":"student200","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"primary_key":[{"oid":135159,"name":"zahlungen_pkey","col_count":1,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"zahlung_id"}],"include":[]}],"foreign_key":[{"name":"zahlungen_mitglied_id_fkey","condeferrable":false,"condeferred":false,"confupdtype":"a","confdeltype":"c","confmatchtype":false,"conkey":[2],"confkey":[1],"confrelid":135036,"fknsp":"student200","fktab":"zahlungen","refnspoid":134492,"refnsp":"student200","reftab":"mitglieder","comment":null,"convalidated":true,"conislocal":true,"columns":[{"local_column":"mitglied_id","references":"245d534e-d739-426a-b6af-c9e057f17ac9","referenced":"mitglied_id","references_table_name":"student200.mitglieder"}],"remote_schema":"student200","remote_table":"mitglieder","coveringindex":null,"autoindex":false,"hasindex":false}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false}}},"d7fea907-7d2b-45e7-bb64-52c7bab78708":{"id":"d7fea907-7d2b-45e7-bb64-52c7bab78708","type":"table","selected":false,"x":-870,"y":345,"ports":[{"id":"b656578a-ebcc-4165-b696-2521a68b6028","type":"onetomany","x":-869.237339493804,"y":437.85273759789186,"name":"coll-port-1-left","alignment":"left","parentNode":"d7fea907-7d2b-45e7-bb64-52c7bab78708","links":[]},{"id":"ae3649e7-486a-49ab-a8a9-f8562d162724","type":"onetomany","x":-695.768121172787,"y":437.85273759789186,"name":"coll-port-1-right","alignment":"right","parentNode":"d7fea907-7d2b-45e7-bb64-52c7bab78708","links":["04a77a6b-067a-4a7a-89bd-4d88e6fa747e"]}],"name":"Untitled","color":"rgb(0,192,255)","portsInOrder":[],"portsOutOrder":["b656578a-ebcc-4165-b696-2521a68b6028","ae3649e7-486a-49ab-a8a9-f8562d162724"],"otherInfo":{"data":{"name":"city","schema":"public","description":null,"rlspolicy":false,"forcerlspolicy":false,"fillfactor":null,"toast_tuple_target":null,"parallel_workers":null,"relpersistence":false,"columns":[{"name":"name","atttypid":1043,"attlen":"50","attnum":1,"attndims":0,"atttypmod":54,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(50)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1 2 3","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"city","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"country","atttypid":1043,"attlen":"4","attnum":2,"attndims":0,"atttypmod":8,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(4)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1 2 3","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"city","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"province","atttypid":1043,"attlen":"50","attnum":3,"attndims":0,"atttypmod":54,"attacl":[],"attnotnull":true,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"x","attidentity":"","defval":null,"typname":"character varying","displaytypname":"character varying(50)","cltype":"character varying","inheritedfrom":null,"inheritedid":null,"elemoid":1043,"typnspname":"pg_catalog","defaultstorage":"x","description":null,"indkey":"1 2 3","isdup":false,"collspcname":"pg_catalog.\"default\"","is_fk":true,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"city","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":true,"is_primary_key":true,"attprecision":null,"coloptions":[],"edit_types":["\"char\"","character","character varying","character varying","character varying","character varying","information_schema.character_data","information_schema.yes_or_no","name","regclass","text"]},{"name":"population","atttypid":1700,"attlen":null,"attnum":4,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"m","attidentity":"","defval":null,"typname":"numeric","displaytypname":"numeric","cltype":"numeric","inheritedfrom":null,"inheritedid":null,"elemoid":1700,"typnspname":"pg_catalog","defaultstorage":"m","description":null,"indkey":"1 2 3","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"city","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","integer","money","numeric","numeric","real","smallint"]},{"name":"latitude","atttypid":1700,"attlen":null,"attnum":5,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"m","attidentity":"","defval":null,"typname":"numeric","displaytypname":"numeric","cltype":"numeric","inheritedfrom":null,"inheritedid":null,"elemoid":1700,"typnspname":"pg_catalog","defaultstorage":"m","description":null,"indkey":"1 2 3","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"city","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","integer","money","numeric","numeric","numeric","real","smallint"]},{"name":"longitude","atttypid":1700,"attlen":null,"attnum":6,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"m","attidentity":"","defval":null,"typname":"numeric","displaytypname":"numeric","cltype":"numeric","inheritedfrom":null,"inheritedid":null,"elemoid":1700,"typnspname":"pg_catalog","defaultstorage":"m","description":null,"indkey":"1 2 3","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"city","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","integer","money","numeric","numeric","numeric","numeric","real","smallint"]},{"name":"elevation","atttypid":1700,"attlen":null,"attnum":7,"attndims":0,"atttypmod":-1,"attacl":[],"attnotnull":false,"attoptions":null,"attfdwoptions":null,"attstattarget":-1,"attstorage":"m","attidentity":"","defval":null,"typname":"numeric","displaytypname":"numeric","cltype":"numeric","inheritedfrom":null,"inheritedid":null,"elemoid":1700,"typnspname":"pg_catalog","defaultstorage":"m","description":null,"indkey":"1 2 3","isdup":false,"collspcname":"","is_fk":false,"seclabels":null,"is_sys_column":false,"colconstype":"n","genexpr":null,"relname":"city","is_view_only":false,"attcompression":null,"seqrelid":null,"seqtypid":null,"seqstart":null,"seqincrement":null,"seqmax":null,"seqmin":null,"seqcache":null,"seqcycle":null,"is_pk":false,"is_primary_key":false,"attprecision":null,"coloptions":[],"edit_types":["bigint","double precision","integer","money","numeric","numeric","numeric","numeric","numeric","real","smallint"]}],"primary_key":[{"oid":21206,"name":"citykey","col_count":3,"indnullsnotdistinct":false,"spcname":"pg_default","comment":null,"condeferrable":false,"condeferred":false,"conislocal":true,"fillfactor":null,"columns":[{"column":"name"},{"column":"country"},{"column":"province"}],"include":[]}],"unique_constraint":[]},"note":"","metadata":{"data_failed":false,"is_promise":false,"fillColor":null,"textColor":null}}}}}]}} |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment