Database Schema

The Zcore database, which is named zeprs, can be divided up into the following sections:

• Dynasite -data used to render forms/fields/enumerations
• Encounters - stores data about encounters
• Permissions - users/groups

You may view a version of the ZEPRS schema created on 10 October 2008 using SQLYog as well as follow the links below to get more information about ZEPRS database design.

Please note that some of the form fields in zeprs are shared - used in other forms. (Screencast on shared fields) Unfortunately, the form listing (zeprs_fields.xls) does not display shared fields. The simple listing of form field labels to tables (zeprs_shared_fields.xls attached below) may be useful in associating shared fields to tables.

The Derby Database Schema section has updated information on the schema used in the standalone.