Dynasite ER Diagram

Dynasite, the Zcore content management system, saves data used to render forms in the following tables in the admin database:

• form - metadata about the form, including the form's table name
• page_item - used for display properties of each form element
• form_field - data type, field name in form's table
• field_enumeration - values for fields that are of enum datatype. Used for dropdowns. Also stores the numeric value used to calculate rule outcomes.

Upon startup of the application, a servlet deserializes XML files that contain graphs of the form objects, which are stored in these tables. These form graphs stay in memory - the app does not need to hit the database to render the form display.

Entity-relationship diagram of the Dynasite (form-rendering tables in the Admin schema of the database):

These tables are in the Admin schema in the standalone and in the Admin database in the server (MySQL) version.

Entity-relationship diagram of the Dynasite- 2007 MySQL version. Rule_definition_params are now merged with the rule_definition table.