Database

Submitted by ckelley on Thu, 10/30/2008 - 12:27

Two different databases are used in Zcore:

  • Standalone: Derby
  • Server: MySQL

Most of the information in the following section applies to the standalone implementation of Zcore; however, the concepts apply to both targets. Information that specifically applies to the server database schema is in the ZEPRS Documentation book.

The Derby database, which is stored in the "databases/zeprs" directory off the main application root, has two schemas:

  • Admin - Stores data used to render forms and manage application updates
  • App - Stores data entered via the application by users.

Click the links on the two schema names above for detailed information.