Database

Differences of the database

• In ungrad, all ID fields are 36 Characters. This is the length of standard conformant UUIDv4 ID’s.

• For consultations, not onky the date, but also the time is stored. This allows for better and more consistent ordering of consultations.

• User names are case insensitive. Passwords remain case sensitive, of course.

An SQL script to convert an Elexis Database (from version 3.4 or above) to an ungrad database is here. The reverse should not be necessary since the ungrad extensions do not make the database incompatible.