Tabellen- und Feld-Benennung standardisieren (inkl. Backend-Mappings)

Problembeschreibung

Hinweis: Mehrere Aufgaben zum Entfernen ungenutzter Tabellen und Spalten aus der Datenbank laufen bereits. SMS-/Benachrichtigungsfunktionen werden in diesen Issues bereinigt.

Das aktuelle Datenbankschema leidet unter uneinheitlichen Benennungskonventionen, die Wartung erschweren und die Codeklarheit verringern.

„Das folgende stammt aus Projekterfahrung und ist kein bloßer Vorschlag von KI. Eine Bereinigung würde die langfristigen Technologie-Schulden deutlich reduzieren. In den ersten 6–9 Monaten fiel es mir schwer, all das ungefähr im Kopf zu mappen.“ @ThomasAFink

Hier schreiben.

Hier schreiben.

Hier schreiben.

Investition: Schema standardisieren und Abfragen aktualisieren
Rendite:
- Schnelleres Onboarding neuer Entwickler:innen (Monate pro Person)
- Weniger Debug-Zeit (Stunden pro Issue)
- Höhere Entwicklungsgeschwindigkeit (Zeitersparnis bei jedem Backend-Feature)
- Weniger Fehlereinbau (vermeidet kostspielige Produktionsprobleme und Hotfixes)
- Schnelleres Refactoring weiterer Teile später
- Einfachere Test-Erstellung

Die Themen umfassen:

1. Sprachmischung (Deutsch ↔ Englisch)

• Tabellennamen: oeffnungszeit (Deutsch) vs. availability (englisches Konzept)
• Tabellennamen: standort (Deutsch) vs. scope (englisches Konzept)
• Tabellennamen: buerger (Deutsch) vs. citizen (englisches Konzept)
• Tabellennamen: feiertage (Deutsch) vs. holidays (englisches Konzept)

2. Inkonsistente Benennungskonventionen

• Mischung aus camelCase und snake_case: StandortID vs. scope_id
• Gemischte Konventionen in derselben Tabelle: contact__name vs. contact__email vs. StandortID

3. Konzeptionelle Inkonsistenzen

• Dasselbe Konzept mit unterschiedlichen Namen: availability/oeffnungszeit, scope/standort
• Query-Klassen nutzen englische Namen, mappen aber auf deutsche Tabellennamen

Aktuelle Beispiele

Availability-Query-Klasse:

const TABLE = 'oeffnungszeit';  // German table name
// But maps to English field names:
'id' => 'availability.OeffnungszeitID',
'scope__id' => 'availability.StandortID',

Scope-Query-Klasse:

const TABLE = 'standort';  // German table name
// Maps to mixed naming:
'id' => 'scope.StandortID',
'contact__name' => 'scopeprovider.name',

Vorgeschlagene Lösung

Standardisierungsregeln:

1. Sprache: Alle Tabellen- und Spaltennamen auf Englisch
2. Datenbankkonvention: snake_case für alle Tabellen- und Spaltennamen
3. Mapping-Konvention: camelCase für alle Mapping-Variablen in Query-Klassen
4. Konsistenz: Konzeptnamen im gesamten Schema angleichen

Migrationsplan:

1. Phase 1: Umbenennung von Tabellen

   • oeffnungszeit → availability
   • standort → scope
   • buerger → citizen
   • feiertage → holidays
   • gesamtkalender → calendar

2. Phase 2: Spalten-Standardisierung

   • Alle Spaltennamen nach snake_case
   • Fremdschlüssel-Namen vereinheitlichen: StandortID → scope_id
   • Feldnamen angleichen: OeffnungszeitID → availability_id

