Merge tables sturaMitglied and commitment
See also #240.
Rename-only mappings
sturaMitglied |
commitment |
Remark |
ip |
registration_ip |
✅ |
bemerkungen |
comment |
✅ |
listenplatz |
stura_list_index |
✅ |
rang |
stura_rank |
✅ |
amtsbeginn |
office_period_start |
✅ |
amtsende |
office_period_end |
✅ |
Mapping
|
sturaMitglied
|
commitment
|
Remark |
|
id
|
uuid
|
✅ Has to be newly generated, and all references changed
|
| 1 |
is_private
|
✅ Maybe set this to true first, and change it as needed
|
|
person_id
|
person_uuid
|
✅ Has to be remapped
|
|
sturaGruppeId
|
office_uuid
|
✅ Has to be remapped via sturaGruppe view.
|
|
imAmt
|
enter_status
|
✅ Probably needs to be mapped in a more complex manner, maybe also depending on other fields.
|
|
stellvertreterin
|
enter_status
|
✅ See above.
|
|
anwesenheitsliste
|
|
✅ Probably create a new field for that.
|
|
amtsendeDurch
|
exit_status
|
✅ Ende der Amtszeit → NULL
Rücktritt → resigned
Exmatrikulation → unenrolled
Abberufung → unelected
To do:
- Mandatsverlust durch Kandidatur für eine Liste
- Mandatsverlust durch Entsendung für eine Fachschaft
- Mandatsverlust durch Studienfachwechsel
- Mandatsverlust aus rechtlichen Gründen - siehe Bemerkungen
- Nachrücken als reguläres Mitglied
|
|
legislaturperiodeId
|
|
✅ Remove
|
|
kommissarisch
|
|
✅
|
Edited
by
Jakob Moser