This appendix contains conceptual database models of the Urchin application. Both images are stored on the electronic disc attached to this work. Database models are not available in the electronic version of thesis.

E.1 Core Application

The first diagram displays database tables of the core application and their relations. All core tables are prefixed a_* after the first letter of the alphabet. The picture shows three main areas already described in the text, the page axis, the component axis, and the permission system together with several interjecting tables. For the reasons of clarity and simplicity, tables with translated terms are not included. These tables contain translations of static terms, such as module name or page states.

E.2 Content Modules

The second diagram shows database structure of all basic content modules. This set of content modules is always available in the Urchin installation. On the database level, each module consists of one main table that inherits a_element table, one view, and zero or more additional tables. Module table are prefixed m_*, views are prefixed v_*. Relations to the system modules are also shown if present. Basic modules Search and Sitemap do not require any database tables and are not shown in the schema.