3. Phase 3: Aktualisierung der Query-Klassen

   • Alle Zmsdb/Query/*-Klassen auf neue Tabellen-/Spaltennamen
   • Mapping-Variablen in camelCase: scopeId → availability.scope_id
   • Entity-Mapping-Methoden aktualisieren

Erwartete Ergebnisse

• Wartbarkeit: Einheitliche Namen reduzieren kognitive Last
• Klarheit: Englische Namen verbessern internationale Zusammenarbeit
• Angleichung: Query-Klassen entsprechen dem tatsächlichen Schema
• Zukunftssicherheit: Standardkonventionen für neue Entwicklung
• Testbarkeit: Tests sind mit konsistenter Benennung einfacher zu schreiben und zu pflegen

Hinweise zur Umsetzung

• Umfassende Migrationsskripte pro Tabelle erstellen
• Alle betroffenen Query-Klassen in zmsdb/src/Zmsdb/Query/ aktualisieren
• Abwärtskompatibilität während der Übergangsphase sicherstellen
• Dokumentation und API-Referenzen aktualisieren

Beispiel nach Standardisierung

Availability-Query-Klasse (nachher):

const TABLE = 'availability';  // English snake_case table name
// Maps to camelCase variables:
'id' => 'availability.availability_id',
'scopeId' => 'availability.scope_id',
'startDate' => 'availability.start_date',

Scope-Query-Klasse (nachher):

const TABLE = 'scope';  // English snake_case table name
// Maps to camelCase variables:
'id' => 'scope.scope_id',
'contactName' => 'scopeprovider.name',

Damit gilt:

• Datenbank: Alles snake_case (übliche SQL-Konvention)
• Query-Mappings: Alles camelCase (übliche PHP-Konvention)
• Konsistenz: Keine Ausnahmen, einheitliches Muster

Drei Phasen:

1. Vollständiger Plan zur Tabellenumbenennung – alles Englisch, alles snake_case einfach

• 47 Tabellen von Deutsch nach Englisch
• Alle Tabellennamen auf snake_case vereinheitlicht
• Nach Geschäftspriorität sortiert (Kern → Benutzer → System → Technik)
• Klarer Migrationspfad mit Beispielen

2. Vollständiger Plan zur Spaltenumbenennung – alles Englisch, alles snake_case einfach–mittel

• Hunderte Spalten von Deutsch nach Englisch
• Alle Spaltennamen auf snake_case
• Fremdschlüssel-Namen tabellenübergreifend vereinheitlicht
• Gemeinsame Muster identifiziert und standardisiert

3. Vollständiger Plan zur Umbenennung der PHP-Variablen-Mappings – alles Englisch, alles camelCase schwer

• Alle Query-Klassen-Mappings nach camelCase
• Doppel-Unterstrich-Muster entfernt
• Verschachtelte Objektmuster standardisiert
• Referenz-Mappings aktualisiert

Nicht alle Tabellen, Spalten und Mappings sind hier aufgeführt. Die Liste kann unvollständig sein, ist aber ein guter Start. Ein Überblick bietet die lokale ddev-Entwicklungsumgebung.

1. Vollständiger Plan zur Tabellenumbenennung – alles Englisch, alles snake_case

Phase 1: Kerngeschäfts-Tabellen (hohe Priorität)

Current	New (snake_case)	Reason
oeffnungszeit	availability	Opening hours/availability
standort	scope	Location/scope
buerger	citizen	Citizen
feiertage	holidays	Holidays
gesamtkalender	calendar	Calendar
behoerde	department	Government department
organisation	organization	Organization

Phase 2: Benutzer- & Prozess-Tabellen

Current	New (snake_case)	Reason
buergeranliegen	citizen_requests	Citizen requests/issues
buergerarchiv	citizen_archive	Archived citizen data
nutzer	user	System users
nutzerzuordnung	user_assignment	User assignments
kunde	customer	Customer
kundenlinks	customer_links	Customer links

Phase 3: System- & Konfigurations-Tabellen

Current	New (snake_case)	Reason
abrechnung	billing	Billing/accounting
ipausnahmen	ip_exceptions	IP exceptions
kiosk	kiosk	Kiosk (universal term)
wartenrstatistik	queue_number_statistics	Queue number statistics
standortcluster	location_cluster	Location clustering
statistik	statistics	Statistics

Phase 4: API- & technische Tabellen

Current	New (snake_case)	Reason
apiclient	api_client	API client
apikey	api_key	API key
apiquota	api_quota	API quota

Phase 5: Kommunikations-Tabellen

Current	New (snake_case)	Reason
email	email	Email (already snake_case)
sms	sms	SMS (already snake_case)
mailpart	mail_part	Mail part
mailqueue	mail_queue	Mail queue
mailtemplate	mail_template	Mail template
notificationqueue	notification_queue	Notification queue

Phase 6: Daten- & Prozess-Tabellen

Current	New (snake_case)	Reason
closures	closures	Already snake_case
config	config	Already snake_case
eventlog	event_log	Event log
imagedata	image_data	Image data
log	log	Already snake_case
migrations	migrations	Already snake_case
preferences	preferences	Already snake_case
process_sequence	process_sequence	Already snake_case
sessiondata	session_data	Session data
source	source	Already snake_case

Phase 7: Leistungs- & Anbieter-Tabellen

Current	New (snake_case)	Reason
provider	provider	Already snake_case
request	request	Already snake_case
request_provider	request_provider	Already snake_case
request_variant	request_variant	Already snake_case

Phase 8: Slot-System-Tabellen

Current	New (snake_case)	Reason
slot	slot	Already snake_case
slot_hiera	slot_hierarchy	Slot hierarchy
slot_process	slot_process	Already snake_case
slot_sequence	slot_sequence	Already snake_case

Phase 9: Zuweisungs- & Clustering-Tabellen

Current	New (snake_case)	Reason
clusterzuordnung	cluster_assignment	Cluster assignment

2. Vollständiger Plan zur Spaltenumbenennung – alles Englisch, alles snake_case

Phase 1: Kerngeschäfts-Tabellen (hohe Priorität)

availability (formerly oeffnungszeit)

Current Column	New Column (snake_case)	Reason
OeffnungszeitID	availability_id	Primary key
StandortID	scope_id	Foreign key to scope
BehoerdenID	department_id	Foreign key to department
Startdatum	start_date	Start date
Endedatum	end_date	End date
Anfangszeit	start_time	Start time
Endzeit	end_time	End time
Terminanfangszeit	appointment_start_time	Appointment start time
Terminendzeit	appointment_end_time	Appointment end time
Wochentag	weekday	Weekday
Timeslot	time_slot	Time slot
kommentar	comment	Comment
Offen_ab	open_from_days	Open from days
Offen_bis	open_until_days	Open until days
Anzahlterminarbeitsplaetze	appointment_workstation_count	Appointment workstation count
reduktionTermineImInternet	internet_reduction	Internet reduction
reduktionTermineCallcenter	callcenter_reduction	Call center reduction
erlaubemehrfachslots	multiple_slots_allowed	Multiple slots allowed
allexWochen	every_x_weeks	Every X weeks
jedexteWoche	every_other_week	Every other week
updateTimestamp	updated_at	Update timestamp

scope (formerly standort)

Current Column	New Column (snake_case)	Reason
StandortID	scope_id	Primary key
BehoerdenID	department_id	Foreign key to department
Bezeichnung	name	Name/designation
standortkuerzel	short_name	Short name
Adresse	address	Address
emailstandortadmin	admin_email	Admin email
InfoDienstleisterID	info_provider_id	Info provider ID
source	source	Source (already snake_case)
Termine_ab	appointments_from_days	Appointments from days
Termine_bis	appointments_until_days	Appointments until days
loeschdauer	deletion_duration	Deletion duration
reservierungsdauer	reservation_duration	Reservation duration
aktivierungsdauer	activation_duration	Activation duration
mehrfachtermine	multiple_appointments	Multiple appointments
wartenummernkontingent	queue_number_contingent	Queue number contingent
vergebenewartenummern	assigned_queue_numbers	Assigned queue numbers
letztewartenr	last_queue_number	Last queue number
startwartenr	first_queue_number	First queue number
endwartenr	last_queue_number	Last queue number
anzahlwiederaufruf	recall_count	Recall count
aufrufanzeigetext	display_text	Display text
wartenrhinweis	queue_hint	Queue hint
standortinfozeile	location_info_line	Location info line
ausgabeschaltername	pickup_counter_name	Pickup counter name
defaultabholerstandort	default_pickup_location	Default pickup location
wartezeitveroeffentlichen	publish_waiting_time	Publish waiting time
ohnestatistik	without_statistics	Without statistics
notruffunktion	emergency_function	Emergency function
notrufausgeloest	emergency_triggered	Emergency triggered
notrufantwort	emergency_response	Emergency response
notrufinitiierung	emergency_initiation	Emergency initiation
virtuellesachbearbeiterzahl	virtual_processor_count	Virtual processor count
wartenrdatum	queue_number_date	Queue number date
Bearbeitungszeit	processing_time	Processing time
emailPflichtfeld	email_required	Email required
telefonPflichtfeld	phone_required	Phone required
telefonaktiviert	phone_enabled	Phone enabled
anmerkungPflichtfeld	comment_required	Comment required
anmerkungLabel	comment_label	Comment label
qtv_url	qtv_url	QTV URL (already snake_case)
email_confirmation_activated	email_confirmation_activated	Already snake_case
appointments_per_mail	appointments_per_mail	Already snake_case
slots_per_appointment	slots_per_appointment	Already snake_case
whitelisted_mails	whitelisted_mails	Already snake_case
custom_text_field_active	custom_text_field_active	Already snake_case
custom_text_field_required	custom_text_field_required	Already snake_case
custom_text_field_label	custom_text_field_label	Already snake_case
custom_text_field2_active	custom_text_field2_active	Already snake_case
custom_text_field2_required	custom_text_field2_required	Already snake_case
custom_text_field2_label	custom_text_field2_label	Already snake_case
captcha_activated_required	captcha_activated_required	Already snake_case
admin_mail_on_appointment	admin_mail_on_appointment	Already snake_case
admin_mail_on_deleted	admin_mail_on_deleted	Already snake_case
admin_mail_on_updated	admin_mail_on_updated	Already snake_case
admin_mail_on_mail_sent	admin_mail_on_mail_sent	Already snake_case
smsbestaetigungstext	sms_confirmation_text	SMS confirmation text
smsbenachrichtigungstext	sms_notification_text	SMS notification text
smsbenachrichtigungsfrist	sms_notification_deadline	SMS notification deadline
smswmsbestaetigung	sms_wms_confirmation	SMS WMS confirmation
smswarteschlange	sms_queue	SMS queue
smskioskangebotsfrist	sms_kiosk_offer_deadline	SMS kiosk offer deadline
smsnachtrag	sms_addition	SMS addition
kundenbef_emailtext	customer_survey_email_text	Customer survey email text
kundenbefragung	customer_survey	Customer survey
kundenbef_label	customer_survey_label	Customer survey label
info_for_appointment	info_for_appointment	Already snake_case
info_for_all_appointments	info_for_all_appointments	Already snake_case
updateTimestamp	updated_at	Update timestamp

citizen (formerly buerger)

Current Column	New Column (snake_case)	Reason
BuergerID	citizen_id	Primary key
StandortID	scope_id	Foreign key to scope
AbholortID	pickup_location_id	Pickup location ID
NutzerID	user_id	User ID
Name	name	Name
Email	email	Email
Telefon	phone	Phone
Anmerkung	comment	Comment
vorlaeufigeBuchung	provisional_booking	Provisional booking
bestaetigt	confirmed	Confirmed
aufruferfolgreich	call_successful	Call successful
aufrufzeit	call_time	Call time
Abholer	pickup_person	Pickup person
wartenr	queue_number	Queue number
wartenrdatum	queue_number_date	Queue number date
wartezeit	waiting_time	Waiting time
bearbeitungszeit	processing_time	Processing time
parked	parked	Already snake_case
wasMissed	was_missed	Was missed
apiClientID	api_client_id	API client ID
source	source	Source (already snake_case)
updateTimestamp	updated_at	Update timestamp

Phase 2: Benutzer- & Prozess-Tabellen (Medium Priority)

citizen_requests (formerly buergeranliegen)

Current Column	New Column (snake_case)	Reason
BuergeranliegenID	citizen_request_id	Primary key
BuergerID	citizen_id	Foreign key to citizen
StandortID	scope_id	Foreign key to scope
Anliegen	request	Request/concern
source	source	Source (already snake_case)
updateTimestamp	updated_at	Update timestamp

user (formerly nutzer)

Current Column	New Column (snake_case)	Reason
NutzerID	user_id	Primary key
BehoerdenID	department_id	Foreign key to department
Name	name	Name
Email	email	Email
Passwort	password	Password
updateTimestamp	updated_at	Update timestamp

Phase 3: System- & Konfigurations-Tabellen (niedrigere Priorität)

api_client (formerly apiclient)

Current Column	New Column (snake_case)	Reason
apiClientID	api_client_id	Primary key
clientKey	client_key	Client key
shortname	short_name	Short name
accesslevel	access_level	Access level
updateTimestamp	updated_at	Update timestamp

api_key (formerly apikey)

Current Column	New Column (snake_case)	Reason
apiKeyID	api_key_id	Primary key
apiClientID	api_client_id	Foreign key to api_client
key	key	Key (already snake_case)
updateTimestamp	updated_at	Update timestamp

Phase 4: Slot System Tables

slot

Current Column	New Column (snake_case)	Reason
slotID	slot_id	Primary key
scopeID	scope_id	Foreign key to scope
availabilityID	availability_id	Foreign key to availability
year	year	Year (already snake_case)
month	month	Month (already snake_case)
day	day	Day (already snake_case)
time	time	Time (already snake_case)
public	public	Public (already snake_case)
callcenter	callcenter	Call center (already snake_case)
intern	intern	Internal (already snake_case)
status	status	Status (already snake_case)
slotTimeInMinutes	slot_time_in_minutes	Slot time in minutes
createTimestamp	created_at	Create timestamp
updateTimestamp	updated_at	Update timestamp

Phase 4: Fremdschlüssel-Standardisierung

Current Pattern	New Pattern	Example
StandortID	scope_id	Foreign key to scope table
BehoerdenID	department_id	Foreign key to department table
BuergerID	citizen_id	Foreign key to citizen table
NutzerID	user_id	Foreign key to user table
OeffnungszeitID	availability_id	Foreign key to availability table

3. Vollständiger Plan zur Umbenennung der PHP-Variablen-Mappings – alles Englisch, alles camelCase

Step 1: Update Entity Mappings Replace all double underscore patterns with camelCase Update all German variable names to English Ensure consistent naming across all Query classes

Step 2: Update Method Names Update method names that reference old mappings Ensure parameter names match new mapping keys Update any hardcoded references

Step 3: Update Tests Update all test cases to use new mapping keys Ensure test data matches new naming conventions Update any mock data or fixtures

Step 4: Update Documentation Update API documentation with new field names Update any external references to old field names Create migration guide for API consumers This comprehensive plan ensures: Complete camelCase conversion for all PHP variable mappings Elimination of double underscores in favor of camelCase Consistent English naming throughout the codebase Maintainable structure with clear patterns

Phase 1: Kern-Entity-Mappings (hohe Priorität)

Availability Query Class

Current Mapping	New Mapping (camelCase)	Database Column (snake_case)
'id'	'id'	availability.availability_id
'scope**id'	'scopeId'	availability.scope_id
'bookable**startInDays'	'bookableStartInDays'	availability.open_from_days
'bookable**endInDays'	'bookableEndInDays'	availability.open_until_days
'description'	'description'	availability.comment
'startDate'	'startDate'	availability.start_date
'startTime'	'startTime'	availability.start_time
'endDate'	'endDate'	availability.end_date
'endTime'	'endTime'	availability.end_time
'lastChange'	'lastChange'	availability.updated_at
'multipleSlotsAllowed'	'multipleSlotsAllowed'	availability.multiple_slots_allowed
'repeat**afterWeeks'	'repeatAfterWeeks'	availability.every_x_weeks
'repeat**weekOfMonth'	'repeatWeekOfMonth'	availability.every_other_week
'slotTimeInMinutes'	'slotTimeInMinutes'	availability.time_slot
'type'	'type'	availability.type
'weekday**monday'	'weekdayMonday'	availability.weekday
'weekday**tuesday'	'weekdayTuesday'	availability.weekday
'weekday**wednesday'	'weekdayWednesday'	availability.weekday
'weekday**thursday'	'weekdayThursday'	availability.weekday
'weekday**friday'	'weekdayFriday'	availability.weekday
'weekday**saturday'	'weekdaySaturday'	availability.weekday
'weekday**sunday'	'weekdaySunday'	availability.weekday
'workstationCount**callcenter'	'workstationCountCallcenter'	availability.workstation_count_callcenter
'workstationCount**intern'	'workstationCountIntern'	availability.workstation_count_intern
'workstationCount__public'	'workstationCountPublic'	availability.workstation_count_public

Scope Query Class

Current Mapping	New Mapping (camelCase)	Database Column (snake_case)
'hint'	'hint'	scope.hint
'id'	'id'	scope.scope_id
'contact**name'	'contactName'	scopeprovider.name
'contact**street'	'contactStreet'	scope.address
'contact**email'	'contactEmail'	scope.admin_email
'contact**country'	'contactCountry'	"Germany"
'lastChange'	'lastChange'	scope.updated_at
'preferencesappointmentdeallocationDuration'	'preferencesAppointmentDeallocationDuration'	scope.deletion_duration
'preferencesappointmentinfoForAppointment'	'preferencesAppointmentInfoForAppointment'	scope.info_for_appointment
'preferencesappointmentinfoForAllAppointments'	'preferencesAppointmentInfoForAllAppointments'	scope.info_for_all_appointments
'preferencesappointmentendInDaysDefault'	'preferencesAppointmentEndInDaysDefault'	scope.appointments_until_days
'preferencesappointmentmultipleSlotsEnabled'	'preferencesAppointmentMultipleSlotsEnabled'	scope.multiple_appointments
'preferencesappointmentreservationDuration'	'preferencesAppointmentReservationDuration'	scope.reservation_duration
'preferencesappointmentactivationDuration'	'preferencesAppointmentActivationDuration'	scope.activation_duration
'preferencesappointmentstartInDaysDefault'	'preferencesAppointmentStartInDaysDefault'	scope.appointments_from_days
'preferencesappointmentnotificationConfirmationEnabled'	'preferencesAppointmentNotificationConfirmationEnabled'	scope.sms_confirmation_enabled
'preferencesappointmentnotificationHeadsUpEnabled'	'preferencesAppointmentNotificationHeadsUpEnabled'	scope.sms_notification_enabled
'preferencesclientalternateAppointmentUrl'	'preferencesClientAlternateAppointmentUrl'	scope.qtv_url
'preferencesclientamendmentActivated'	'preferencesClientAmendmentActivated'	scope.comment_required
'preferencesclientamendmentLabel'	'preferencesClientAmendmentLabel'	scope.comment_label
'preferencesclientemailFrom'	'preferencesClientEmailFrom'	scopemail.sender_address
'preferencesclientemailRequired'	'preferencesClientEmailRequired'	scope.email_required
'preferencesclientemailConfirmationActivated'	'preferencesClientEmailConfirmationActivated'	scope.email_confirmation_activated
'preferencesclienttelephoneActivated'	'preferencesClientTelephoneActivated'	scope.phone_enabled
'preferencesclienttelephoneRequired'	'preferencesClientTelephoneRequired'	scope.phone_required
'preferencesclientappointmentsPerMail'	'preferencesClientAppointmentsPerMail'	scope.appointments_per_mail
'preferencesclientslotsPerAppointment'	'preferencesClientSlotsPerAppointment'	scope.slots_per_appointment
'preferencesclientwhitelistedMails'	'preferencesClientWhitelistedMails'	scope.whitelisted_mails
'preferencesclientcustomTextfieldActivated'	'preferencesClientCustomTextfieldActivated'	scope.custom_text_field_active
'preferencesclientcustomTextfieldRequired'	'preferencesClientCustomTextfieldRequired'	scope.custom_text_field_required
'preferencesclientcustomTextfieldLabel'	'preferencesClientCustomTextfieldLabel'	scope.custom_text_field_label
'preferencesclientcustomTextfield2Activated'	'preferencesClientCustomTextfield2Activated'	scope.custom_text_field2_active
'preferencesclientcustomTextfield2Required'	'preferencesClientCustomTextfield2Required'	scope.custom_text_field2_required
'preferencesclientcustomTextfield2Label'	'preferencesClientCustomTextfield2Label'	scope.custom_text_field2_label
'preferencesclientcaptchaActivatedRequired'	'preferencesClientCaptchaActivatedRequired'	scope.captcha_activated_required
'preferencesclientadminMailOnAppointment'	'preferencesClientAdminMailOnAppointment'	scope.admin_mail_on_appointment
'preferencesclientadminMailOnDeleted'	'preferencesClientAdminMailOnDeleted'	scope.admin_mail_on_deleted
'preferencesclientadminMailOnUpdated'	'preferencesClientAdminMailOnUpdated'	scope.admin_mail_on_updated
'preferencesclientadminMailOnMailSent'	'preferencesClientAdminMailOnMailSent'	scope.admin_mail_on_mail_sent
'preferencesnotificationsconfirmationContent'	'preferencesNotificationsConfirmationContent'	scope.sms_confirmation_text
'preferencesnotificationsheadsUpContent'	'preferencesNotificationsHeadsUpContent'	scope.sms_notification_text
'preferencesnotificationsheadsUpTime'	'preferencesNotificationsHeadsUpTime'	scope.sms_notification_deadline
'preferencespickupalternateName'	'preferencesPickupAlternateName'	scope.pickup_counter_name
'preferencespickupisDefault'	'preferencesPickupIsDefault'	scope.default_pickup_location
'preferencesqueuecallCountMax'	'preferencesQueueCallCountMax'	scope.recall_count
'preferencesqueuecallDisplayText'	'preferencesQueueCallDisplayText'	scope.display_text
'preferencesqueuefirstNumber'	'preferencesQueueFirstNumber'	scope.first_queue_number
'preferencesqueuelastNumber'	'preferencesQueueLastNumber'	scope.last_queue_number
'preferencesqueuemaxNumberContingent'	'preferencesQueueMaxNumberContingent'	scope.queue_number_contingent
'preferencesqueueprocessingTimeAverage'	'preferencesQueueProcessingTimeAverage'	scope.processing_time
'preferencesqueuepublishWaitingTimeEnabled'	'preferencesQueuePublishWaitingTimeEnabled'	scope.publish_waiting_time
'preferencesqueuestatisticsEnabled'	'preferencesQueueStatisticsEnabled'	scope.statistics_enabled
'preferencessurveyemailContent'	'preferencesSurveyEmailContent'	scope.customer_survey_email_text
'preferencessurveyenabled'	'preferencesSurveyEnabled'	scope.customer_survey
'preferencessurveylabel'	'preferencesSurveyLabel'	scope.customer_survey_label
'preferencesticketprinterbuttonName'	'preferencesTicketprinterButtonName'	scope.location_info_line
'preferencesticketprinterconfirmationEnabled'	'preferencesTicketprinterConfirmationEnabled'	scope.sms_wms_confirmation
'preferencesticketprinterdeactivatedText'	'preferencesTicketprinterDeactivatedText'	scope.queue_hint
'preferencesticketprinternotificationsAmendmentEnabled'	'preferencesTicketprinterNotificationsAmendmentEnabled'	scope.sms_addition
'preferencesticketprinternotificationsEnabled'	'preferencesTicketprinterNotificationsEnabled'	scope.sms_queue
'preferencesticketprinternotificationsDelay'	'preferencesTicketprinterNotificationsDelay'	scope.sms_kiosk_offer_deadline
'preferencesworkstationemergencyEnabled'	'preferencesWorkstationEmergencyEnabled'	scope.emergency_function
'preferencesworkstationemergencyRefreshInterval'	'preferencesWorkstationEmergencyRefreshInterval'	scope.emergency_refresh_interval
'shortName'	'shortName'	scope.short_name
'statusemergencyacceptedByWorkstation'	'statusEmergencyAcceptedByWorkstation'	scope.emergency_response
'statusemergencyactivated'	'statusEmergencyActivated'	scope.emergency_triggered
'statusemergencycalledByWorkstation'	'statusEmergencyCalledByWorkstation'	scope.emergency_initiation
'statusqueueghostWorkstationCount'	'statusQueueGhostWorkstationCount'	scope.virtual_processor_count
'statusqueuegivenNumberCount'	'statusQueueGivenNumberCount'	scope.assigned_queue_numbers
'statusqueuelastGivenNumber'	'statusQueueLastGivenNumber'	scope.last_queue_number
'statusqueuelastGivenNumberTimestamp'	'statusQueueLastGivenNumberTimestamp'	scope.queue_number_date

Phase 2: Prozess- & Bürger-Mappings (mittlere Priorität)

Process Query Class

Current Mapping	New Mapping (camelCase)	Database Column (snake_case)
'amendment'	'amendment'	process.comment
'id'	'id'	process.citizen_id
'appointments0date'	'appointments0Date'	process.appointment_datetime
'scope**id'	'scopeId'	process.scope_id
'appointments0scope**id'	'appointments0ScopeId'	process.scope_id

Citizen Query Class

Current Mapping	New Mapping (camelCase)	Database Column (snake_case)
'id'	'id'	citizen.citizen_id
'scopeId'	'scopeId'	citizen.scope_id
'pickupLocationId'	'pickupLocationId'	citizen.pickup_location_id
'userId'	'userId'	citizen.user_id
'name'	'name'	citizen.name
'email'	'email'	citizen.email
'phone'	'phone'	citizen.phone
'comment'	'comment'	citizen.comment
'provisionalBooking'	'provisionalBooking'	citizen.provisional_booking
'confirmed'	'confirmed'	citizen.confirmed
'callSuccessful'	'callSuccessful'	citizen.call_successful
'callTime'	'callTime'	citizen.call_time
'pickupPerson'	'pickupPerson'	citizen.pickup_person
'queueNumber'	'queueNumber'	citizen.queue_number
'queueNumberDate'	'queueNumberDate'	citizen.queue_number_date
'waitingTime'	'waitingTime'	citizen.waiting_time
'processingTime'	'processingTime'	citizen.processing_time
'parked'	'parked'	citizen.parked
'wasMissed'	'wasMissed'	citizen.was_missed
'apiClientId'	'apiClientId'	citizen.api_client_id
'source'	'source'	citizen.source
'lastChange'	'lastChange'	citizen.updated_at

Phase 3: Anbieter- & Request-Mappings (niedrigere Priorität)

Provider Query Class

Current Mapping	New Mapping (camelCase)	Database Column (snake_case)
'contact**city'	'contactCity'	provider.contact_city
'contact**country'	'contactCountry'	provider.contact_country
'contact**name'	'contactName'	provider.name
'contact**postalCode'	'contactPostalCode'	provider.contact_postal_code
'contact**region'	'contactRegion'	provider.contact_region
'contact**street'	'contactStreet'	provider.contact_street
'contact__streetNumber'	'contactStreetNumber'	provider.contact_street_number
'id'	'id'	provider.id
'link'	'link'	provider.link
'name'	'name'	provider.name
'displayName'	'displayName'	provider.display_name
'source'	'source'	provider.source
'data'	'data'	provider.data