Merge tables vs_kandidatur and commitment

Mapping

vs_kandidatur commitment Remark
— uuid Needs to be newly generated in some way
status
office_uuid
— is_private Set to 1 when migrating, so the names of these people are generally not shown via the API.
id — Deleted. Maybe we can keep a mapping from uuid to id in cold storage in some archive, but I would tend to avoid keeping this id.
created_on registered_on
ip registration_ip
gewaehlt
gremium
geschlecht
fakultaetFachschaft
lesung
bewerbungstext
customCode confirmation_code Used to generate a mail with which the person can confirm their candidacy
bestaetigt confirmed "ja" ↦ 1, "nein" ↦ 0
dummycol_geschlecht — Always empty, can be deleted
first_name first_name
last_name last_name
email email
phone_number phone_number
uni_id uni_id
matriculation_number matriculation_number
birth_date birth_date Birth dates of 0000-00-00 need to be set to NULL before merging
comment comment
Edited Aug 09, 2025 by Jakob Moser
Assignee Loading
Time tracking Loading