Unterschiede

Hier werden die Unterschiede zwischen zwei Versionen angezeigt.

--- en:modul:m290_guko:learningunits:lu06:aufgaben:case_postgebiete [2026/09/23 17:47] – Automatic push translation gkoch
+++ en:modul:m290_guko:learningunits:lu06:aufgaben:case_postgebiete [2026/09/23 17:49] (aktuell) – gkoch
@@ Zeile 9: / Zeile 9: @@
 We would like to **enter, amend and delete city districts and postcodes for the city of Zurich** in our database.
-Your tables: **poestler_in**, **postgebiet**, **letterbox**.
+Your tables: **poestler_in**, **postgebiet**, **briefkasten**.
 ===== Task =====
@@ Zeile 22: / Zeile 22: @@
 </code></WRAP>
-**postal_area** (Columns: name, postcode_area, poestler_id)
+**postgebiet** (Columns: name, plz_bereich, poestler_id)
 <WRAP center box 80% round><code sql>
 Zürich Kreis 1 - Altstadt, 8001-8001, 1
@@ Zeile 31: / Zeile 31: @@
 </code></WRAP>
-**Postbox** (Columns: location, collection_time, area_id)
+**briefkasten** (Columns: standort, leerungszeit, gebiet_id)
 <WRAP center box 80% round><code sql>
 ('Bahnhof Stadelhofen', '17:00:00', 1),
@@ Zeile 48: / Zeile 48: @@
 <WRAP center round tip 80%>
-Filter by location, e.g. ''WHERE location = 'Central' ''. Use SELECT beforehand to check how many rows are affected.
+Filter by location, e.g. ''WHERE standort = 'Central' ''. Use SELECT beforehand to check how many rows are affected.
 </WRAP>
 ==== 4. Delete data ====
   - The ‘Escher-Wyss-Platz’ postbox is being dismantled – delete it specifically by location.
-  - All postboxes in the “Zurich District 4 – Aussersihl” area are being reorganised – delete all postboxes with area_id 2 in one go.
+  - All postboxes in the “Zurich District 4 – Aussersihl” area are being reorganised – delete all postboxes with gebiet_id 2 in one go.
 Remember to carry out a dry run with SELECT before every DELETE.