Database format

The database includes several tables (some may not be used) :

Table Contenu
PUPILS pupils
STUDENTS students
STAFF teachers
STAFF1 other staff
STAFF2 other staff

All tables have the following fields ( columns ), and may contain others :

Champs Type Information db2dir-generated contents
NAME Text name no
FIRSTNAME Text first name no
GROUP Text group information ( form, subject, ...) no
ID Text id (login) yes
PASSWORD Text password yes
SELECTION Boolean selects record for selecive actions yes
PROTECTION Boolean protects against password overwrite yes