DB format

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

NOTES

If no database is available, db2dir generates a MDB file et registers it in ODBC.
The database can concurrently be used by another DBMS (for instance the Jet engine for MDB databases can support simultaneous use of Access).
In the distribution a script is provided to make a MySQL database.
The tables may contain other columns.