3.1.1. Termine ---------------------------------------------------------------------------------------------------------------------------- Beschreibung => event(description) Format (Y.m.d H:i:s) : Startdatum => event(date_from) Y.m.d Startzeit => event(date_from) H:i:s Enddatum => event(date_to) Y.m.d Endzeit => event(date_to) H:i:s Kategorie => event(FK:idevent_type) reference to event_type(idevent_type,type) Status (abgelehnt / angenommen) => event(FK:idstatus_type) reference to event_status(idevent_status,status) Primär/sekundär Wunsch (nur bei festen Terminen) => event(request), event(request_additional) Kind (nur bei Betreuungsterminen, Eingewöhnungsterminen) => event(FK:idchild) reference to person(idperson,idperson_type) 3.1.2. Kinder person(FK:idperson_type): 1 - Kind ---------------------------------------------------------------------------------------------------------------------------- Vorname => person(forename) Nachname => person(surename) Geburtsdatum => person(birthday) Notizfeld => person(comment) Kriterien-Ranking-Punkte => person(ranking_points) 3.1.3. Eltern person(FK:idperson_type): 2 - Mutter 3 - Vater ---------------------------------------------------------------------------------------------------------------------------- Vorname => person(forename) Nachname => person(surename) Telefonnummer primär => person(telnumber) Telefonnummer sekundär => person(telnumber_additional) Kind(er) => person_link_person((FK:idperson1 alias idchild reference to person(idperson)), (FK:idperson2 alias idparent reference to person(idperson)), idpersonrelation_type:if necessary) Optional: Email Adresse => person(email) Anschrift => person(FK:idcity) reference to city(idcity,city), person(street), person(postalcode) Mitarbeiter person(FK:idperson_type): 4 - Betreuer 6 - Mitarbeiter 3.1.4. Verfügbarkeit & Arbeitszeiten ---------------------------------------------------------------------------------------------------------------------------- Datum => nurse_worktime(FK:idnurse reference to person(idperson),date_from[d],date_to[d]) Startzeit => nurse_worktime(FK:idnurse reference to person(idperson),date_from[H:i:s]) Endzeit => nurse_worktime(FK:idnurse reference to person(idperson),date_to[H:i:s]) Mitarbeiter => ? Status (verfügbar/eingeteilt) => person(FK:idperson_status reference to person_status(idperson_status,status)) 3.1.5. Mitarbeiter ---------------------------------------------------------------------------------------------------------------------------- Vorname => person(forename) Nachname => person(surename) Vollzeit/Aushilfe => person(enum:form_of_employment('Vollzeit','Teilzeit','Aushilfe','Keine')) Telefonnummer => person(telnumber), person(mobilenumber) Email-Adresse => person(email) 3.1.6. Status Flag Tabelle ---------------------------------------------------------------------------------------------------------------------------- Max. Betreuungsplätze => status_flag(max_caresits) Max. Anzahl Kinder < 1 Jahr => status_flag(max_children_under_age_1) Max. Betreuungstage für Kinder < 1 Jahr => status_flag(max_caredays_for_children_under_age_1) Max. Betreuungstage für Kinder > 1 Jahr => status_flag(max_caredays_for_children_over_age_1) Max. Betreuungsstunden pro Woche => status_flag(max_carehours_per_week) Betreuung täglich ab => status_flag(daily_caretime_from) Betreuung täglich bis => status_flag(daily_caretime_to)