|
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
}