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 by Jakob Moser