==============================================
Suggested changes to Solutions database tables
==============================================

#. auto_increment

   Add auto_increment option to all primary keys (of integer type).


#. Booleans

   Use the same datatype for all database columns containing boolean
   values.  MySQL's "boolean" type is preferred.


#. Time datatypes

   Use DATE when only a date is needed, use TIME when only a
   time-of-day is needed, use DATETIME when both are required.


#. Documentation

   We need documentation of all tables and fields, containing
   information of what all these tables and fields represent, and what
   values are allowed, including if NULL is an acceptable value.
   Also, which fields refer to keys in other tables.


#. Avoid repeated fields

   Avoid repeated columns in tables for the purpose of specifying a
   list of resources.  In stead use an additional table to implement a
   many-to-many relation.

   Examples:

      tbl1_EmailTemplates: file_attachmentX, applies_to_roleX

      tbl1_CourseFormats: default_roleX, default_numberX

      tbl1_FinalExamRooms: roomX, roomX_capacity


#. Fields of tbl1_FinalExamRooms

   Simplify the columns in this table.

   For example,the fields exam_date_and_start_time, exam_date,
   exam_start_time might be redundant?

   The fields roomX could be implemented by another table with columns
   (ID, ROOM), where ID refers to tbl1_FinalExamRooms and ROOM refers
   to tbl1_Rooms.

   I imageine that roomX_capacity is the number of students that the
   room has space for in an exam situation?  Does this change from
   year to year?  If not, then perhaps add a column 'exam_capacity' to
   tbl_Rooms?


#. Transfer local tables to MySQL server

   Whenever local tables in Access will be useful to other programs,
   move them to the MySQL database.