Prüfungsamt-Projekt
1.0.0
|
{ {"id", "Nummer", "Kennung"}, {"zaehler", "Zähler", "Zähler"}, {"strasse", "Straße", "Straße und Hausnummer"}, {"ort", "Ort", "Ort"}, {"plz", "PLZ", "Postleitzahl"}, {"land", "Land", "Land"}, {"telefon1", "Telefon 1", "1. Telefon-Nummer"}, {"telefon2", "Telefon 2", "2. Telefon-Nummer"}, {"fax", "Telefax", "Telefax-Nummer"}, {"email", "EMail", "EMail-Adresse"}, {"adr_typ", "Typ", "Adreß-Typ"}, {"sonstiges", "Sonstiges", "Sonstiges"}, {"raum", "Raum", "Raum"}, {"adr_typ", "Typ", "Adreß-Typ"}, {"pers_adressen", "Adresse", "Tupel der Adressen-Tabelle"} }
const SelectEntry Adressen_SelectEntries[] |
{ {"adr_typ", "adr_typ", "adr_txt", true, &Adresstypen_ViewTable}, }
const ViewEntry Adressen_ViewEntries[] |
{ { "Alle Adressen", "pers_adressen", "ort", 0, NULL, sizeof(Adressen_SelectEntries) / sizeof(SelectEntry), (const SelectEntry*)&Adressen_SelectEntries, sizeof(Adressen_DescriptionEntries) / sizeof(DescriptionEntry), (const DescriptionEntry*)&Adressen_DescriptionEntries } }
const ViewTable Adressen_ViewTable |
{ {"id", "zaehler", NULL, NULL, NULL}, "pers_adressen", "Pixmaps/Adressen.xpm", sizeof(Adressen_ViewEntries) / sizeof(ViewEntry), (const ViewEntry*)&Adressen_ViewEntries }
{ {"adr_typ", "Typ", "Adreß-Typ"}, {"adr_txt", "Beschreibung", "Beschreibung"}, {"typ_adressen", "Adreßtyp", "Tupel der Adreßtypen-Tabelle"} }
const ViewEntry Adresstypen_ViewEntries[] |
{ { "Alle Adreßtypen", "typ_adressen", "adr_typ", 0, NULL, 0, NULL, sizeof(Adresstypen_DescriptionEntries) / sizeof(DescriptionEntry), (const DescriptionEntry*)&Adresstypen_DescriptionEntries } }
{ {"adr_typ", NULL, NULL, NULL, NULL}, "typ_adressen", "Pixmaps/Adreßtypen.xpm", sizeof(Adresstypen_ViewEntries) / sizeof(ViewEntry), (const ViewEntry*)&Adresstypen_ViewEntries }
{ {"stud_id", "MatrNr", "Matrikelnummer"}, {"typ_id", "Typ", "Typ"}, {"gew_pruefer_id", "Gew.Pr.", "Gewünschter Prüfer"}, {"datum", "Datum", "Datum"}, {"versuch", "Versuch", "Versuch"}, {"zaehler", "Zähler", "Zähler"}, {"thema", "Thema", "Thema"}, {"anmelde_datum", "Anmeldung", "Datum der Anmeldung"}, {"abgabe_datum", "Abgabe", "Datum der Abgabe"}, {"abgabe_limit", "Abgabe-Limit", "Abgabe-Limit"}, {"ausgabe_datum", "Ausgabe", "Datum der Ausgabe"}, {"pruefer1_id", "1.Prüfer", "Erster Prüfer"}, {"pruefer2_id", "2.Prüfer", "Zweiter Prüfer"}, {"status_id", "Status", "Status"}, {"note", "Note", "Note"}, {"bemerkung", "Bemerkung", "Bemerkung"}, {"uni_diplarbeit", "Diplomarbeit", "Tupel der Diplomarbeiten-Tabelle"} }
{ {"gew_pruefer_id", "pers_id", "vorname, name, pers_id", false, &Pruefer_ViewTable}, {"pruefer1_id", "pers_id", "vorname, name, pers_id", false, &Pruefer_ViewTable}, {"pruefer2_id", "pers_id", "vorname, name, pers_id", false, &Pruefer_ViewTable}, {"status_id", "status_typ", "status_txt", true, &Pruefungsstatus_ViewTable}, {"stud_id", "stud_id", "vorname, name, stud_id", false, &Studenten_ViewTable} }
const ViewEntry Diplomarbeiten_ViewEntries[] |
{ {"stud_id", "versuch", "zaehler", NULL, NULL}, "uni_diplarbeit", "Pixmaps/Diplomarbeiten.xpm", sizeof(Diplomarbeiten_ViewEntries) / sizeof(ViewEntry), (const ViewEntry*)&Diplomarbeiten_ViewEntries }
{ {"stud_id", "MatrNr", "Matrikelnummer"}, {"pers_id", "PersNr", "Personalnummer"}, {"datum", "Datum", "Datum"}, {"titel", "Titel", "Titel"}, {"bemerkung", "Bemerkung", "Bemerkung"}, {"qal_typ", "Qualifikation", "Qualifikations-Art"}, {"uni_qualifikate", "Leistungsnachweis", "Tupel der Leistungsnachweise-Tabelle"} }
{ {"qal_typ", "qal_typ", "qal_txt", false, &Qualifikattypen_ViewTable}, {"pers_id", "pers_id", "vorname, name, pers_id", false, &Pruefer_ViewTable}, {"stud_id", "stud_id", "vorname, name, stud_id", false, &Studenten_ViewTable} }
{ { "Alle Leistungsnachweise", "uni_qualifikate", "datum", 0, NULL, sizeof(Leistungsnachweise_SelectEntries) / sizeof(SelectEntry), (const SelectEntry*)&Leistungsnachweise_SelectEntries, sizeof(Leistungsnachweise_DescriptionEntries) / sizeof(DescriptionEntry), (const DescriptionEntry*)&Leistungsnachweise_DescriptionEntries } }
{ {"stud_id", "qal_typ", "datum", "titel", NULL}, "uni_qualifikate", "Pixmaps/Leistungsnachweise.xpm", sizeof(Leistungsnachweise_ViewEntries) / sizeof(ViewEntry), (const ViewEntry*)&Leistungsnachweise_ViewEntries }
struct OptimizeTable PADB_OptimizeTable |
{ sizeof(PADB_OptimizeTableEntries) / sizeof(const char*), (const char**)&PADB_OptimizeTableEntries }
Optimierungstabelle.
const char* PADB_OptimizeTableEntries[] |
{ "uni_pruefungen", "uni_diplarbeit", "uni_studium", "uni_qualifikate", "pers_studenten", "pers_pruefer", "pers_adressen", "typ_qualifikate", "typ_prfstatus", "typ_pruefung", "typ_adressen", "typ_studium" }
{ {"pers_id", "PersNr", "Personalnummer"}, {"name", "Name", "Nachname"}, {"vorname", "Vorname", "Vorname"}, {"m_w", "M/W", "Männlich/Weiblich"}, {"titel", "Titel", "Titel"}, {"rang", "Rang", "Rang"}, {"einstellung_datum", "Einstellung", "Datum der Einstellung"}, {"pensionierung_datum", "Pensionierung", "Datum der Pensionierung"}, {"pers_pruefer", "Prüfer", "Tupel der Prüfer-Tabelle"} }
const JoinEntry Pruefer_JoinEntries[] |
{ {"pers_id", "pers_id", "Leistungsnachweise", &Leistungsnachweise_ViewTable}, {"pers_id", "pruefer_id", "Prüfer", &Pruefungen_ViewTable}, {"pers_id", "beisitz_id", "Beisitzer", &Pruefungen_ViewTable}, {"pers_id", "pruefer1_id", "1. Prüfer DA", &Diplomarbeiten_ViewTable}, {"pers_id", "pruefer2_id", "2. Prüfer DA", &Diplomarbeiten_ViewTable}, {"pers_id", "id", "Adressen", &Adressen_ViewTable} }
const ViewEntry Pruefer_ViewEntries[] |
{ { "Alle Prüfer", "pers_pruefer", "name, vorname, titel", sizeof(Pruefer_JoinEntries) / sizeof(JoinEntry), (const JoinEntry*)&Pruefer_JoinEntries, 0, NULL, sizeof(Pruefer_DescriptionEntries) / sizeof(DescriptionEntry), (const DescriptionEntry*)&Pruefer_DescriptionEntries }, { "Vorhandene Prüfer", "pers_pruefer_np", "name, vorname, titel", sizeof(Pruefer_JoinEntries) / sizeof(JoinEntry), (const JoinEntry*)&Pruefer_JoinEntries, 0, NULL, sizeof(Pruefer_DescriptionEntries) / sizeof(DescriptionEntry), (const DescriptionEntry*)&Pruefer_DescriptionEntries }, { "Pensionierte Prüfer", "pers_pruefer_pe", "name, vorname, titel", sizeof(Pruefer_JoinEntries) / sizeof(JoinEntry), (const JoinEntry*)&Pruefer_JoinEntries, 0, NULL, sizeof(Pruefer_DescriptionEntries) / sizeof(DescriptionEntry), (const DescriptionEntry*)&Pruefer_DescriptionEntries } }
const ViewTable Pruefer_ViewTable |
{ {"pers_id", NULL, NULL, NULL, NULL}, "pers_pruefer", "Pixmaps/Prüfer.xpm", sizeof(Pruefer_ViewEntries) / sizeof(ViewEntry), (const ViewEntry*)&Pruefer_ViewEntries }
{ {"stud_id", "MatrNr", "Matrikelnummer"}, {"typ_id", "Typ", "Typ"}, {"gew_pruefer_id", "Gew.Pr.", "Gewünschter Prüfer"}, {"pruefer_id", "Prüfer", "Prüfer"}, {"beisitz_id", "Beisitzer", "Beisitzer"}, {"anmelde_datum", "Anmeldung", "Datum der Anmeldung"}, {"thema", "Thema", "Thema"}, {"datum", "Datum", "Datum"}, {"versuch", "Versuch", "Versuch"}, {"zaehler", "Zähler", "Zähler"}, {"status_id", "Status", "Status"}, {"note", "Note", "Note"}, {"bemerkung", "Bemerkung", "Bemerkung"}, {"uni_pruefungen", "Prüfung", "Tupel der Prüfungen-Tabelle"} }
const SelectEntry Pruefungen_SelectEntries[] |
{ {"typ_id", "prf_typ", "prf_txt", true, &Pruefungstypen_ViewTable}, {"status_id", "status_typ", "status_txt", true, &Pruefungsstatus_ViewTable}, {"pruefer_id", "pers_id", "vorname, name, pers_id", false, &Pruefer_ViewTable}, {"beisitz_id", "pers_id", "vorname, name, pers_id", false, &Pruefer_ViewTable}, {"gew_pruefer_id", "pers_id", "vorname, name, pers_id", false, &Pruefer_ViewTable}, {"stud_id", "stud_id", "vorname, name, stud_id", false, &Studenten_ViewTable} }
const ViewEntry Pruefungen_ViewEntries[] |
{ {"stud_id", "typ_id", "versuch", "zaehler", NULL}, "uni_pruefungen", "Pixmaps/Prüfungen.xpm", sizeof(Pruefungen_ViewEntries) / sizeof(ViewEntry), (const ViewEntry*)&Pruefungen_ViewEntries }
{ {"status_typ", "Status", "Prüfungsstatus-Typ"}, {"status_txt", "Beschreibung", "Beschreibung"}, {"status_gewertet_bestanden", "Bestanden?", "Prüfung wird als bestanden gewertet"}, {"status_gewertet_nichtbestanden", "Nicht bestanden?", "Prüfung wird als nicht bestanden gewertet"}, {"typ_prfstatus", "Prüfungsstatus", "Tupel der Prüfungsstatus-Tabelle"} }
const ViewEntry Pruefungsstatus_ViewEntries[] |
{ { "Alle Pruefungsstatus", "typ_prfstatus", "status_typ", 0, NULL, 0, NULL, sizeof(Pruefungsstatus_DescriptionEntries) / sizeof(DescriptionEntry), (const DescriptionEntry*)&Pruefungsstatus_DescriptionEntries } }
{ {"status_typ", NULL, NULL, NULL,NULL}, "typ_prfstatus", "Pixmaps/Prüfungsstatus.xpm", sizeof(Pruefungsstatus_ViewEntries) / sizeof(ViewEntry), (const ViewEntry*)&Pruefungsstatus_ViewEntries }
{ {"prf_typ", "Typ", "Prüfungs-Typ"}, {"prf_txt", "Beschreibung", "Beschreibung"}, {"typ_pruefung", "Prüfungstyp", "Tupel der Prüfungstypen-Tabelle"} }
const ViewEntry Pruefungstypen_ViewEntries[] |
{ { "Alle Pruefungstypen", "typ_pruefung", "prf_typ", 0, NULL, 0, NULL, sizeof(Pruefungstypen_DescriptionEntries) / sizeof(DescriptionEntry), (const DescriptionEntry*)&Pruefungstypen_DescriptionEntries } }
{ {"prf_typ", NULL, NULL, NULL, NULL}, "typ_pruefung", "Pixmaps/Prüfungstypen.xpm", sizeof(Pruefungstypen_ViewEntries) / sizeof(ViewEntry), (const ViewEntry*)&Pruefungstypen_ViewEntries }
Sichtentabelle für Pruefungstypen.
{ {"qal_typ", "Art", "Qualifikations-Art"}, {"qal_grp", "Gruppe", "Gruppe"}, {"qal_txt", "Beschreibung", "Beschreibung"}, {"typ_qualifikate", "Qualifikation", "Tupel der Qualifikattypen-Tabelle"} }
const ViewEntry Qualifikattypen_ViewEntries[] |
{ { "Alle Qualifikattypen","typ_qualifikate","qal_grp, qal_txt", 0, NULL, 0, NULL, sizeof(Qualifikattypen_DescriptionEntries) / sizeof(DescriptionEntry), (const DescriptionEntry*)&Qualifikattypen_DescriptionEntries } }
{ {"qal_typ", NULL, NULL, NULL, NULL}, "typ_qualifikate", "Pixmaps/Qualifikattypen.xpm", sizeof(Qualifikattypen_ViewEntries) / sizeof(ViewEntry), (const ViewEntry*)&Qualifikattypen_ViewEntries }
Sichtentabelle für Qualifikattypen.
{ {"semester_txt", "Beschreibung", "Beschreibung"} }
const ViewEntry Semestertext_ViewEntries[] |
{ { "Alle Semestertexte", "typ_semestertxt", "semester_txt", 0, NULL, 0, NULL, sizeof(Semestertext_DescriptionEntries) / sizeof(DescriptionEntry), (const DescriptionEntry*)&Semestertext_DescriptionEntries } }
{ {"semester_txt", NULL, NULL, NULL, NULL}, "typ_semestertxt", "Pixmaps/Semestertext.xpm", sizeof(Semestertext_ViewEntries) / sizeof(ViewEntry), (const ViewEntry*)&Semestertext_ViewEntries }
const ViewEntry Statistiken_ViewEntries[] |
{ {NULL, NULL, NULL, NULL, NULL}, "(null)", "Pixmaps/Statistik.xpm", sizeof(Statistiken_ViewEntries) / sizeof(ViewEntry), (const ViewEntry*)&Statistiken_ViewEntries }
Sichtentabelle für Statistiken.
{ {"stud_id", "MatrNr", "Matrikelnummer"}, {"name", "Name", "Nachname"}, {"vorname", "Vorname", "Vorname"}, {"m_w", "M/W", "Männlich/Weiblich"}, {"geb_datum", "GebDatum", "Geburtsdatum"}, {"geb_ort", "GebOrt", "Geburtsort"}, {"semester", "Semester", "Semester"}, {"immat_datum", "Immatrikulation", "Datum der Immatrikulation"}, {"exmat_datum", "Exmatrikulation", "Datum der Exmatrikulation"}, {"nebenfach", "Nebenfach", "Nebenfach"}, {"pers_studenten", "Student", "Tupel der Studenten-Tabelle"} }
const JoinEntry Studenten_JoinEntries[] |
{ {"stud_id", "stud_id", "Leistungsnachweise", &Leistungsnachweise_ViewTable}, {"stud_id", "stud_id", "Prüfungen", &Pruefungen_ViewTable}, {"stud_id", "stud_id", "Diplomarbeit", &Diplomarbeiten_ViewTable}, {"stud_id", "id", "Adressen", &Adressen_ViewTable}, {"stud_id", "stud_id", "Studium", &Studium_ViewTable} }
const ViewEntry Studenten_ViewEntries[] |
const ViewTable Studenten_ViewTable |
{ {"stud_id",NULL,NULL,NULL,NULL}, "pers_studenten", "Pixmaps/Studenten.xpm", sizeof(Studenten_ViewEntries) / sizeof(ViewEntry), (const ViewEntry*)&Studenten_ViewEntries }
{ {"studium_typ", "Studientyp", "Studientyp"}, {"studium_txt", "Beschreibung", "Beschreibung"}, {"typ_studium", "Studientyp", "Tupel der Studientypen-Tabelle"} }
const ViewEntry Studientypen_ViewEntries[] |
{ { "Alle Studiumstypen", "typ_studium", "studium_typ", 0, NULL, 0, NULL, sizeof(Studientypen_DescriptionEntries) / sizeof(DescriptionEntry), (const DescriptionEntry*)&Studientypen_DescriptionEntries } }
{ {"studium_typ", NULL, NULL, NULL, NULL}, "typ_studium", "Pixmaps/Studientypen.xpm", sizeof(Studientypen_ViewEntries) / sizeof(ViewEntry), (const ViewEntry*)&Studientypen_ViewEntries }
{ {"stud_id", "MatrNr", "Matrikelnummer"}, {"semester", "Semester", "Semester"}, {"studien_typ", "Studientyp", "Studientyp"}, {"uni_studium", "Studium", "Tupel der Studium-Tabelle"} }
const SelectEntry Studium_SelectEntries[] |
{ {"studien_typ", "studium_typ", "studium_txt", true, &Studientypen_ViewTable}, {"semester", "semester_txt", "semester_txt", true, &Semestertext_ViewTable}, {"stud_id", "stud_id", "vorname, name, stud_id", false, &Studenten_ViewTable} }
const ViewEntry Studium_ViewEntries[] |
{ { "Gesamt", "uni_studium", "semester", 0, NULL, sizeof(Studium_SelectEntries) / sizeof(SelectEntry), (const SelectEntry*)&Studium_SelectEntries, sizeof(Studium_DescriptionEntries) / sizeof(DescriptionEntry), (const DescriptionEntry*)&Studium_DescriptionEntries } }
const ViewTable Studium_ViewTable |
{ {"stud_id", "semester", NULL, NULL, NULL}, "uni_studium", "Pixmaps/Studium.xpm", sizeof(Studium_ViewEntries) / sizeof(ViewEntry), (const ViewEntry*)&Studium_ViewEntries }